topic Loop in Data step help in SAS Programming

Loop in Data step help

DangIT — Thu, 12 Feb 2015 21:52:03 GMT

Hi,

I have a data set with that looks like:

ID File_period

1 201301

1 201302

1 201303

2 201302

2 201303

3 201301

I would like a unique data set by ID and a new variable for all the file periods, for example:
ID File_Period_1 File_Period_2 File_Period_3

1 201301 201302 201303

2 201302 201301

3 201301

The number of file periods will vary by ID.

I'm not sure what the best way to run this loop, any help greatly appreciated.

Thanks in advance!

ballardw — Thu, 12 Feb 2015 22:07:44 GMT

What you are doing is often called transposing from Long to Wide format.

proc transpose data=have out=want (drop=_name_)

prefix=File_period_;

by id;

var File_period;

run;

Please make your entries Questions in the format not Discussions when they are questions.

DangIT — Thu, 12 Feb 2015 22:14:09 GMT

Thank you.