Yes that was the only problem. the column is the column 41. thanks ... View more

This seems like a rather roundabout way to define a date, why not just write data test4; set test3; if T2DM=0 then Diag_day='01JAN1998'd; format Diag_day mmddyy10.; run; Essentially if T2DM is equal to 0 then diag_day is converted to the SAS date for 01/01/1998 Also this way you don't have to create an extra variable in Diag_day_Q which you likely will have to delete in the future, or have to make sure that your substr commands are all in the right places. For reference you can always directly specify a date by putting it into the DDMMMYYYY format wrapping it in ' and putting a d after it. ... View more

Oh, how wonderful. I completely overlooked 's subsetting part. I kept reading it as the standard PROC GPROJECT. I am so glad the mystery of my crooked map is solved. This is going to be a good week! Thank you !!! Anca. ... View more

So many different ways of doing it... thanks everyone, that helped me a lot. Wish I could mark more correct/helpful answers. ... View more

Thank you for the reply! I finally create a new table like you suggest. Thank you again. ... View more

Thanks! ... View more

Thanks Arthur.....It gave the intended results but  I wasn't sure about the functionality of Monotonic....So I am using the other approach. Thanks for your time and assistance. ... View more

Art I think there is an argument for retaining the retain as an explicit statement in this case.  As the statement is interpreted at compile time it does not make the code any less efficient but it does act to signal (to anyone who has to maintain the code) that the value is being retained.  Richard now back in NZ And a prosperous New Year to you PS was stoked at the poke in your Christmas joke ... View more

Correct and make sure to put the parentheses outside of the file names, they are not required if you are only sending one file, but are if you are sending multiple ones. ... View more

Thanks for the advice, the scan function was written farther down in the macro and I cut it off at reading the file names into table so there wouldn't be unnecessary code. But here is what the code looks like once I implemented your suggestions and it is working now. %LET source = C:\Users\Home\Documents\; %LET library = out; libname &library "&source"; %macro daily(type = ); %macro get_filenames(location); filename _dir_ "%bquote(&location.)"; data filenames(keep=memname);   handle=dopen( '_dir_' );   if handle > 0 then do;     count=dnum(handle);     do i=1 to count;       memname=dread(handle,i);       output filenames;     end;   end;   rc=dclose(handle); run; filename _dir_ clear; %mend; %get_filenames(&source);   data dirlist ;                                                   set filenames;     if substr(memname,length(memname)-2,3) ~="&type" then delete;     parse = substr(memname,1,length(memname)-4);     file_name = memname;     keep file_name parse; run; proc sql noprint; select parse, file_name into :parse_list separated by '*', :file_list separated by '*' from dirlist; quit; %let cntlist = &sqlobs; %do i = 1 %to &cntlist; %let parse = %scan(&parse_list.,&I.,"*"); %let file = %scan(&file_list.,&I.,"*"); proc import out=daily_&i       datafile="&source\&parse"      dbms=csv replace;      getnames=yes;      guessingrows=10000; run; %end; %mend; %daily(type = txt); ... View more