Hi,
I generate a column of id (its variable name is c) from data set one (discrepancy_2016_2) and try to put it for data set two as IF/THEN criteria. Here is my example of code but it doesn’t work. Please advise.
PROC SQL NOPRINT;
SELECT c INTO : cList
FROM discrepancy_2016_2
;
QUIT ;
data discrepancy_2016_last_2;
set discrepancies_20jun17;
IF case_no in "compress(&clist)";
run;
Thank you.
Try
if case no is char
PROC SQL NOPRINT;
SELECT quote(compress(c)) INTO : cList separated by ','
FROM discrepancy_2016_2
;
QUIT ;
if caseno is numeric
PROC SQL NOPRINT;
SELECT c INTO : cList separated by ','
FROM discrepancy_2016_2
;
QUIT ;
data discrepancy_2016_last_2;
set discrepancies_20jun17;
IF case_no in (&clist);
run;
Try
if case no is char
PROC SQL NOPRINT;
SELECT quote(compress(c)) INTO : cList separated by ','
FROM discrepancy_2016_2
;
QUIT ;
if caseno is numeric
PROC SQL NOPRINT;
SELECT c INTO : cList separated by ','
FROM discrepancy_2016_2
;
QUIT ;
data discrepancy_2016_last_2;
set discrepancies_20jun17;
IF case_no in (&clist);
run;
Hi,
Thank you for the code. IT works.
Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.