topic how to convert a string to mmddyy10. in SAS Procedures

how to convert a string to mmddyy10.

carterson2 — Tue, 03 Apr 2012 20:04:16 GMT

I want to print out a date in mmddyy10. format.

I am new, so I am sure my question is well-you-know... obvious....

put "&&d&i"

prints out as

19088

I want it to print out like this:

06/10/2012

I am stumped. Conversions stop me dead.........

Thanks for any help

jim

Hima — Tue, 03 Apr 2012 20:07:58 GMT

data have;
input tod mmddyy10.;
cards;
03/20/2012
01/02/2012
;
run;

proc sql;
select tod format mmddyy10. from have;
quit;

Hima — Tue, 03 Apr 2012 20:10:22 GMT

data have;
input tod mmddyy10.;
format tod mmddyy10.;
informat tod mmddyy10.;
cards;
03/20/2012
01/02/2012
;
run;

proc print; run;

Reeza — Tue, 03 Apr 2012 20:36:17 GMT

If its a macro variable as in your example then use something like the following:

%let test=19088;

%put %sysfunc(putn(&test, mmddyy10.));

You can replace &test with your &&d&i instead to get what you need.

Hope that helps!

carterson2 — Tue, 03 Apr 2012 22:08:32 GMT

this worked.

Thanks

tt= put(&&d&i,mmddyy10.);

put tt;