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 is treatment emergent events and treatment emregent adverse event
how sas deals with business intelligence? : Sas-bi
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
What is the purpose of trailing @ and @@? How do you use them?
What are the features of SAS?
Give some examples where proc report’s defaults are different than proc print’s defaults?
How would you invoke a macro? : sas-macro
describe the interaction table in sas di? : Sas-di
what is the effect of the options statement errors=1? : Sas programming
what are the scrubbing procedures in sas? : Sas programming
explain the key concept of sas? : Sas-administrator
how will you locate the sas platform applications? : Sas-bi
What are the statements that are executed only?
In proc transpose and data step with arrays which one you pick?
Tell me more about the parameters in macro? : sas-macro