| Date: | Thu, 24 Jul 2008 08:10:06 -0400 |
|---|
| Reply-To: | Jon <jaa6c@VIRGINIA.EDU> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Jon <jaa6c@VIRGINIA.EDU> |
|---|
| Subject: | splitting & recombining a dataset |
|---|
| Content-Type: | text/plain; charset=ISO-8859-1 |
|---|
I have a question that’s difficult for me (a SAS newcomer) but probably easy
for someone else. I have a dataset that looks like this:
01 Bankhead, J. Alabama Democrat Yes
01 Underwood, B. Alabama Democrat Yes
04 Ashurst,H.F Arizona Democrat Yes
04 Smith, M.A. Arizona Democrat Yes
05 Kirby, W.F. Arkansas Democrat Yes
05 Robinson, J Arkansas Democrat Yes
06 Johnson,H.M. California Republican No
06 Phelan, J.D California Democrat Yes
08 Phipps, L.C. Colorado Republican No
08 Thomas, C.S Colorado Democrat No
The column headings are: FIPS, NAME, STATE, PARTY, and VOTE. What I would
like to do is to split the above so that it looks something like this:
01 Bankhead, J Alabama Democrat Yes Underwood,B. Alabama Democrat Yes
04 Ashurst,H.F Arizona Democrat Yes Smith, M.A. Arizona Democrat Yes
And so on. Basically, I’m trying to get all the variables that share FIPS
onto the same row. I’m not quite sure where to start with this so if anyone
has any ideas I’d be grateful.
|
