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 ?

which date function advances a date, time or datetime value by a given interval? : Sas programming

1097

---

What is a method to debug and test your SAS program?

1440

---

What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

1199

---

How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?

2514

---

How many ways to overcome a missing values???

2865

---

What is data _null_?

1196

---

explain the function of substr in sas? : Sas-administrator

1066

---

What areas of SAS are you most interested in?

1580

---

What is the SAS data set?

1175

---

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2297

---

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2108

---

Enlist the functions performed by sas.

1190

---

Describe what are the different levels of administrative users in sas? : sas-grid-administration

1082

---

explain about sas business intelligence? : Sas-bi

1197

---

What is interleaving in SAS?

1177

---