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
- 11703 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 scrubbing procedures in sas?
What is the difference between INPUT and INFILE ?
Mention common programming errors committed in sas ?
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
name the scheduler for scheduling job and explain the scheduler? : Sas-di
what is the use of proc sql? : Sas programming
what is the function of catx syntax? : Sas-administrator
Tell e how how dealt with..
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
what are sas/access and sas/connect? : Sas programming
Explain what is SAS informats?
AE datasets names? how many types?
how the sas basic syntax style described? : Sas-administrator
What is PDV?
