how can u convert this 25-jul-2010 from numeric to charcter?
Answers were Sorted based on User's Feedback
Answer / vigneshwaran.s
Read the date using informat date11. Then you can move this
Numeric SAS date to a Character variable. You can see in
the SAS Log that Numeric has been converted to Chanracter.
Option 2 : Is use a Put Function,
New_date = Put(Given_date,Format)
| Is This Answer Correct ? | 10 Yes | 2 No |
what is the difference between floor and ceil functions in sas? : Sas-administrator
How do you add a number to a macro variable?
How would you create multiple observations from a single observation?
What is the command used to find missing values?
what is sas data set?
Approximately what date is represented by SAS date value of 730
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
Give e an example of..
How would you combine 3 or more tables with different structures?
What is shift table? have you ever created shift that?
2 Answers Accenture, Clinical Research, Quintiles,
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn?t have a value?
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.