DATA Step, Macro, Functions and more

Merging observations under one variable name

Reply
Regular Contributor
Posts: 218

Merging observations under one variable name

[ Edited ]

Hi All,

I have the following data set where I want to bring all variables under one new variable. can someone please tell me how do i do that. Thanks.

 

ID    Summer   Fall            Spring

101 Math         

101                  English

101                                   Physics

 

Expected Output:

ID    Summer   Fall            Spring    All_Courses

101 Math                                         Math         

101                  English                    English

101                                   Physics   Physics

 

Super User
Posts: 19,835

Re: Merging observations under one variable name

Use the COALESCEC() funtion. 

 

 

Super User
Posts: 3,256

Re: Merging observations under one variable name

All_Courses = cats(Summer, Fall, Spring);
Super User
Posts: 5,433

Re: Merging observations under one variable name

This looks like some made up sample data. What is the underlying requirement?

From a data perspective, I would rather see the following outcome (after transposing):

 

ID    Term       Course

101 Summer   Math         

101 Spring      English

101 Fall          Physics

Data never sleeps
Ask a Question
Discussion stats
  • 3 replies
  • 226 views
  • 3 likes
  • 4 in conversation