https://communities.sas.com/t5/SAS-Programming/Simply-the-PROC-SQL-codes/m-p/812248#M320458 <P>Hello,</P> <P>I'm curious if I could use one PROC SQL step to achieve the two steps result below.&nbsp; Thanks.</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data underly1617; set underly1621_nodup; if year=1617; run; proc sql noprint; select quote(trim(caseid)) into : UC_1617_list separated by ',' from underly1617; quit; %put &amp;UC_1617_list;</CODE></PRE> Mon, 09 May 2022 19:05:21 GMT ybz12003 2022-05-09T19:05:21Z https://communities.sas.com/t5/SAS-Programming/Simply-the-PROC-SQL-codes/m-p/812248#M320458 <P>Hello,</P> <P>I'm curious if I could use one PROC SQL step to achieve the two steps result below.&nbsp; Thanks.</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data underly1617; set underly1621_nodup; if year=1617; run; proc sql noprint; select quote(trim(caseid)) into : UC_1617_list separated by ',' from underly1617; quit; %put &amp;UC_1617_list;</CODE></PRE> Mon, 09 May 2022 19:05:21 GMT https://communities.sas.com/t5/SAS-Programming/Simply-the-PROC-SQL-codes/m-p/812248#M320458 ybz12003 2022-05-09T19:05:21Z https://communities.sas.com/t5/SAS-Programming/Simply-the-PROC-SQL-codes/m-p/812251#M320461 <P>You sure can. You would also need to add a WHERE clause after your FROM clause to subset only 1617 records.</P> <P>&nbsp;</P> <P>Not sure what your data look like though and the number of records. Usually helps to post sample code.</P> Mon, 09 May 2022 19:19:26 GMT https://communities.sas.com/t5/SAS-Programming/Simply-the-PROC-SQL-codes/m-p/812251#M320461 maguiremq 2022-05-09T19:19:26Z