Transpose

[Daily1]

hi
i have 
SR	ID	S	S_G	TS	TS_G
1	19	1	5	7	2
2	20	5	8	6	1
3	21	5	7	2	1


i want 
SR	ID	nw1	nw2
1	19	1	7
		5	2
2	20	5	6
		8	1
3	21	5	7
		7	2

[Kurt_Bremser · Accepted solution]

data want;
set have;
nw1 = s;
nw2 = ts;
output;
nw1 = s_g;
nw2 = ts_g;
output;
keep sr id nw1 nw2;
run;

[Ksharp]

/*You want a dataset or report ?*/
data have;
infile cards;
input SR ID S S_G TS TS_G;
cards;
1 19 1 5 7 2
2 20 5 8 6 1
3 21 5 7 2 1
;

proc odstable data=have;
column  SR ID (S TS)*(S_G TS_G);
define S;
header='nw1';
end;
define TS;
header='nw2';
end;
run;