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
its
between 1975 and 1985. How would you accomplish this in
data step code? Using only PROC FORMAT.
- 3 Answers
- 8732 Views
- CTS, I also Faced
- E-Mail Answers
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
What are the differences between proc means and proc summary?
what are 5 ways to perform a table lookup in sas? : Sas-administrator
What do the PUT and INPUT functions do?
What is PROC in SAS?
How to create an external dataset with sas code?
Differentiate between proc means and proc summary.
What are the difference between the sas data step and sas procs?
What is the purpose of _character_ and _numeric_?
Explain what is the use of proc gplot?
Describe the ways in which you can create macro variables?
What is the use of divide function?
Given an unsorted data set, how to read the last observation to a new data set?
What is your favorite all time computer book? Why?
If a variable contains letters or special characters, can it be numeric data type?
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
