topic Re: LAST MODIFIED WITH FILENAME WHICH WE ARE EXPORTING in New SAS User

LAST MODIFIED WITH FILENAME WHICH WE ARE EXPORTING

Kirito1 — Tue, 28 Feb 2023 11:54:48 GMT

I was working on SAS and I was able to get todays date with the file name and number of records with it. Unfortunately, the user wants last modified date to be attached with filename.

Kindly, help I have no Idea how to proceed. Although, I was reading and found the below link

https://support.sas.com/kb/40/934.html

I think the link might help. If someone could provide a solution.

Thanks in advance

Re: LAST MODIFIED WITH FILENAME WHICH WE ARE EXPORTING

brzcol — Tue, 28 Feb 2023 18:41:20 GMT

Hello,

Do you just want the date included or you want both the date and time?

Here is a possible solution to get you started based on the link you provided. There may be better alternatives. What this creates is an excel file called Tester_28Feb2023.

Is that what you were looking for?

%let exportpath=A:\examplefolder\output\Tester.xlsx;

filename fileref "&exportpath";                                                                                                          
data a(drop=fid);                                                                                                                       
   infile fileref truncover obs=1;                                                                                                       
   fid=fopen('fileref');                                                                                                                                                                                                                    
   moddate=scan(finfo(fid,'Last Modified'),1,':'); /*Just give the date portion instead of full date time*/
   call symputx('ModDate',Moddate); /*Create a macro variable called ModDate that holds the value of the variable created above*/
run; 

%put &ModDate; /*Make sure it looks right*/


proc export data=sashelp.class dbms=xlsx outfile="A:\examplefolder\output\Tester_&ModDate..xlsx" replace;
run;

Re: LAST MODIFIED WITH FILENAME WHICH WE ARE EXPORTING

ballardw — Tue, 28 Feb 2023 19:55:13 GMT

@Kirito1 wrote:

I was working on SAS and I was able to get todays date with the file name and number of records with it. Unfortunately, the user wants last modified date to be attached with filename.

Kindly, help I have no Idea how to proceed. Although, I was reading and found the below link

https://support.sas.com/kb/40/934.html

I think the link might help. If someone could provide a solution.

Thanks in advance

Last modified for the file created? Or for the SAS data set?

If the SAS data set you can consult the SAS metadata. This is just one way. The Dictionary.Tables special view contains the names, types and some of the characteristics, such as number of observations, creation date and modification date. The Libname and Memname (date set name) are stored in upper case letters. The SQL INTO allows selecting the values into macro variables as about the shortest code.

data work.newjunk;
   x=3;
run;


proc sql noprint; 
   select strip(put(nobs,best12. -L)), put(datepart(modate),date9.) into: Numobs , : Moddate
   from dictionary.tables
   where libname='WORK' and memname='NEWJUNK'
   ;
quit;

%put number of obs is: &Numobs., Modification Date is: &Moddate. ;

Use the &numobs and &Moddate in your file name.

Still think you should use the YYMMDDN8. format instead of Date9. though.

Re: LAST MODIFIED WITH FILENAME WHICH WE ARE EXPORTING

Kirito1 — Wed, 01 Mar 2023 06:51:42 GMT

Thank you for your response @brzcol can you Please explain what does the code above is doing as I am unable to understand how can I inculcate the above code with my existing code.