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
- 14071 Views
- D&B, I also Faced
- E-Mail Answers
Answer Posted / amit gupta
proc sql;
select
case when date lt '31DEC2006'd then date end as mydate
format=date7. from d1
case when date gt '31DEC2008'd then date end as mydate
format=date9. ,
case when '01JAN2007'd <= date <= '31DEC2008'd then 'DUMMY'
end as mydate
from d1 ;
quit;
Just that these are in three different columns;
Tried the above resolutions but unsuccessfully.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are sas bi dashboard components? : Sas-bi
List out some key concept of SAS
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
How do you use the do loop if you don’t know how many times you should execute the do loop?
What is PDV?
what is enterprise guide? What is the use of it? : Sas programming
explain about data integrator metadata reports? : Sas-di
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
name the scheduler for scheduling job and explain the scheduler? : Sas-di
Explain proc sort?
how do you pull data from equifax?tell me the process?
what are the categories that sas informats are used to the place the data? : Sas-administrator
why is sas data integration studio important? : Sas-di
Explain the special input delimiters used in sas programming.
