DATA Step, Macro, Functions and more

Formatting a date in an output file.

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 9
Accepted Solution

Formatting a date in an output file.

I have a date field that looks like this:

DATA _NULL _;             

  DT = TODAY();           

  FORMAT DT YYMMDDD10.;   

The Date is 2012-02-23.

How do I write that to a flat file so that my field looks like that?

Trying to do:

FILE OUTFILE;                                

PUT                                          

@001   DT                             $10. 

@011   ID                                10. 

But I don't quite have it.

Thanks,

Tyler


Accepted Solutions
Solution
‎02-23-2012 05:27 PM
PROC Star
Posts: 7,471

Formatting a date in an output file.

Is this what you are looking for?:

DATA have;

  CREATEDATE = put(TODAY(),YYMMDD10.);

  id=1;

run;

data _null_;

  set have;

  FILE "c:\art\wantfile.txt";

  PUT @001   CREATEDATE  $10. @;

  put @011   ID 10.;

run;

View solution in original post


All Replies
Solution
‎02-23-2012 05:27 PM
PROC Star
Posts: 7,471

Formatting a date in an output file.

Is this what you are looking for?:

DATA have;

  CREATEDATE = put(TODAY(),YYMMDD10.);

  id=1;

run;

data _null_;

  set have;

  FILE "c:\art\wantfile.txt";

  PUT @001   CREATEDATE  $10. @;

  put @011   ID 10.;

run;

Occasional Contributor
Posts: 9

Re: Formatting a date in an output file.

Thanks for the help, that did the trick!

Tyler

CREATEDATE = put(TODAY(),YYMMDD10.);

PUT @001 CREATEDATE $10.

;

Text file looks like this: 2012-02-23

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 168 views
  • 0 likes
  • 2 in conversation