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
- 8903 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kamalan
proc format;
value datestyl low-'31dec1974'd = [date7.]
'01jan1975'd - '31dec1985'd = 'disco Years'
'01jan1986'd - max = [date9.] ;
Run;
proc print data = abc;
format dateval datestyl.;
Run;
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
How do you control the number of observations and/or variables read or written?
What are the limitations for memory allocation for SAS variables
what is fact table and factless table?
What procedure you used to calculate p-value?
2 Answers Accenture, Quintiles,
Differentiate between format and informat? : sas-grid-administration
What is shift table? have you ever created shift that?
2 Answers Accenture, Clinical Research, Quintiles,
how will you locate the sas platform applications? : Sas-bi
what are validation tools that are used in sas? : Sas-administrator
What is the registered Key word is sas????
How are numeric and character missing values represented internally?
What is LAG function?How is it used? can any one explain
3 Answers TRE, Verinon Technology Solutions,
What is the difference between a PROC step and a DATA step?
Teradata 
