topic Re: getting the output in SAS Programming

getting the output

Aayushi_17 — Tue, 04 Dec 2018 05:06:26 GMT

Hii i have a dataset like this

id	reas	freq count
1	3	17
1	6	23
1	7	56
1	9	33
1	10	24
2	3	64
2	6	23
2	7	34
2	8	64
2	10	43

and the output i want is can anyone help me how to solve this ?

reas	id=1	id=2
3	17	64
6	23	23
7	56	34
8	33	64
10	24	43

thanks in advance

Re: getting the output

Reeza — Tue, 04 Dec 2018 05:28:08 GMT

Take a look at PROC TRANSPOSE.

https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-long-to-wide-using-proc-transpose/

Re: getting the output

novinosrin — Tue, 04 Dec 2018 06:03:42 GMT

proc sort data=have out=_have;
by reas;
run;

proc transpose data=_have out=want prefix=ID ;
by reas;
id id;
var freqcount;
run;

Re: getting the output

Aayushi_17 — Tue, 04 Dec 2018 06:20:25 GMT

thank you all

Re: getting the output

ShiroAmada — Tue, 04 Dec 2018 06:27:22 GMT

You can try data step or using sql


/* data step */
proc sort data=have;
  by reas;
run;

data want;
  length
  reas id_1 id_2 8;
  merge 
  have(where=(id=1) rename=(freqcount=id_1) in=a)
  have(where=(id=2) rename=(freqcount=id_2) in=b);
  by reas;
  drop id;
run;

/* PROC SQL */
proc sql;
  create table want3 as
  select 
  coalesce(a.reas,b.reas) as reas,
  a.freqcount as id_1,
  b.freqcount as Id_2
  from have(where=(id=1)) a full join 
  have(where=(id=2)) b 
  on a.reas=b.reas;
quit;