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
its
between 1975 and 1985. How would you accomplish this in
data step code? Using only PROC FORMAT.
Answer Posted / j. sheetal
Here is the correction in above example,
proc format;
value datestyl low-'31dec1974'd = [date7.]
'01jan1975'd - '31dec1985'd = 'disco Years'
'01jan1986'd - high = [date9.] ;
Run;
Example:
data k1;
input date2 $9.;
cards;
31dec1974
01jan1975
01jan1985
01jan1990
;
data temp;
set k1;
date1=input(date2,date9.);
sam = date1;
format sam datestyl.;
run;
proc print;
run;
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
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.
How do you specify the number of iterations and specific condition within a single do loop?
What are the features of base sas system?
what is change analysis in sas di ? : Sas-di
why a stop statement is needed for the point= option on a set statement?
What can be the size of largest dataset in SAS?
Which function is used to count the number of intervals between two sas dates?
Difference between SAS STATA & SPSS?
What are pdv and it functions?
how do you want missing values handled? : Sas programming
what is information maps?
what other sas products have you used and consider yourself proficient in using? : Sas programming
What is the basic structure of the SAS base program?
How can you create a macro variable with in data step? : sas-macro
explain what is factor analysis? : Sas-administrator