topic SAS file name saved in Lib in SAS Programming

SAS file name saved in Lib

Citrine10 — Thu, 09 Sep 2021 12:08:19 GMT

hi there

i am saving a file in a library and I want to datestamp it with todays date for e.g.

MyLib.Testfile_280921

how do I do that so that the date can be passed using todays date variable?

Re: SAS file name saved in Lib

PaigeMiller — Thu, 09 Sep 2021 12:54:46 GMT

Let me point out that files named like MyLib.Testfile_280921 will not sort in any meaningful way, and if you change to YYMMDD, then the files will sort in chronological order.

So, you can use

data mylib.testifle_%sysfunc(today(),yymmddn8.);

Re: SAS file name saved in Lib

ChrisNZ — Fri, 10 Sep 2021 07:01:29 GMT

@PaigeMiller is totally right: year first or nothing.

Re: SAS file name saved in Lib

Kurt_Bremser — Fri, 10 Sep 2021 09:30:07 GMT

What @ChrisNZ and @PaigeMiller said: YMD order, nothing else. And use 4-digit years, so 19991231 comes before 20000101.