proc sql;
create table CHI3 as
select * from
(select "taxId" as source, who, svcd, svdesc, admission, count from CHI)
union all
(select "National", C.who, N.svcd, N.svdesc, N.admission, N.count from
CHI as C inner Join CHI2 as N
on C.svcd=N.svcd and C.svdesc=N.svdesc and C.admission=N.admission)
order by who, svcd, source, admission;
quit;
proc freq data=CHI3 noprint;
by who svcd;
tables source*admission / chisq;
freq count;
output out=CHI_OUT chisq;
run;
The output is:
source who svcd svdesc admission count
national 1111 1 minor no 1295
national 1111 1 minor yes 152
provtin 1111 1 minor no 12
provtin 1111 1 minor yes 3
national 2222 1 minor no 1295
national 2222 1 minor yes 152
provtin 2222 1 minor no 24
provtin 2222 1 minor yes 5
But I want it to be this way so when doing my chi it will be correct
- who svcd svdesc admission count
national 1 minor no 1295
national 1 minor yes 152
1111 1 minor no 12
1111 1 minor yes 3
national 1 minor no 1295
national 1 minor yes 152
2222 1 minor no 24
2222 1 minor yes 5