Hello,
I have around twenty different answers in one column 'A'. Column A is in text format. I would like to get a full list for all of them. Any idea how? Basely, I would like to use the method to apply for the other ten variables. Thanks!
How about this:
proc sql;
select distinct a from mydataset;
quit;
The simple answer is that PROC PRINT will create such a list.
Can you be more specific about what you mean by "a full list"?
No, I only the 20 different answers, not the full list of 500 rows.
How about this:
proc sql;
select distinct a from mydataset;
quit;
Awesome!!
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.