topic update a xpt file name with the sysdate in SAS Programming

update a xpt file name with the sysdate

deleted_user — Mon, 16 Aug 2010 20:02:35 GMT

I have set up a sas program to runn automatically and create an XPT file. How can I update this xpt file name to have current date in the name in order to identify the xpt ?
Any suggestion would be helpful

Re: update a xpt file name with the sysdate

ArtC — Tue, 17 Aug 2010 06:05:26 GMT

When you create the name of a data set or file say xxxx include the macro variable &sysdate (I prefer &sysdate9) in the name. Something like:

xxxx&sysdate9

If an extension is needed

xxxx&sysdate9..xpt (notice the double dot)

Re: update a xpt file name with the sysdate

sbb — Tue, 17 Aug 2010 12:51:21 GMT

Also, any SAS date format can be generated using %SYSFUNC with PUTN as shown below:

%let today_formatted = %sysfunc(putn(%sysfunc(today()),yymmddn8.));
%put _user_;

Scott Barry
SBBWorks, Inc.

Re: update a xpt file name with the sysdate

data_null__ — Tue, 17 Aug 2010 14:27:05 GMT

Too many %SYSFUNCs. The often neglected optional second parameter is

[pre]
4594 %let today_formatted = %sysfunc(today(),yymmddn8.);
4595 %put _user_;
GLOBAL TODAY_FORMATTED 20100817
[/pre]

Re: update a xpt file name with the sysdate

deleted_user — Tue, 17 Aug 2010 14:37:36 GMT

Thanks, but how do I assign this to the filename? for eg xpt name XXXXXX_&sysdate9...xpt should be create in filename trfile 'C:\SAS\XXXXXX_&sysdate9...xpt. Is this possible or there is some other means of doing it?

Re: update a xpt file name with the sysdate

deleted_user — Tue, 17 Aug 2010 14:39:59 GMT

%let today_formatted = %sysfunc(today(),date9.); is the format I am using, but how can I assign this in the trfile where it has to be created?

Re: update a xpt file name with the sysdate

data_null__ — Tue, 17 Aug 2010 14:44:14 GMT

Are you wanting to add the date stamp to each SAS data set name this is added to the date stamped XPORT library?

Re: update a xpt file name with the sysdate

deleted_user — Tue, 17 Aug 2010 14:50:38 GMT

No. only to the XPT file that will be created using cport. for eg my code is

%let today = %sysfunc(today(),date9.);
libname trData 'P:\SAS Programs\Datasets';
filename trFile 'P:\SAS Programs\Data\Datasets\Lm-LLO-E7-07_EXTRACT_&today...xpt' ;

proc cport library=trData file=trFile;
run;

Is my code correct for creating an XPT with date stamp?

Re: update a xpt file name with the sysdate

data_null__ — Tue, 17 Aug 2010 14:54:47 GMT

> filename trFile 'P:\SAS Programs\Data\Datasets\Lm-LLO-E7-EXTRACT_&today...x> pt' ;

You need to use DOUBLE quotes so &today will be resolved.

Re: update a xpt file name with the sysdate

deleted_user — Tue, 17 Aug 2010 15:08:51 GMT

Thanks a lot. I just missed to try that simple step!!!! Thanks, anyways.

One more question:
How do we handle the missing values in a field(VSTMD) thats a varchar datatype and that has to be written into a numeric SAS date field? Since it is a "null" value, SAS considers as both character and numeric variable. How can this be resolved?

Re: update a xpt file name with the sysdate

sbb — Tue, 17 Aug 2010 18:23:59 GMT

See reply to "How do we handle..." here:

http://support.sas.com/forums/thread.jspa?threadID=10841 Message was edited by: sbb