topic Re: Transpose in SAS Programming

Transpose

Daily1 — Fri, 07 Jul 2023 05:46:03 GMT

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

Re: Transpose

Kurt_Bremser — Fri, 07 Jul 2023 09:31:36 GMT

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

Re: Transpose

Ksharp — Fri, 07 Jul 2023 11:41:34 GMT

/*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;