Proc export —keeping files for limited days option

[cho16]

Hi
For example, if I export the current day file to the share point, the current day will be appended to that location, and the last day file should be deleted. I only want to keep the files for 40 days on the share point site.
If there are any possibilities for implementing that logic on the proc export, please share your ideas.

[PeterClemmensen]

Show us your current code

[andreas_lds]

Just an idea: appending 01 ... 40 to the file name, so that after the 40th file is written, 1st file be overwritten on the next day. The tricky part is maintaining the counter in sas over session. You need to store it in a file (on the sas side) and process it each time a file is written.