Help using Base SAS procedures

proc sql instead of proc transpose

Accepted Solution Solved
Reply
Super Contributor
Posts: 301
Accepted Solution

proc sql instead of proc transpose

Hi Guys,

   using the code* below I obtain this:

                            Obsrace     sex  count

                             1 black   female  1
                             2 black   male    2
                             3 latin   female  1
                             4 latin   male    2
                             5 orientalmale    1

code*:

-------------------------------------------------------

data have;

length  subno 4 race $10 sex $10;

input subno race  sex ;

datalines;

1  black male

2  black female

3  latin male

4 latin male

5 black male

6 latin female

7 oriental male

;

run;

proc sql;

create table race as

  select race,  sex

                  ,count(distinct subno) as count

    from have

    group by race, sex;

quit;

proc print data=race; run;

------------------------------------------------------

Anyone can help me to get the final table below using proc sql?....note: (please I know how to get the final table using proc transpose, but I would like to know how to do it with proc sql), thanks.

Final table:

race            male   female     total

black              2      1             3

latin                2      1             3     

oriental           1       0             1

V.


Accepted Solutions
Solution
‎06-02-2012 06:51 PM
Respected Advisor
Posts: 3,156

Re: proc sql instead of proc transpose

OK, proc sql it is:

proc sql;

  select race, sum(sex='male') as male, sum(sex='female') as female, count(race) as total

  from have

  group by race;

quit;

Haikuo

View solution in original post


All Replies
Solution
‎06-02-2012 06:51 PM
Respected Advisor
Posts: 3,156

Re: proc sql instead of proc transpose

OK, proc sql it is:

proc sql;

  select race, sum(sex='male') as male, sum(sex='female') as female, count(race) as total

  from have

  group by race;

quit;

Haikuo

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 4728 views
  • 0 likes
  • 2 in conversation