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
- 14065 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 is proc Index? and what is proc document?
What are the different servers in sas? : sas-grid-administration
Describe the ways in which you can create a macro variable?
What is the sas data set? : sas-grid-administration
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
What is the difference between proportion and average?
Of all your work, where have you been the most successful?
is data integration and etl programming is same? : Sas-di
What is the use of stop statement?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
for report generation which one you used proc report or data_null_?
What are the automatic variables for macro? : sas-macro
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
Explain translate function?
Explain the main difference between the sas procedures and functions? : Sas-administrator
