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
- 13587 Views
- D&B, I also Faced
- E-Mail Answers
Answer Posted / kavitha
DATA D1;
INPUT SLNO DATE DATE9. ;
DATALINES;
1 12DEC08
2 22NOV08
3 01JAN08
4 12FEB07
5 13MAR07
6 24APR06
7 17MAY06
8 20JUN05
9 29JUL05
10 30APR09
;
RUN;
proc format ;
value KAVI low-'31DEC2006'd='***ddmonyy***'
'01JAN2007'd-'31DEC2007'd='***dd mon ccyy***'
'01JAN2008'd-high=' **Disco Years **';
RUN;
proc print data=D2 noobs label;
format DATE KAVI.;
RUN;
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
Explain by-group processing?
What would you change about your job?
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
Mention the difference between ceil and floor functions in sas?
Can you explain the process of calendar?
What is the use of function Proc summary?
Approximately what date is represented by the SAS date value of 730?
Which are the statements whose placement in the data step is critical?
what is the difference between infile and input? : Sas-administrator
What are the parameters of scan function?
What makes sas stand out to be the best over other data analytics tools?
Describe crosslist option in tables statement?
What will calendar procedure do?
How many ways to overcome a missing values???
How do dates work in sas?
