Proc Transpose gives me a stepped table

[deliansteel]

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

[Reeza · Accepted solution]

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;

[deliansteel]

Thank you!

[PGStats]

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;

[deliansteel]

Thank you also for your help!