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
- 13894 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
What are the functions which are used for character handling functions?
What does the trace option do?
For what purposes have you used sas macros? : sas-macro
How would you identify a macro variable? : sas-macro
what is data integration? : Sas-di
how to remove duplicates using proc sql?
What do the PUT and INPUT functions do?
Describe the function and utility of the most difficult SAS macro that you have written?
Mention what is the difference between nodupkey and nodup options?
what is business intelligence? : Sas-bi
is data integration and etl programming is same? : Sas-di
how many display types available in sas bi dashboard? : Sas-bi
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??
How to create list output for cross-tabulations in proc freq?
Explain the difference between using drop = data set option in set and data statement?
