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
Use the COALESCEC() funtion.
All_Courses = cats(Summer, Fall, Spring);
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.