topic Re: Proc export —keeping files for limited days option in SAS Programming

Proc export —keeping files for limited days option

cho16 — Tue, 30 Aug 2022 04:11:37 GMT

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.

Re: Proc export —keeping files for limited days option

PeterClemmensen — Tue, 30 Aug 2022 04:12:41 GMT

Show us your current code

Re: Proc export —keeping files for limited days option

andreas_lds — Tue, 30 Aug 2022 04:55:10 GMT

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.