topic Re: date in SAS Programming

date

SASPhile — Tue, 28 Sep 2010 16:26:17 GMT

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

Re: date

Cynthia_sas — Tue, 28 Sep 2010 17:27:26 GMT

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

cynthia

Re: date

chang_y_chung_hotmail_com — Tue, 28 Sep 2010 17:29:40 GMT

[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]

Re: date

SASPhile — Tue, 28 Sep 2010 18:06:49 GMT

character

Re: date

Tim_SAS — Tue, 28 Sep 2010 18:23:05 GMT

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

Re: date

PatrickG — Mon, 13 Dec 2010 15:40:51 GMT

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