topic Re: Proc Transpose gives me a stepped table in SAS Studio

Proc Transpose gives me a stepped table

deliansteel — Sat, 14 May 2016 20:24:28 GMT

I proc transposed this:

proc sort data=ngr2 out=ngr1;
by no;
run;

proc transpose data=Ngr1 out=ngr;
	by no;
	id nigeria;
	var _2011 _2012 _2013 _2014 _2015 _2016;
run;

and got this:

but I want something like this

Thanks in advance

Re: Proc Transpose gives me a stepped table

Reeza — Sat, 14 May 2016 21:02:51 GMT

You don't need a BY statement, in fact a 'basic' proc transpose should get you much closer:

proc transpose data=have out=want;
run;

Add back portions of code until you get what you need with the minimal amount of code. You should end up with something similar to this:

proc transpose data=have out=want;
id var_name;
var _2011 _2012 _2013 _2014 _2015 _2016;
run;

Re: Proc Transpose gives me a stepped table

PGStats — Sun, 15 May 2016 03:54:45 GMT

I assume that variable no is only there to set a column order in your transposed table. That's fine. But it shouldn't be involved in the transposition. Simply do:

proc transpose data=Ngr1 out=ngr name=Year;
	id Nigeria;
	var _2011 - _2016;
run;

Re: Proc Transpose gives me a stepped table

deliansteel — Sun, 15 May 2016 03:56:39 GMT

Thank you also for your help!

Re: Proc Transpose gives me a stepped table

deliansteel — Sun, 15 May 2016 03:56:51 GMT

Thank you!