topic Re: Getting all the values in a single variable in SAS Programming

Getting all the values in a single variable

Daya87 — Wed, 09 Mar 2016 16:48:44 GMT

I Have a Data Like below table. I Just Had only name and Grade. Need to create All_Grades(Individual Grades should come seperated by "-")

Name Grade All_Grades
Alfred A A-B-C-A-D
Alfred B A-B-C-A-D
Alfred C A-B-C-A-D
Alfred A A-B-C-A-D
Alfred D A-B-C-A-D
James B B-C-A
James C B-C-A
James A B-C-A
Philip D D-C-A-A
Philip C D-C-A-A
Philip A D-C-A-A
Philip A D-C-A-A
William A A-A-C
William A A-A-C
William C A-A-C

Thanks in advance

Re: Getting all the values in a single variable

Reeza — Wed, 09 Mar 2016 16:59:11 GMT

Please post what you'd like the output to be, for clarification.

Also...look at the scan function.

Re: Getting all the values in a single variable

Astounding — Wed, 09 Mar 2016 17:12:53 GMT

Here's one way, assuming that your data is sorted by NAME:

data want;

length all_grades $ 20;

do until (last.name);

set have;

by name;

all_grades = catx('-', all_grades, grade);

end;

do until (last.name);

set have;

by name;

output;

end;

run;

Re: Getting all the values in a single variable

Daya87 — Wed, 09 Mar 2016 18:42:00 GMT

Yes, It's working Fine. Thanks a lot.

Re: Getting all the values in a single variable

ballardw — Wed, 09 Mar 2016 22:41:15 GMT

Please mark the appropriate response as your accepted solution.

This helps other users know that a correct or acceptable answer for a given problem has been posted.