what are the different ways of merging two datasets.name
atleast 4.
- 2 Answers
- 5361 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / apurba gorai
1.Merge in Data Step
2.Proc sql join
3.Proc Format
4.Hash tables
5.Arrays
| Is This Answer Correct ? | 9 Yes | 1 No |
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
What is highest missing value for numeric?
i have a dataset with 25 obs; 10th obs has like ramu,anji,ramu,azad,ramu like this. i want to know how many times the word repeats in that obs?
sas macros
What function CATX syntax does?
Hi, If anyone has base SAS certification dumps, please share.
how many data types in sas? : Sas-administrator
Why do we use QUIT commmand for proc datasets and proc sql ???
How would you remove a format that has been permanently associated with a variables?
Difference b/n proc means and proc summary procedures?
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 do u validate the program which u have written.
Teradata 
