Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / thirumalesh.e.
We can delete using Proc NoDupkey NoDuprecs and
NoDuplicates, then by Dupsort system option, then
if.first . last, Proc sql, create by select * unique ...
OK.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
For what purposes have you used sas macros? : sas-macro
What do the mod and int function do? : Sas programming
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.
What are the prime responsibilities of data integration administrator? : Sas-di
how does sas handle missing values in sort order? : Sas programming
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
What is SAS?
What is the maximum length of the macro variable?
What is the difference between %put and symbolgen? : sas-macro
What is proc sort?
Explain bmdp procedure?
Difference between SAS STATA & SPSS?
Which command is used to perform sorting in sas program?
Where do you use proc means over proc freq?
how can you put a "trace" in your program? : Sas programming
