DATA Step, Macro, Functions and more

Extracting vertical data into spreadsheet

Reply
Regular Contributor
Posts: 180

Extracting vertical data into spreadsheet

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;

 

Super User
Posts: 23,928

Re: Extracting vertical data into spreadsheet

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. 

 

 

Ask a Question
Discussion stats
  • 1 reply
  • 81 views
  • 0 likes
  • 2 in conversation