PROC TRANSPOSE

[zimcom]

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

[novinosrin · Accepted solution]

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;

[zimcom]

THANK YOU!

[Astounding]

When you leave out the VAR statement, the default is to transpose all numeric variables.  But you have no numeric variables to transpose.

[zimcom]

That explains my situation, Thank you.