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
- 11725 Views
- D&B, I also Faced
- E-Mail Answers
Answer Posted / vijs
data new ;
input date ddmmyy10. ;
cards;
01/05/1955
01/09/1970
01/12/1975
19/10/1979
25/10/1982
10/10/1988
27/12/1991
;
run;
proc format ;
value dat low-'01jan1975'd=ddmmyy10.
'01jan1975'd-'01JAN1985'd="Disco Years"
'01JAN1985'd-high=date9.;
run;
proc print;
run;
proc print;
format date dat. ;
run;
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
What is the use of divide function?
why is sas data integration studio important? : Sas-di
what is sas and what are the functions? : Sas-administrator
name several ways to achieve efficiency in your program? : Sas programming
What are SAS/ACCESS and SAS/CONNECT?
what are the considerations when picking a SAS/STAT procedure?
Mention what is PROC in SAS?
How does the internal authentication work in sas? : sas-grid-administration
How can I remove header from output data set?
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
What is run-group processing?
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
What are the different types of sas functions?
what is data governance? : Sas-di
What is the length assigned to the target variable by the scan function?
