topic Re: Better way to create indicator variable in PROC SQL in SAS Programming

Better way to create indicator variable in PROC SQL

MarcTC — Mon, 23 May 2011 23:20:44 GMT

I wonder if there is a better way to create a indicator variable as shown in the following sql statement:

proc sql;
create table ds3 as
select a.*,
case
when b.id = '' then 0
else 1
end as ind
from ds1 a left join ds2 b
on a.id = b.id
; quit;

Re: Better way to create indicator variable in PROC SQL

Ksharp — Tue, 24 May 2011 01:09:48 GMT

I think your code is good enough.If you want more brief.
[pre]
data class;
set sashelp.class end=last; output;
if last then do;
name='Peter';sex=' '; output;
end;

proc sql;
create table temp as
select a.*,not missing(a.sex) as ind
from class as a left join class as b on a.sex=b.sex;
quit;
[/pre]

Ksharp

Re: Better way to create indicator variable in PROC SQL

SASJedi — Tue, 24 May 2011 02:24:49 GMT

You can make your code a touch more efficient with a little boolean logic:

proc sql;
create table ds3 as
select a.*
, b.id NE '' as ind
from ds1 a left join ds2 b
on a.id = b.id
;
quit;

Message was edited by: SASJedi Message was edited by: SASJedi