Hello, I have the following files which are generated daily from another system which is date and time stamped. I have a SAS process which is required to read in these daily files. I have set up a macro variable so that it creates the date with the last business day %let file_date_m   = &file_date_yr.&file_date_mth.&file_date_day.; As for the time, I would not know when it will be generated, my question is, how can I find the correct file for SAS to read in and can the time part be omitted ? I would like to set up a macro variable like this (%let cdsfilename = "CDSALL0E_&file_date_m._&time.csv"n;) so that I can read in the correct file depending on the business day. These files are being read in via PC Files Server. Examples of the filenames: CDSALL_20150810_081411.csv CDSALL_20150811_073451.csv CDSALL_20150812_072431.csv CDSALL_20150813_080519.csv CDSALL_20150814_075526.csv CDSALL_20150817_080139.csv CDSALL_20150818_071141.csv CDSALL_20150819_082730.csv Thank you. ... View more

Hi, I'm using the following to create a text delimited file. However for the fields that have null value, the output text file is generating a space between the delimiters. Is there any way to get rid of the blanks ? I cannot use proc export as I cannot customise the header and trailer (or is it possible to customise headers/trailers in proc export ?) Thanks  ! data _null_;   dt= datetime();   format dt YMDHMS.;   format Business_Date b8601da.;   format OBS Z8.;   format amount_SUM Z20.;   retain amount_SUM;   set sas_extract_formatted end=EFIEOD NOBS=OBS;   FILE  'C:\Users\f051615\rawfile.txt' DLM='~' LINESIZE=1000;    /* Output Text File */   if _n_ = 1 then do;   PUT "H~SASX~" Business_Date dt;   end;   do;   amount_SUM=sum(amount_SUM,amount_Final);   /*put (_all_)(+0);*/   PUT 'D~'   Business_Date   Month_Key   Period_Id   Customer_Id end; if EFIEOD then do;    PUT "T~" OBS CEA_SUM; end; run ; ... View more