Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vij
Two types
One - to -one mergeing:
combine observations from two data sets into a single
observation in a new data set:
Match- Merging:combine observations from two data sets into
a single observation in a new data set according to the
values of a variable that is specified in the BY statement:
| Is This Answer Correct ? | 16 Yes | 3 No |
Post New Answer View All Answers
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
What are the difference between the sas data step and sas procs?
what is sas metadata server? : Sas-di
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.
how can you put a "trace" in your program? : Sas programming
What is a method to debug and test your SAS program?
What is Linear Regression?
what techniques and/or procs do you use for tables? : Sas programming
What are the data types that sas contain?
What are the difference between ceil and floor functions in sas?
What is maximum storage capability of SAS?
what is hierarchy flattening? : Sas-di
How can you create a macro variable with in data step? : sas-macro
Tell e how how dealt with..
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
