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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.