topic Re: How to create a dummy row using proc sql in New SAS User

How to create a dummy row using proc sql

jashu14 — Wed, 05 Dec 2018 09:34:22 GMT

I want to create a dummy row using proc SQL.

In the below example we can get male and female count.

And for that GENDER we usually create a dummy data set and set back. So is it possible do the same using proc SQL.

For Example :

Gender

Male 2

Female 3

Re: How to create a dummy row using proc sql

Jagadishkatam — Wed, 05 Dec 2018 09:40:34 GMT

proc sql;
   create table dummy
       (Gender char(10),
        count num(8)
        );

insert into dummy
    values('Female',3)
    values('Male',2);
	 
quit;

Re: How to create a dummy row using proc sql

Kurt_Bremser — Wed, 05 Dec 2018 09:46:33 GMT

Do you mean that you want to create a count of observations for the two possible values of gender?

A SQL approach would be

proc sql;
create table want as
select
  'Male' as gender length = 6,
  count(*) as count
from have
where gender = 'Male'
union all
select
  'Female' as gender,
  count(*)
from have
where gender = 'Female'
;
quit;

Note that this is very much a waste of code space and performance as this will do the same:

proc freq data=have noprint;
table gender / out=want (drop=percent);
run;

See Maxim 14.