Hi all, I have data in a table and I wish to exctract unique modality per variable for every variables in my table (exclude the ID). The idea is to add a column to the output I get from proc print (variable name, type, len, pos, format, informat, Label). The column would be unique value. For example for the variable sexe, it will be men, women; for smoker, it will be : yes, no; size: small, medium, large, .... I can have the information thanks to proc freq but I have to write the result manually. I have the information for one variable with : proc SQL; select DISTINCT variable_name FROM lib.table; quit; But only one variable at a time Anyone to help me please 🙂
... View more