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
- 13589 Views
- D&B, I also Faced
- E-Mail Answers
Answer Posted / amit gupta
Apologies,
above code has an extra "FROM d1"
The working code is as below:
proc sql;
select
case when date lt '31DEC2006'd then date end as mydate
format=date7. ,
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;
However it does give the data in 3 columns , which I was
unable to merge as the data type was different.
Any working solution using format ?
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is sas olap server? : Sas-di
what are input dataset and output dataset options? : Sas programming
What are the features of base sas system?
what is broad cast agent? : Sas-bi
Are you involved in writing the inferential analysis plan? Tables specfications?
What are the uses of sas?
Briefly explain input and put function?
Do you need to rearrange the order of the data for the report?
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
What is the difference between the proc sql and data step?
What is the sas data set? : sas-grid-administration
what are informats in sas? : Sas-administrator
how does sas handle missing values in formats? : Sas programming
Give some examples where proc report’s defaults are different than proc print’s defaults?
What is the difference between reading data from an external file and reading data from an existing data set?
