topic Re: PROC TRANSPOSE in SAS Programming

PROC TRANSPOSE

zimcom — Wed, 18 Jul 2018 16:26:08 GMT

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

Re: PROC TRANSPOSE

novinosrin — Wed, 18 Jul 2018 16:31:03 GMT

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;

Re: PROC TRANSPOSE

Astounding — Wed, 18 Jul 2018 16:49:50 GMT

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

Re: PROC TRANSPOSE

zimcom — Wed, 18 Jul 2018 17:33:46 GMT

That explains my situation, Thank you.

Re: PROC TRANSPOSE

zimcom — Wed, 18 Jul 2018 17:34:30 GMT

THANK YOU!