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
- 13688 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 is maximum number of rows and cols can be handled in SAS?
Mention few capabilities of sas framework.
Differentiate input and infile.
Describe the function and untility of the most difficult SAS macro that you have written.
Explain proc sort?
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
what is data governance? : Sas-di
What are the implications?
how do the in= variables improve the capability of a merge? : Sas programming
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
how can you import .csv file in to sas? : Sas programming
for what purpose would you use the retain statement? : Sas programming
What is a method to debug and test your SAS program?
How to read an input file in sas?
what is sas and what are the functions? : Sas-administrator
