Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sowjanya
data one;
merge three(in=var1) two(in=var2);
by var;
if var1=1 and var2=1;
run;
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
how many types of prompts are there? : Sas-bi
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.
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
What makes sas stand out to be the best over other data analytics tools?
how do you want missing values handled? : Sas programming
What are the advantages of using sas?
which date function advances a date, time or datetime value by a given interval? : Sas programming
Which command is used to perform sorting in sas program?
What do the SAS log messages "numeric values have been converted to character" mean?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
What are the statements that are executed only?
What are the functions which are used for character handling functions?
How would you invoke a macro? : sas-macro
Explain data step in SAS
