Answer Posted / nani
i think we can hard code when we are in need of producing
the report in urgent requirement and if we are not going to
use the code again.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
What are the data types that sas contain?
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.
Why double trailing @@ is used in input statement?
what versions of sas have you used (on which platforms)? : Sas programming
what type of graphs we will create(for 2+years candidates)?
How long can a macro variable be? A token? : sas-macro
how does sas handle missing values in functions? : Sas programming
describe about metadata object? : Sas-di
What are the statements in proc sql?
which date functions advances a date time or date/time value by a given interval? : Sas programming
What is the difference between input and infile statement?
Difference between sum function and using “+” operator?
What is the use of function Proc summary?
Explain why double trailing @@ is used in input statement?