Hi Team,
i need to pull some data from DATABASE for some about 50000 participants.ppts unique number is present in file which is in char format in database.
code :
data abc;
infile abcsajk;
input @001 unique $9.
line = " ' " !! unique !! " ' "
run;
%let ppts; creating macro vraiable
proc sql;
select unique : line
into ppts
from abc;
quit;
run;
proc sql;
database connection;
create table select * from connectio to database(
select * from db.table where unique_id in (&ppts)
Problem here is when ppts get resolved statement length get increased then it's length and query do not run.
So as per me solution could be if i can use sas dataset in subquery like below
proc sql;
database connection;
create table select * from connectio to database(
select * from db.table where unique_id in (select line from WORK.abc)
but its not working ,
Can anyone help or tell me its possible or not.whether we can uses sas dataset in subquery
... View more