I have a dataset in a sharedrive called myshare
The data I received is in a csv file with this format
1 Centerville |
P O Box 6372 |
Eisley Station |
Bridgeport, CT 06606 |
2 Iona Center |
P.O Box 4512 |
Warentden, CT 06514 |
I am currently copying and pasting the data in a spreadsheet with created columns
to enable the code below to work and read left to right. Is there a way to flip the data so I will not need to copy and paste to the individual variable names.
Data Chapters1;
INFILE '/myshare/folder1/Chapters.csv'
LRECL=32767
FIRSTOBS=2
ENCODING="LATIN1"
DLM=','
MISSOVER
DSD ;
INPUT District : $CHAR20.
Chapter : $CHAR20.
Address : $CHAR17.
City : $CHAR20.
State : $CHAR2.
ZIP :$CHAR10.
;
Run;
proc sort data= Chapters1;by Chapter;run;
Can you post an example of the text file here, not from Excel, just from a text editor so it's easier to understand. And a few more records to see the variation in patterns.
Is numerated, ie 1/2/3 or is that 1/2 in the example coincidental?
If it was always 3 records this would be easier but it is definitely doable.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.