Right, gotcha. So in step 4 the program uses a file path because it is assigning a date and time to the file name. How can I get Proc Export to pick up the most recently created file? /*Step 3*/
data _null_;
cdate2 = "&SYSDATE9";
ctime2 = "&SYSTIME";
time_string = cdate2||"_"||translate(ctime2, "_", ":");
call symput('hw_time2', time_string); /*name the variable between ''*/
run;
/*Step 4*/
data "S:\CommunityHealth\DPHO-Harlem\Research, Evaluation, and Planning\Henry\EHACE\Case_Disposition_Dailyrun\counselor_daily\casedis_Coun_&hw_time2";
set caseDisposition_counselorDaily;
run;
... View more