date

[SASPhile]

I have a date 20100430.How to show it as Apr-10?

[Cynthia_sas]

Hi:
It depends is that value a character string or a number????

cynthia

[SASPhile]

character

[chang_y_chung_hotmail_com]

[pre]
proc format;
picture monyyd
low-high = '%b-%0y' (datatype=date);
run;
data _null_;
d = input('20100430', yymmdd8.);
f = propcase(put(d, monyyd6.));
put f=;
run;
/* on log
f=Apr-10
*/
[/pre]

[Tim_SAS]

[pre]
data _null_;
d = input('20100430', yymmdd8.);
put 'd=' d monname3. '-' d year2.;
run;
[/pre]
writes to the log:
[pre]d=Apr-10
[/pre]

[PatrickG]

There's a lot of good info on using SAS dates here. Hopefully, this helps.

http://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a002200738.htm