topic Re: base sas in SAS Programming

base sas

molla — Sat, 11 Mar 2017 12:41:56 GMT

Hii

I have the following data set

subid names

001 ruby

001 ricky

001 subbu

002 kee

002 chai

003 deep

004 suri

I need output as

subid names

001 ruby,ricky,subbu

002 kee,chai

003 deep

004 suri

Re: base sas

Astounding — Sat, 11 Mar 2017 13:48:17 GMT

Here's a straightforward approach:

data want;

set have;

by subid;

length all_names $ 200;

if first.subid then all_names = names;

else all_names = catx(',' , all_names, names);

if last.subid;

retain all_names;

run;

The only thing I would warn you about is to consider whether this is really a good step to take. If you merely want to print the data in this new form then go right ahead. But if you are analyzing or summarizing the data for some other purpose, SAS has many tools that let you process multiple observations per SUBID. It may not be necessary to change the form of the data.