Proc SQL INTO with 0 rows of data

sasuser101 — Wed, 12 Jul 2017 16:25:34 GMT

Hello,

i have simple proc sql statement to create macro variable name custid. I use this custid macro variable in other sql shown below to create table cust_dtl.

The problem arises when custid has 0 rows selected from cust_tbl which then gives error in sas log saying apparent symbolic reference not resolved. How do i replace value of custid with default value of 00 so it can be used in other proc sql without error.

proc sql noprint;
           select distinct cust_id format 15. into :custid SEPARATED BY ','
           from wk.cust_tbl
           ;
           quit;

%put &custid. ;

proc sql;

create table cust_dtl as

select name,dob from cust_det

where cust_id in (&custid.);

quit;

Re: Proc SQL INTO with 0 rows of data

Astounding — Wed, 12 Jul 2017 16:31:24 GMT

Do it the other way around. Add this statement just before the first PROC SQL:

%let custid=00;

Then if PROC SQL selects no rows, it will leave CUSTID alone.

Re: Proc SQL INTO with 0 rows of data

sasuser101 — Wed, 12 Jul 2017 19:19:13 GMT

thank you for simple and effective solution.

topic Proc SQL INTO with 0 rows of data in SAS Programming

Proc SQL INTO with 0 rows of data

Re: Proc SQL INTO with 0 rows of data

Re: Proc SQL INTO with 0 rows of data