Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • obtang number of cases for congressional districts

    obtaing number of cases for a variable

    I have a survwy data set tat includes the congreessional district with a variable I have aed cdstat, ncoded to be a floating variable. I cannot determine how mnny cases all into each district. To get rasonable estimate in an aggregate analysis I need at least 40 cases per district. How do I get a measure of the number of cases in each district? I

    the cdstate variable for the cdstate is:

    56863. WA02
    56864. WA02
    56865. WA02
    56866. WA02
    56867. WA02
    56868. WA02
    56869. WA02
    56870. WA02
    56871. WA02
    56872. WA02
    56873. WA02
    56874. WA02
    56875. WA02
    56876. WA02
    56877. WA02
    56878. WA02
    56879. WA02
    56880. WA02
    56881. WA02
    56882. WA02
    56883. WA02
    56884. WA02
    56885. WA02
    56886. WA02
    56887. WA02
    56888. WA02
    56889. WA02
    56890. WA02
    56891. WA02
    56892. WA02
    56893. WA02
    56894. WA02
    56895. WA02
    56896. WA02
    56897. WA02
    56898. WA02
    56899. WA02
    56900. WA02
    56901. WA02
    56902. WA02
    56903. WA02
    56904. WA02
    56905. WA02
    56906. WA02
    56907. WA02
    56908. WA02
    56909. WA02
    56910. WA02
    56911. WA02
    56912. WA02
    56913. WA02
    56914. WA02
    56915. WA02
    56916. WA02
    56917. WA02
    56918. WA02
    56919. WA02
    56920. WA02
    56921. WA02
    56922. WA02
    56923. WA02
    56924. WA02
    56925. WA02
    56926. WA02
    56927. WA02
    56928. WA02
    56929. WA02
    56930. WA02
    56931. WA02
    56932. WA02
    56933. WA02
    56934. WA02
    56935. WA02
    56936. WA02
    56937. WA02
    56938. WA02
    56939. WA02
    56940. WA02
    56941. WA02
    56942. WA02
    56943. WA02
    56944. WA02
    56945. WA02
    56946. WA02
    56947. WA02
    56948. WA02
    56949. WA02
    56950. WA02
    56951. WA02
    56952. WA02
    56953. WA02
    56954. WA02
    56955. WA02
    56956. WA02
    56957. WA02
    56958. WA02
    56959. WA02
    56960. WA02
    56961. WA02
    56962. WA02
    56963. WA02
    56964. WA02
    56965. WA02
    56966. WA02
    56967. WA02
    56968. WA02
    56969. WA02
    56970. WA02
    56971. WA02
    56972. WA02
    56973. WA02
    56974. WA02
    56975. WA02
    56976. WA02
    56977. WA02
    56978. WA02
    56979. WA02
    56980. WA02
    56981. WA02
    56982. WA02
    56983. WA02
    56984. WA02
    56985. WA02
    56986. WA03
    56987. WA03
    56988. WA03
    56989. WA03
    56990. WA03
    56991. WA03
    56992. WA03
    56993. WA03
    56994. WA03
    56995. WA03
    56996. WA03
    56997. WA03
    56998. WA03
    56999. WA03
    57000. WA03
    57001. WA03
    57002. WA03
    57003. WA03
    57004. WA03
    57005. WA03
    57006. WA03
    57007. WA03
    57008. WA03
    57009. WA03
    57010. WA03
    57011. WA03
    57012. WA03
    57013. WA03
    57014. WA03
    57015. WA03
    57016. WA03
    57017. WA03
    57018. WA03
    57019. WA03
    57020. WA03
    57021. WA03
    57022. WA03
    57023. WA03
    57024. WA03
    57025. WA03
    57026. WA03
    57027. WA03
    57028. WA03
    57029. WA03
    57030. WA03
    57031. WA03
    57032. WA03
    57033. WA03
    57034. WA03
    57035. WA03
    57036. WA03
    57037. WA03
    57038. WA03
    57039. WA03
    57040. WA03
    57041. WA03
    57042. WA03
    57043. WA03
    57044. WA03
    57045. WA03
    57046. WA03
    57047. WA03
    57048. WA03
    57049. WA03
    57050. WA03
    57051. WA03
    57052. WA03
    57053. WA03
    57054. WA03
    57055. WA03
    57056. WA03
    57057. WA03
    57058. WA03
    57059. WA03
    57060. WA03
    57061. WA03
    57062. WA03
    57063. WA03
    57064. WA03
    57065. WA03
    57066. WA03
    57067. WA03
    57068. WA03
    57069. WA03
    57070. WA03
    57071. WA03
    57072. WA03
    57073. WA03
    57074. WA03
    57075. WA03
    57076. WA03
    57077. WA03
    57078. WA03
    57079. WA03
    57080. WA03
    57081. WA03
    57082. WA03
    57083. WA03
    57084. WA03
    57085. WA03
    57086. WA03
    57087. WA03
    57088. WA03
    57089. WA04
    57090. WA04
    57091. WA04
    57092. WA04
    57093. WA04
    57094. WA04
    57095. WA04
    57096. WA04
    57097. WA04
    57098. WA04
    57099. WA04
    57100. WA04
    57101. WA04
    57102. WA04
    57103. WA04
    57104. WA04
    57105. WA04
    57106. WA04
    57107. WA04
    57108. WA04
    57109. WA04
    57110. WA04
    57111. WA04
    57112. WA04
    57113. WA04
    57114. WA04
    57115. WA04
    57116. WA04
    57117. WA04
    57118. WA04
    57119. WA04
    57120. WA04
    57121. WA04
    57122. WA04
    57123. WA04
    57124. WA04
    57125. WA04
    57126. WA04
    57127. WA04
    57128. WA04
    57129. WA04
    57130. WA04
    57131. WA04
    57132. WA04
    57133. WA04
    57134. WA04
    57135. WA05
    57136. WA05
    57137. WA05
    57138. WA05
    57139. WA05
    57140. WA05
    57141. WA05
    57142. WA05
    57143. WA05
    57144. WA05
    57145. WA05
    57146. WA05
    57147. WA05
    57148. WA05
    57149. WA05
    57150. WA05
    57151. WA05
    57152. WA06
    57153. WA06
    57154. WA06
    57155. WA06
    57156. WA06
    57157. WA06
    57158. WA06
    57159. WA06
    57160. WA06
    57161. WA06
    57162. WA06
    57163. WA06
    57164. WA06
    57165. WA06
    57166. WA06
    57167. WA06
    57168. WA06
    57169. WA06
    57170. WA06
    57171. WA06
    57172. WA06
    57173. WA06
    57174. WA06
    57175. WA06
    57176. WA06
    57177. WA06
    57178. WA06
    57179. WA06
    57180. WA06
    57181. WA06
    57182. WA06
    57183. WA06
    57184. WA06
    57185. WA06
    57186. WA06
    57187. WA06
    57188. WA06
    57189. WA06
    57190. WA06
    57191. WA06
    57192. WA06
    57193. WA06
    57194. WA06
    57195. WA06
    57196. WA06
    57197. WA06
    57198. WA06
    57199. WA06
    57200. WA06
    57201. WA06
    57202. WA06
    57203. WA06
    57204. WA06
    57205. WA06
    57206. WA06
    57207. WA06
    57208. WA06
    57209. WA06
    57210. WA06
    57211. WA06
    57212. WA06
    57213. WA06
    57214. WA06
    57215. WA06
    57216. WA06
    57217. WA06
    57218. WA06
    57219. WA06
    57220. WA06
    57221. WA06
    57222. WA06
    57223. WA06
    57224. WA06
    57225. WA06
    57226. WA06
    57227. WA06
    57228. WA06
    57229. WA06
    57230. WA06
    57231. WA06
    57232. WA06
    57233. WA06
    57234. WA06
    57235. WA06
    57236. WA06
    57237. WA06
    57238. WA06
    57239. WA06
    57240. WA06
    57241. WA06
    57242. WA06
    57243. WA06
    57244. WA06
    57245. WA06
    57246. WA06
    57247. WA06
    57248. WA06
    57249. WA06
    57250. WA06
    57251. WA06
    57252. WA06
    57253. WA06
    57254. WA07
    57255. WA07
    57256. WA07
    57257. WA07
    57258. WA07
    57259. WA07
    57260. WA07
    57261. WA07
    57262. WA07
    57263. WA07
    57264. WA07
    57265. WA07
    57266. WA07
    57267. WA07
    57268. WA07
    57269. WA07
    57270. WA07
    57271. WA07
    57272. WA07
    57273. WA07
    57274. WA07
    57275. WA07
    57276. WA07
    57277. WA07
    57278. WA07
    57279. WA07
    57280. WA07
    57281. WA07
    57282. WA07
    57283. WA07
    57284. WA07
    57285. WA07
    57286. WA07
    57287. WA07
    57288. WA07
    57289. WA07
    57290. WA07
    57291. WA07
    57292. WA07
    57293. WA07
    57294. WA07
    57295. WA07
    57296. WA07
    57297. WA07
    57298. WA07
    57299. WA07
    57300. WA07
    57301. WA07
    57302. WA07
    57303. WA07
    57304. WA07
    57305. WA07
    57306. WA07
    57307. WA07
    57308. WA07
    57309. WA07
    57310. WA07
    57311. WA07
    57312. WA07
    57313. WA07
    57314. WA07
    57315. WA07
    57316. WA07
    57317. WA07
    57318. WA07
    57319. WA07
    57320. WA07
    57321. WA07
    57322. WA07
    57323. WA07
    57324. WA07
    57325. WA07
    57326. WA07
    57327. WA07
    57328. WA07
    57329. WA07
    57330. WA07
    57331. WA07
    57332. WA07
    57333. WA07
    57334. WA07
    57335. WA07
    57336. WA07
    57337. WA07
    57338. WA07
    57339. WA07
    57340. WA07
    57341. WA07
    57342. WA07
    57343. WA07
    57344. WA07
    57345. WA07
    57346. WA07
    57347. WA07
    57348. WA07
    57349. WA07
    57350. WA07
    57351. WA07
    57352. WA07
    57353. WA07
    57354. WA07
    57355. WA07
    57356. WA07
    57357. WA07
    57358. WA07
    57359. WA07
    57360. WA07
    57361. WA07
    57362. WA07
    57363. WA07
    57364. WA07
    57365. WA07
    57366. WA07
    57367. WA07
    57368. WA07
    57369. WA07
    57370. WA07
    57371. WA07
    57372. WA07
    57373. WA07
    57374. WA07
    57375. WA07
    57376. WA07
    57377. WA07
    57378. WA07
    57379. WA07
    57380. WA07
    57381. WA07
    57382. WA07
    57383. WA07
    57384. WA07
    57385. WA07
    57386. WA07
    57387. WA07
    57388. WA07
    57389. WA07
    57390. WA07
    57391. WA07
    57392. WA07
    57393. WA07
    57394. WA07
    57395. WA07
    57396. WA07
    57397. WA07
    57398. WA07
    57399. WA07
    57400. WA07
    57401. WA07
    57402. WA07
    57403. WA07
    57404. WA07
    57405. WA07
    57406. WA07
    57407. WA07
    57408. WA07
    57409. WA07
    57410. WA07
    57411. WA07
    57412. WA07
    57413. WA07
    57414. WA07
    57415. WA07
    57416. WA07
    57417. WA07
    57418. WA07
    57419. WA07
    57420. WA07
    57421. WA07
    57422. WA07
    57423. WA07
    57424. WA07
    57425. WA07
    57426. WA07
    57427. WA07
    57428. WA07
    57429. WA07
    57430. WA07
    57431. WA07
    57432. WA07
    57433. WA07
    57434. WA07
    57435. WA07
    57436. WA07
    57437. WA07
    57438. WA07
    57439. WA07
    57440. WA07
    57441. WA07
    57442. WA07
    57443. WA07
    57444. WA07
    57445. WA07
    57446. WA07
    57447. WA07
    57448. WA07
    57449. WA07
    57450. WA07
    57451. WA07
    57452. WA07
    57453. WA07
    57454. WA07
    57455. WA07
    57456. WA07
    57457. WA07
    57458. WA07
    57459. WA07
    57460. WA07
    57461. WA07
    57462. WA07
    57463. WA07
    57464. WA07
    57465. WA07
    57466. WA07
    57467. WA07
    57468. WA07
    57469. WA07
    57470. WA07
    57471. WA07
    57472. WA07
    57473. WA07
    57474. WA07
    57475. WA07
    57476. WA07
    57477. WA07
    57478. WA07
    57479. WA07
    57480. WA07
    57481. WA07
    57482. WA07
    57483. WA07
    57484. WA07
    57485. WA07
    57486. WA07
    57487. WA07
    57488. WA07
    57489. WA07
    57490. WA07
    57491. WA07
    57492. WA08
    57493. WA08
    57494. WA08
    57495. WA08
    57496. WA08
    57497. WA08
    57498. WA08
    57499. WA08
    57500. WA08
    57501. WA08
    57502. WA08
    57503. WA08
    57504. WA08
    57505. WA08
    57506. WA08
    57507. WA08
    57508. WA08
    57509. WA08
    57510. WA08
    57511. WA08
    57512. WA08
    57513. WA08
    57514. WA08
    57515. WA08
    57516. WA08
    57517. WA08
    57518. WA08
    57519. WA08
    57520. WA08
    57521. WA08
    57522. WA08
    57523. WA08
    57524. WA08
    57525. WA08
    57526. WA08
    57527. WA08
    57528. WA08
    57529. WA08
    57530. WA08
    57531. WA08
    57532. WA08
    57533. WA08
    57534. WA08
    57535. WA08
    57536. WA08
    57537. WA08
    57538. WA08
    57539. WA08
    57540. WA08
    57541. WA08
    57542. WA08
    57543. WA08
    57544. WA08
    57545. WA08
    57546. WA08
    57547. WA08
    57548. WA08
    57549. WA08
    57550. WA08
    57551. WA08
    57552. WA08
    57553. WA08
    57554. WA08
    57555. WA08
    57556. WA08
    57557. WA08
    57558. WA08
    57559. WA08
    57560. WA08
    57561. WA08
    57562. WA08
    57563. WA08
    57564. WA08
    57565. WA08
    57566. WA08
    57567. WA08
    57568. WA08
    57569. WA08
    57570. WA08
    57571. WA08
    57572. WA08
    57573. WA08
    57574. WA08
    57575. WA08
    57576. WA08
    57577. WA08
    57578. WA08
    57579. WA08
    57580. WA08
    57581. WA08
    57582. WA08
    57583. WA09
    57584. WA09
    57585. WA09
    57586. WA09
    57587. WA09
    57588. WA09
    57589. WA09
    57590. WA09
    57591. WA09
    57592. WA09
    57593. WA09
    57594. WA09
    57595. WA09
    57596. WA09
    57597. WA09
    57598. WA09
    57599. WA09
    57600. WA09
    57601. WA09
    57602. WA09
    57603. WA09
    57604. WA09
    57605. WA09
    57606. WA09
    57607. WA09
    57608. WA09
    57609. WA09
    57610. WA09
    57611. WA09
    57612. WA09
    57613. WA09
    57614. WA09
    57615. WA09
    57616. WA09
    57617. WA09
    57618. WA09
    57619. WA09
    57620. WA09
    57621. WA09
    57622. WA09
    57623. WA09
    57624. WA09
    57625. WA09
    57626. WA09
    57627. WA09
    57628. WA09
    57629. WA09
    57630. WA09
    57631. WA09
    57632. WA09
    57633. WA09
    57634. WA09
    57635. WA09
    57636. WA09
    57637. WA09
    57638. WA09
    57639. WA09
    57640. WA09
    57641. WA09
    57642. WA09
    57643. WA09
    57644. WA09
    57645. WA09
    57646. WA09
    57647. WA09
    57648. WA09
    57649. WA09
    57650. WA09
    57651. WA09
    57652. WA09
    57653. WA09
    57654. WA09
    57655. WA09
    57656. WA09
    57657. WA09
    57658. WA09
    57659. WA09
    57660. WA09
    57661. WA09
    57662. WA09
    57663. WA09
    57664. WA09
    57665. WA09
    57666. WA09
    57667. WA09
    57668. WA09
    57669. WA09
    57670. WA09
    57671. WA09
    57672. WA09
    57673. WA09
    57674. WA09
    57675. WA09
    57676. WA09
    57677. WA10
    57678. WA10
    57679. WA10
    57680. WA10
    57681. WA10
    57682. WA10
    57683. WA10
    57684. WA10
    57685. WA10
    57686. WA10
    57687. WA10
    57688. WA10
    57689. WA10
    57690. WA10
    57691. WA10
    57692. WI01
    57693. WI01
    57694. WI01
    57695. WI01
    57696. WI01
    57697. WI01
    57698. WI01
    57699. WI01
    57700. WI01
    57701. WI01
    57702. WI01
    57703. WI01
    57704. WI01
    57705. WI01
    57706. WI01
    57707. WI01
    57708. WI01
    57709. WI01
    57710. WI01
    57711. WI01
    57712. WI01
    57713. WI01
    57714. WI01
    57715. WI01
    57716. WI01
    57717. WI01
    57718. WI01
    57719. WI01
    57720. WI01
    57721. WI01
    57722. WI01
    57723. WI01
    57724. WI01
    57725. WI01
    57726. WI01
    57727. WI01
    57728. WI01
    57729. WI01
    57730. WI01
    57731. WI01
    57732. WI01
    57733. WI01
    57734. WI01
    57735. WI01
    57736. WI01
    57737. WI01
    57738. WI02
    57739. WI02
    57740. WI02
    57741. WI02
    57742. WI02
    57743. WI02
    57744. WI02
    57745. WI02
    57746. WI02
    57747. WI02
    57748. WI02
    57749. WI02
    57750. WI02
    57751. WI02
    57752. WI02
    57753. WI02
    57754. WI02
    57755. WI02
    57756. WI02
    57757. WI02
    57758. WI02
    57759. WI02
    57760. WI02
    57761. WI02
    57762. WI02
    57763. WI02
    57764. WI02
    57765. WI02
    57766. WI02
    57767. WI02
    57768. WI02
    57769. WI02
    57770. WI02
    57771. WI02
    57772. WI02
    57773. WI02
    57774. WI02
    57775. WI02
    57776. WI02
    57777. WI02
    57778. WI02
    57779. WI02
    57780. WI02
    57781. WI02
    57782. WI02
    57783. WI02
    57784. WI02
    57785. WI02
    57786. WI02
    57787. WI02
    57788. WI02
    57789. WI02
    57790. WI02
    57791. WI02
    57792. WI02
    57793. WI02
    57794. WI02
    57795. WI02
    57796. WI02
    57797. WI02
    57798. WI02
    57799. WI02
    57800. WI02
    57801. WI02
    57802. WI02
    57803. WI02
    57804. WI02
    57805. WI02
    57806. WI02
    57807. WI02
    57808. WI02
    57809. WI02
    57810. WI02
    57811. WI02
    57812. WI02
    57813. WI03
    57814. WI03
    57815. WI03
    57816. WI03
    57817. WI03
    57818. WI03
    57819. WI03
    57820. WI03
    57821. WI03
    57822. WI03
    57823. WI03
    57824. WI03
    57825. WI03
    57826. WI03
    57827. WI03
    57828. WI03
    57829. WI03
    57830. WI03
    57831. WI03
    57832. WI03
    57833. WI03
    57834. WI03
    57835. WI03
    57836. WI03
    57837. WI03
    57838. WI03
    57839. WI03
    57840. WI03
    57841. WI03
    57842. WI03
    57843. WI03
    57844. WI03
    57845. WI03
    57846. WI03
    57847. WI03
    57848. WI03
    57849. WI03
    57850. WI03
    57851. WI03
    57852. WI03
    57853. WI03
    57854. WI03
    57855. WI03
    57856. WI04
    57857. WI04
    57858. WI04
    57859. WI04
    57860. WI04
    57861. WI04
    57862. WI04
    57863. WI04
    57864. WI04
    57865. WI04
    57866. WI04
    57867. WI04
    57868. WI04
    57869. WI04
    57870. WI04
    57871. WI04
    57872. WI04
    57873. WI04
    57874. WI04
    57875. WI04
    57876. WI04
    57877. WI04
    57878. WI04
    57879. WI04
    57880. WI04
    57881. WI04
    57882. WI04
    57883. WI04
    57884. WI04
    57885. WI04
    57886. WI04
    57887. WI04
    57888. WI04
    57889. WI04
    57890. WI04
    57891. WI04
    57892. WI04
    57893. WI04
    57894. WI04
    57895. WI04
    57896. WI04
    57897. WI04
    57898. WI04
    57899. WI04
    57900. WI04
    57901. WI04
    57902. WI04
    57903. WI04
    57904. WI04
    57905. WI04
    57906. WI04
    57907. WI04
    57908. WI04
    57909. WI04
    57910. WI04
    57911. WI04
    57912. WI04
    57913. WI04
    57914. WI04
    57915. WI04
    57916. WI04
    57917. WI04
    57918. WI04
    57919. WI04
    57920. WI04
    57921. WI04
    57922. WI04
    57923. WI04
    57924. WI04
    57925. WI04
    57926. WI04
    57927. WI04
    57928. WI04
    57929. WI04
    57930. WI04
    57931. WI04
    57932. WI04
    57933. WI04
    57934. WI04
    57935. WI04
    57936. WI04
    57937. WI04
    57938. WI04
    57939. WI04
    57940. WI04
    57941. WI04
    57942. WI04
    57943. WI04
    57944. WI04
    57945. WI04
    57946. WI04
    57947. WI04
    57948. WI04
    57949. WI04
    57950. WI04
    57951. WI04
    57952. WI04
    57953. WI04
    57954. WI04
    57955. WI04
    57956. WI04
    57957. WI04
    57958. WI04
    57959. WI04
    57960. WI04
    57961. WI04
    57962. WI04
    57963. WI04
    57964. WI04
    57965. WI04
    57966. WI04
    57967. WI04
    57968. WI04
    57969. WI04
    57970. WI04
    57971. WI04
    57972. WI04
    57973. WI04
    57974. WI04
    57975. WI04
    57976. WI04
    57977. WI04
    57978. WI04
    57979. WI04
    57980. WI04
    57981. WI04
    57982. WI04
    57983. WI04
    57984. WI04
    57985. WI04
    57986. WI04
    57987. WI04
    57988. WI04
    57989. WI04
    57990. WI04
    57991. WI04
    57992. WI04
    57993. WI04
    57994. WI04
    57995. WI04
    57996. WI04
    57997. WI04
    57998. WI04
    57999. WI04
    58000. WI04
    58001. WI04
    58002. WI04
    58003. WI04
    58004. WI04
    58005. WI04
    58006. WI04
    58007. WI04
    58008. WI04
    58009. WI04
    58010. WI04
    58011. WI04
    58012. WI04
    58013. WI04
    58014. WI04
    58015. WI04
    58016. WI04
    58017. WI04
    58018. WI04
    58019. WI04
    58020. WI04
    58021. WI04
    58022. WI04
    58023. WI04
    58024. WI04
    58025. WI04
    58026. WI04
    58027. WI04
    58028. WI04
    58029. WI04
    58030. WI04
    58031. WI04
    58032. WI04
    58033. WI04
    58034. WI04
    58035. WI04
    58036. WI04
    58037. WI04
    58038. WI04
    58039. WI04
    58040. WI04
    58041. WI04
    58042. WI04
    58043. WI04
    58044. WI04
    58045. WI04
    58046. WI04
    58047. WI04
    58048. WI04
    58049. WI04
    58050. WI04
    58051. WI04
    58052. WI04
    58053. WI04
    58054. WI04
    58055. WI04
    58056. WI04
    58057. WI04
    58058. WI04
    58059. WI04
    58060. WI04
    58061. WI04
    58062. WI04
    58063. WI04
    58064. WI04
    58065. WI04
    58066. WI04
    58067. WI04
    58068. WI04
    58069. WI04
    58070. WI04
    58071. WI04
    58072. WI04
    58073. WI04
    58074. WI04
    58075. WI04
    58076. WI04
    58077. WI04
    58078. WI04
    58079. WI04
    58080. WI04
    58081. WI04
    58082. WI04
    58083. WI04
    58084. WI04
    58085. WI04
    58086. WI04
    58087. WI04
    58088. WI04
    58089. WI04
    58090. WI04
    58091. WI04
    58092. WI04
    58093. WI04
    58094. WI04
    58095. WI04
    58096. WI04
    58097. WI04
    58098. WI04
    58099. WI04
    58100. WI04
    58101. WI04
    58102. WI04
    58103. WI04
    58104. WI04
    58105. WI04
    58106. WI04
    58107. WI04
    58108. WI04
    58109. WI04
    58110. WI04
    58111. WI04
    58112. WI04
    58113. WI04
    58114. WI04
    58115. WI04
    58116. WI04
    58117. WI04
    58118. WI04
    58119. WI04
    58120. WI04
    58121. WI04
    58122. WI04
    58123. WI04
    58124. WI04
    58125. WI04
    58126. WI04
    58127. WI04
    58128. WI04
    58129. WI04
    58130. WI05
    58131. WI05
    58132. WI05
    58133. WI05
    58134. WI05
    58135. WI05
    58136. WI05
    58137. WI05
    58138. WI05
    58139. WI05
    58140. WI05
    58141. WI05
    58142. WI05
    58143. WI05
    58144. WI05
    58145. WI05
    58146. WI05
    58147. WI05
    58148. WI05
    58149. WI05
    58150. WI05
    58151. WI05
    58152. WI05
    58153. WI05
    58154. WI05
    58155. WI05
    58156. WI05
    58157. WI05
    58158. WI05
    58159. WI05
    58160. WI05
    58161. WI05
    58162. WI05
    58163. WI05
    58164. WI05
    58165. WI05
    58166. WI05
    58167. WI05
    58168. WI05
    58169. WI05
    58170. WI05
    58171. WI05
    58172. WI05
    58173. WI05
    58174. WI05
    58175. WI05
    58176. WI05
    58177. WI05
    58178. WI05
    58179. WI05
    58180. WI05
    58181. WI05
    58182. WI05
    58183. WI05
    58184. WI05
    58185. WI05
    58186. WI05
    58187. WI05
    58188. WI05
    58189. WI05
    58190. WI05
    58191. WI05
    58192. WI05
    58193. WI05
    58194. WI05
    58195. WI05
    58196. WI05
    58197. WI05
    58198. WI05
    58199. WI05
    58200. WI05
    58201. WI05
    58202. WI05
    58203. WI05
    58204. WI05
    58205. WI05
    58206. WI05
    58207. WI05
    58208. WI05
    58209. WI05
    58210. WI05
    58211. WI05
    58212. WI05
    58213. WI05
    58214. WI05
    58215. WI05
    58216. WI05
    58217. WI05
    58218. WI05
    58219. WI05
    58220. WI05
    58221. WI05
    58222. WI05
    58223. WI05
    58224. WI05
    58225. WI05
    58226. WI05
    58227. WI05
    58228. WI05
    58229. WI05
    58230. WI05
    58231. WI05
    58232. WI05
    58233. WI05
    58234. WI05
    58235. WI05
    58236. WI05
    58237. WI05
    58238. WI05
    58239. WI05
    58240. WI05
    58241. WI05
    58242. WI05
    58243. WI05
    58244. WI05
    58245. WI05
    58246. WI05
    58247. WI05
    58248. WI05
    58249. WI05
    58250. WI05
    58251. WI05
    58252. WI05
    58253. WI05
    58254. WI05
    58255. WI05
    58256. WI05
    58257. WI05
    58258. WI05
    58259. WI05
    58260. WI05
    58261. WI05
    58262. WI05
    58263. WI05
    58264. WI05
    58265. WI05
    58266. WI05
    58267. WI05
    58268. WI05
    58269. WI05
    58270. WI05
    58271. WI05
    58272. WI05
    58273. WI05
    58274. WI05
    58275. WI05
    58276. WI05
    58277. WI05
    58278. WI05
    58279. WI05
    58280. WI05
    58281. WI05
    58282. WI05
    58283. WI05
    58284. WI05
    58285. WI05
    58286. WI05
    58287. WI05
    58288. WI05
    58289. WI05
    58290. WI05
    58291. WI05
    58292. WI05
    58293. WI05
    58294. WI05
    58295. WI05
    58296. WI05
    58297. WI05
    58298. WI05
    58299. WI05
    58300. WI05
    58301. WI05
    58302. WI05
    58303. WI05
    58304. WI05
    58305. WI05
    58306. WI05
    58307. WI05
    58308. WI05
    58309. WI05
    58310. WI05
    58311. WI05
    58312. WI05
    58313. WI05
    58314. WI05
    58315. WI05
    58316. WI05
    58317. WI05
    58318. WI05
    58319. WI05
    58320. WI05
    58321. WI05
    58322. WI05
    58323. WI05
    58324. WI05
    58325. WI05
    58326. WI05
    58327. WI05
    58328. WI05
    58329. WI05
    58330. WI05
    58331. WI05
    58332. WI05
    58333. WI05
    58334. WI05
    58335. WI05
    58336. WI05
    58337. WI05
    58338. WI05
    58339. WI05
    58340. WI05
    58341. WI05
    58342. WI05
    58343. WI05
    58344. WI05
    58345. WI05
    58346. WI05
    58347. WI05
    58348. WI05
    58349. WI05
    58350. WI06
    58351. WI06
    58352. WI06
    58353. WI06
    58354. WI06
    58355. WI06
    58356. WI06
    58357. WI06
    58358. WI06
    58359. WI06
    58360. WI06
    58361. WI06
    58362. WI06
    58363. WI06
    58364. WI06
    58365. WI06
    58366. WI06
    58367. WI06
    58368. WI06
    58369. WI06
    58370. WI06
    58371. WI06
    58372. WI06
    58373. WI06
    58374. WI06
    58375. WI06
    58376. WI06
    58377. WI06
    58378. WI06
    58379. WI06
    58380. WI06
    58381. WI06
    58382. WI06
    58383. WI06
    58384. WI06
    58385. WI06
    58386. WI06
    58387. WI06
    58388. WI06
    58389. WI06
    58390. WI06
    58391. WI06
    58392. WI06
    58393. WI06
    58394. WI06
    58395. WI06
    58396. WI06
    58397. WI06
    58398. WI06
    58399. WI06
    58400. WI06
    58401. WI06
    58402. WI06
    58403. WI06
    58404. WI06
    58405. WI06
    58406. WI06
    58407. WI06
    58408. WI06
    58409. WI06
    58410. WI06
    58411. WI06
    58412. WI06
    58413. WI06
    58414. WI06
    58415. WI06
    58416. WI06
    58417. WI06
    58418. WI06
    58419. WI06
    58420. WI06
    58421. WI06
    58422. WI06
    58423. WI06
    58424. WI06
    58425. WI06
    58426. WI06
    58427. WI06
    58428. WI06
    58429. WI06
    58430. WI06
    58431. WI06
    58432. WI06
    58433. WI06
    58434. WI06
    58435. WI06
    58436. WI06
    58437. WI06
    58438. WI06
    58439. WI06
    58440. WI06
    58441. WI06
    58442. WI06
    58443. WI06
    58444. WI06
    58445. WI06
    58446. WI06
    58447. WI06
    58448. WI06
    58449. WI06
    58450. WI06
    58451. WI06
    58452. WI06
    58453. WI06
    58454. WI06
    58455. WI06
    58456. WI06
    58457. WI06
    58458. WI06
    58459. WI06
    58460. WI06
    58461. WI06
    58462. WI06
    58463. WI06
    58464. WI06
    58465. WI06
    58466. WI06
    58467. WI06
    58468. WI06

  • #2
    I can only make a wild guess at what is needed here. Check out distinct from the Stata Journal.

    Code:
    SJ-23-4 dm0042_5  . . . . . . . . . . . . . . . . Software update for distinct
            (help distinct, distinctgen if installed)  N. J. Cox and G. M. Longton
            Q4/23   SJ 23(4):1096
            comments out (and thus removes) a call to clear Mata at the
            close of work, which was frustrating some other projects
            also using Mata
    
    SJ-23-2 dm0042_4  . . . . . . . . . . . . . . . . Software update for distinct
            (help distinct, distinctgen if installed)  N. J. Cox and G. M. Longton
            Q2/23   SJ 23(2):595--596
            most important change is addition of distinctgen command
    
    SJ-20-4 dm0042_3  . . . . . . . . . . . . . . . . Software update for distinct
            (help distinct if installed)  . . . . . .  N. J. Cox and G. M. Longton
            Q4/20   SJ 20(4):1028--1030
            sort() option has been added
    
    SJ-20-2 pr0046_1  . . . . . . . . . . .  Speaking Stata: More ways for rowwise
            . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  N. J. Cox
            Q2/20   SJ 20(2):481--488                                (no commands)
            focuses on returning which variable or variables are equal
            to the maximum or minimum in a row
    
    SJ-15-3 dm0042_2  . . . . . . . . . . . . . . . . Software update for distinct
            (help distinct if installed)  . . . . . .  N. J. Cox and G. M. Longton
            Q3/15   SJ 15(3):899
            improved table format and display of large numbers of
            observations
    
    SJ-12-2 dm0042_1  . . . . . . . . . . . . . . . . Software update for distinct
            (help distinct if installed)  . . . . . .  N. J. Cox and G. M. Longton
            Q2/12   SJ 12(2):352
            options added to restrict output to variables with a minimum
            or maximum of distinct values
    
    SJ-8-4  dm0042  . . . . . . . . . . . .  Speaking Stata: Distinct observations
            (help distinct if installed)  . . . . . .  N. J. Cox and G. M. Longton
            Q4/08   SJ 8(4):557--568
            shows how to answer questions about distinct observations
            from first principles; provides a convenience command

    The 2008 paper explains the principles; the last 2023 update signals the version to install.

    Comment


    • #3
      Thanks but now I have:

      fre cdstate

      cdstate -- SAMPLE DESCRIPTION: State and Congressional District- Postal Abbrev and CD
      --------------------------------------------------------------
      | Freq. Percent Valid Cum.
      -----------------+--------------------------------------------
      Valid 1 9999 | 4997 8.43 8.43 8.43
      2 AK01 | 6 0.01 0.01 8.44
      3 AL01 | 33 0.06 0.06 8.50
      4 AL02 | 252 0.43 0.43 8.92
      5 AL03 | 144 0.24 0.24 9.16
      6 AL04 | 29 0.05 0.05 9.21
      7 AL05 | 83 0.14 0.14 9.35
      8 AL06 | 253 0.43 0.43 9.78
      9 AL07 | 198 0.33 0.33 10.11
      10 AR01 | 426 0.72 0.72 10.83
      11 AR02 | 189 0.32 0.32 11.15
      12 AR03 | 44 0.07 0.07 11.23
      13 AR04 | 418 0.71 0.71 11.93
      14 AR05 | 68 0.11 0.11 12.05
      15 AR06 | 10 0.02 0.02 12.06
      16 AZ01 | 163 0.27 0.27 12.34
      17 AZ02 | 65 0.11 0.11 12.45
      18 AZ03 | 140 0.24 0.24 12.68
      19 AZ04 | 100 0.17 0.17 12.85
      20 AZ05 | 63 0.11 0.11 12.96
      : | : : : :
      478 WA04 | 46 0.08 0.08 96.38
      479 WA05 | 17 0.03 0.03 96.41
      480 WA06 | 102 0.17 0.17 96.59
      481 WA07 | 238 0.40 0.40 96.99
      482 WA08 | 91 0.15 0.15 97.14
      483 WA09 | 94 0.16 0.16 97.30
      484 WA10 | 15 0.03 0.03 97.32
      485 WI01 | 46 0.08 0.08 97.40
      486 WI02 | 75 0.13 0.13 97.53
      487 WI03 | 43 0.07 0.07 97.60
      488 WI04 | 274 0.46 0.46 98.06
      489 WI05 | 220 0.37 0.37 98.43
      490 WI06 | 226 0.38 0.38 98.82
      491 WI07 | 26 0.04 0.04 98.86
      492 WI08 | 26 0.04 0.04 98.90
      493 WI09 | 172 0.29 0.29 99.19
      494 WV01 | 241 0.41 0.41 99.60
      495 WV02 | 24 0.04 0.04 99.64
      496 WV03 | 177 0.30 0.30 99.94
      497 WY01 | 36 0.06 0.06 100.00
      Total | 59277 100.00 100.00
      --------------------------------------------------------------

      I have two issues. First when I try to drop cdstate = 9999 I can't do so.
      Second, I can't access the values for cdstate between 21 and 477. There must be a way to do so. Thanks for any help.

      Comment


      • #4
        Code:
        help drop 
        drop if cdstate == 9999

        Comment


        • #5
          The output shows that 9999 is the value label attached to the numeric value 1.
          To remove those observations, run:
          Code:
          drop if cdstate == 1
          The values between 21 and 477 are omitted because fre displays only the first and last 20 values by default.
          To display all values, run:
          Code:
          fre cdstate, all

          Comment


          • #6
            Choonjoo Lee is quite correct. It seems that cdstate has been encoded and "9999" (as some kind of code for missing values?) comes before "AK01" in alphanumeric order.

            So

            Code:
            drop if cdstate == 1
            is indeed a much better guess.

            fre is from SSC.

            Comment

            Working...
            X