@Tom When I run your code, it completes successfully to create the SQL, but all of the IDs are just 11 spaces and a period inside each set of single quotes. The source table is listed and the log reads in the exact correct number of observations. Please see below for a slightly edited for privacy LOG: NOTE: Writing HTML5(EGHTML) Body file: EGHTML 27 28 %let limit=1000; 29 30 filename code temp; 31 data _null_; 32 set recips_20240317_a end=eof ; 33 file code lrecl=80 ; 34 length qid $20 ; 35 qid=quote(trim(id),"'"); 36 if mod(_n_,&limit)=1 then do; 37 fileno+1; 38 put 'create table WANT' fileno 'as ' 39 / 'select * from connection to con1 (' 40 / 'select * from schema.oracle_table where ID in ' 41 / '(' @ 42 ; 43 end; 44 else put ',' @; 45 put qid @; 46 if eof or mod(_n_,&limit)=0 then do; 47 put ')' / ');' ; 48 end; 49 if eof then call symputx('nfiles',fileno); 50 run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 35:18 NOTE: Variable id is uninitialized. NOTE: The file CODE is: 2 The SAS System 15:35 Friday, March 15, 2024 Access Permission=-rw-rw----, Last Modified=18Mar2024:10:57:59 NOTE: 42616 records were written to the file CODE. The minimum record length was 1. The maximum record length was 79. NOTE: There were 207881 observations read from the data set WORK.HAVE. NOTE: DATA statement used (Total process time): real time 0.12 seconds user cpu time 0.03 seconds system cpu time 0.00 seconds memory 600.75k OS Memory 33436.00k Timestamp 03/18/2024 10:57:59 AM Step Count 27 Switch Count 0 Page Faults 0 Page Reclaims 13 Page Swaps 0 Voluntary Context Switches 7 Involuntary Context Switches 15 Block Input Operations 0 Block Output Operations 0 ... 55 %include code / source2; NOTE: %INCLUDE (level 1) file CODE is file .... 56 +create table WANT1 as 57 +select * from connection to con1 ( 58 +select * from abms.int_elig_update_audit where billing_num in 59 +(' .' ,' .' ,' .' ,' .' ,' .' 60 +,' .' ,' .' ,' .' ,' .' ,' .' 61 +,' .' ,' .' ,' .' ,' .' ,' .' 62 +,' .' ,' .' ,' .' ,' .' ,' .' 63 +,' .' ,' .' ,' .' ,' .' ,' .' 64 +,' .' ,' .' ,' .' ,' .' ,' .' 65 +,' .' ,' .' ,' .' ,' .' ,' .' 66 +,' .' ,' .' ,' .' ,' .' ,' .' 67 +,' .' ,' .' ,' .' ,' .' ,' .' 68 +,' .' ,' .' ,' .' ,' .' ,' .' 69 +,' .' ,' .' ,' .' ,' .' ,' .' 70 +,' .' ,' .' ,' .' ,' .' ,' .' 71 +,' .' ,' .' ,' .' ,' .' ,' .' 72 +,' .' ,' .' ,' .' ,' .' ,' .'
... View more