I am trying to dynamically generate filenames through a do loop and date manipulation. I have multiple files placed at a path. These files have the date appended in their name. I am using a cats operator to dynamically generate the path and assign it to a fileref but it errors out. Can someone please help. data _null_;
startd='10feb2019'd;
endd='10feb2019'd;
dif=intck('day',startd,endd);
do i=0 to dif;
date1= intnx('day',startd,i);
format date1 yymmddn8.;
fname = cats('F',i);
fpath= catx(put(date1,yymmddn8.),"gunzip -c /DATA/RISK/project/baba/black/Eccvfg_input.",".ods.gz");
filename fname fpath;
datname = cats('DQ_',put(date1,yymmddn8.));
put fpath;
end;
run;
... View more