Converting PROC SQL to DATA step

[danalukowski228]

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!

[Reeza · Accepted solution]

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