how can u join the two tables without using proc sql Joins
and nested queries ?
Answer Posted / sai
we can join two tables by using merge statement and also by
using two SET statements .
data one;
set two;
set three;
run;
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are types of transport files?
How do you debug and test your SAS programs?
What was the last computer book you purchased? Why?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
What are the parameters of scan function?
explain the use of % includes a statement in sas? : Sas-administrator
If a variable contains only numbers, can it be a character data type?
What are the difference between sas functions and procedures?
how do you test for missing values? : Sas programming
Explain the purpose of retain statement.
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.
Mention few capabilities of sas framework.
what are _numeric_ and _character_ and what do they do? : Sas programming
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
What is by-group processing?