SAS sql into sas data step

Geo- — Sun, 16 Sep 2018 04:15:28 GMT

proc sql noprint;
create table tableC as
slect A.a,A.b,A.c,B.d,B.e
from tableA A
inner join tableB B
on A.b=B.b;

delete from tableC
where not (substr(d,1,1)='1' and length(trim(d))=11)
or d is null;

delete from tableC
where d in
(select d from tableC group by d having count(1)>1);
quit;

thank you for your time!

Re: SAS sql into sas data step

Jagadishkatam — Sun, 16 Sep 2018 05:27:51 GMT

proc sort data=tablea;
by b;
run;

proc sort data=tablea;
by b;
run;


data tablec;
merge tablea(in=ina) tableb(in=inb);
by b;
if ina;
if not (substr(d,1,1)='1' and length(trim(d))=11);
dc=(substr(d,1,1);
run;

proc sort data=tablec;
by dc;
run;

data tablec(where=(dc <=1));
do until(last.dc);
set tablec;
by dc;
retain count;
if first.dc then count=1;
else count+1;
end;
do until(last.dc);
set tablec;
by dc;
output;
end;
run;

N.B. Untested code.

topic Re: SAS sql into sas data step in SAS Programming

SAS sql into sas data step

Re: SAS sql into sas data step