Dear community,
I have a data and codes looks like below and I don't know why my 'proc transpose' return 0 observations, the message in the log is not helpful.
NOTE: There were 2580 observations read from the data set WORK.INCLUSION1.
NOTE: The data set WORK.INCLUSION_T has 0 observations and 12 variables.
SUBJECT | incl_criteria | ieorres_new |
117961 | incl01 | Yes |
117961 | incl02 | Yes |
117961 | incl03 | Yes |
117961 | incl04 | Yes |
117961 | incl05 | Yes |
117961 | incl06 | Yes |
117961 | incl07 | Yes |
117961 | incl08 | Yes |
117961 | incl10 | Yes |
117961 | incl09 | Yes |
118036 | incl01 | Yes |
118036 | incl02 | Yes |
118036 | incl03 | Yes |
118036 | incl04 | Yes |
118036 | incl05 | Yes |
118036 | incl06 | Yes |
118036 | incl07 | Yes |
118036 | incl08 | Yes |
118036 | incl10 | Yes |
118036 | incl09 | Yes |
proc sort data = Inclusion1; by SUBJECT; run;
proc transpose data = Inclusion1 out = Inclusion_t;
by SUBJECT;
run;
Thank you
zimcom
hi @zimcom How do you want your output(transposed data to look like). There is no output sample provided. If you know what you are doing, I'm afraid you are missing var statement that specifies variables to transpose
var var1 var2;* you are missing this;
hi @zimcom How do you want your output(transposed data to look like). There is no output sample provided. If you know what you are doing, I'm afraid you are missing var statement that specifies variables to transpose
var var1 var2;* you are missing this;
THANK YOU!
When you leave out the VAR statement, the default is to transpose all numeric variables. But you have no numeric variables to transpose.
That explains my situation, Thank you.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.