02-28-2018 03:02 PM
I have a dataset in a sharedrive called myshare
The data I received is in a csv file with this format
|P O Box 6372|
|Bridgeport, CT 06606|
|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.
INPUT District : $CHAR20.
Chapter : $CHAR20.
Address : $CHAR17.
City : $CHAR20.
State : $CHAR2.
proc sort data= Chapters1;by Chapter;run;
02-28-2018 03:40 PM
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.