Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8 Answers
- 14083 Views
- D&B, I also Faced
- E-Mail Answers
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 different types of sas functions?
explain about data integrator metadata reports? : Sas-di
Explain what Proc glm does?
What are the difference between ceil and floor functions in sas?
what is the difference between unique key and primary key? : Sas-di
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
What are the applications primarily used by business analyst? : Sas-bi
what is metadata? : Sas-bi
Explain proc univariate?
What is slibref?
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
In sas admin differentiate between roles and capabilities? : sas-grid-administration
what is the purpose of _error_? : Sas programming
What are the difference between sas functions and procedures?
