Output file name with date from a data set

[LRogers]

Hello!

I'm trying to change the name of my outfile....

Currently I'm using today's date to stamp the date at the end of my file name. 

%let numdate = %sysfunc(today(), MONYY7.);
proc export data=WORK.FORMAT_FIELDS
outfile="Z:\Commercial Operations\TRANSITION\test\TERR_TRX_SENSORS&numdate..txt"
dbms=dlm
replace;
delimiter='|';
run;

So what I'm getting for my file name is TERR_TRX_SENSORSJULY2019.

This works great, however what I would like to do is instead of using today's date, I would like to use a date within my data set.

For example, In my WORK.FORMAT_FIELDS table, I have a field called CAL_MTH_DT.  The CAL_MTH_DT is 5/31/2019, so I would like it to be something like:

%let numdate = %sysfunc(CAL_MTH_DT, MONYY7.);
proc export data=WORK.FORMAT_FIELDS
outfile="Z:\Commercial Operations\TRANSITION\test\TERR_TRX_SENSORS&numdate..txt"
dbms=dlm
replace;
delimiter='|';
run;

That way my file name comes out as TERR_TRX_SENSORSMAY2019.

But this is working and I'm trying to figure out how to make the date the date from my data set if possible.

Thank you!

[Kurt_Bremser · Accepted solution]

data _null_;
set work.format_fields (obs=1);
call symput('ts',put(cal_mth_dt,yymmn6.));
run;

proc export
  data=work.format_fields
  outfile="Z:\Commercial Operations\TRANSITION\test\TERR_TRX_SENSORS&ts..txt"
  dbms=dlm
  replace
;
delimiter='|';
run;

[LRogers]

Thank you so much, Kurt!  

This worked great!!!!  Great learning for me!