This looks neat, thank you! Can you please explain what this line does?
input list :$200. @;
And can you please do the splitting starting with
data IN3;
set IN2;
I tried to copy your do loop but didn't work.
I see that you are using "row" to be the categorization. But can you use the Extended Classification as given in IN2 directly? I know I can create a row number for my IN2 dataset and do a simple merge, but is there a way to do the same job without the merge?
Thank you!
Start by using PROC TRANSPOSE to move the category name out of the variable name into a variable. Then you just need to use the inner DO loop to do the splitting.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.