There is a field containing a date. It needs to be
displayed in the format
"ddmonyy" if it's before 1975,
"dd mon ccyy" if it's after 1985, and
as 'Disco Years' if it's between 1975 and 1985.
How would you accomplish this in data step code? Using
only PROC FORMAT
Answer Posted / sudheendra reddy & veerend
DATA D1;
INPUT SLNO DATE DATE7.;
DATALINES;
1 12DEC73
2 22NOV71
3 01JAN76
4 12FEB77
5 13MAR83
6 24APR90
7 17MAY99
;
RUN;
proc format ;
value dat low-'31DEC1974'd=[date7.]
'01JAN1975'd-'31DEC1984'd="Disco Years"
'01JAN1985'd-high=[date9.];
RUN;
proc print data=D1 noobs label;
format DATE dat.;
RUN;
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the new features included in the new version of SAS Programming Language?
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
What are the different operating system platforms in which we can use sas? : sas-grid-administration
What are the limitations for memory allocation for SAS variables
what is sas business intelligence? : Sas-bi
Difference between nodup and nodupkey options?
What are the statements in proc sql?
what can you learn from the sas log when debugging? : Sas programming
how can you create zero observation dataset? : Sas programming
How necessary is it to be creative in your work?
How sas treats the dsd delimiters?
Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com
how can you put a "trace" in your program? : Sas programming
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
in the flow of data step processing, what is the first action in a typical data step? : Sas programming