DATA Step, Macro, Functions and more

Getting all the values in a single variable

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 8
Accepted Solution

Getting all the values in a single variable

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

 


Accepted Solutions
Solution
‎03-15-2016 12:19 PM
Super User
Posts: 5,516

Re: Getting all the values in a single variable

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;

View solution in original post


All Replies
Super User
Posts: 19,860

Re: Getting all the values in a single variable

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

 

Also...look at the scan function. 

 

Solution
‎03-15-2016 12:19 PM
Super User
Posts: 5,516

Re: Getting all the values in a single variable

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;

Occasional Contributor
Posts: 8

Re: Getting all the values in a single variable

Posted in reply to Astounding

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

Super User
Posts: 11,343

Re: Getting all the values in a single variable

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.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 247 views
  • 2 likes
  • 4 in conversation