topic Re: Converting PROC SQL to DATA step in SAS Programming

Converting PROC SQL to DATA step

danalukowski228 — Wed, 09 Jun 2021 15:55:41 GMT

Hi all,

I am working on a virtual desktop and need help converting the following code from PROC SQL to a DATA step.

proc sql;
update &libg.prof_lines_ltd a
set grouper_1=(select b.grouper_1 from &libg.lkup_cpt_group b where b.CPT_CD=a.CPT_CD),
set grouper_2=(select b.grouper_2 from &libg.lkup_cpt_group b where b.CPT_CD=a.CPT_CD),
set grouper_3=(select b.grouper_3 from &libg.lkup_cpt_group b where b.CPT_CD=a.CPT_CD);
quit;

Thanks in advance!

Re: Converting PROC SQL to DATA step

Reeza — Wed, 09 Jun 2021 16:10:04 GMT

I would suggest the usage of a format since this looks like a lookup. You can create the format and then apply it via PROC DATASETS, which is likely the fastest solution as well.

If you want to share what your lkup_cpt_group table looks like we can show you how to create a format from the data.
https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/n1e19y6lrektafn1kj6nbvhus59w.htm