BookmarkSubscribeRSS Feed
cho16
Obsidian | Level 7
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.
2 REPLIES 2
andreas_lds
Jade | Level 19

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.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 291 views
  • 0 likes
  • 3 in conversation