Help using Base SAS procedures

Union All help

Reply
Regular Contributor
Regular Contributor
Posts: 238

Union All help

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

Ask a Question
Discussion stats
  • 0 replies
  • 164 views
  • 0 likes
  • 1 in conversation