Interested to Buy Any Domain ? << Click Here >> for more details...
diff between nodup rec and ondup key???
- 3 Answers
- 10082 Views
- AON, Sciformix, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mallikarjuna
nodupkey deletes duplicate observations based on by
variable.
noduprec delete the duplicate observations if entire
observation is duplicate.
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / ramkgupta
simply to say nodup and noduprec checks values present in all variables in dataset from one record to next record where as nodupkey checks values present in only variables given in by statement not all variables in a dataset.
| Is This Answer Correct ? | 5 Yes | 0 No |
whenever we using the merging through data set merging ,we can get note in log like this "MERGE STATEMENT HAS MORE THAN ONE ONE DATASET BY REPEATED BY VAIABLES" but the output has come in good manner,whenever in in sql(full join) we can get cartion product.so How do overcome this problem in sql?
How would you identify a macro variable?
How to read multiple excel sheets from a single excel file at once????
7 Answers HCL, Verinon Technology Solutions,
calculate the sum of value using only DATA STEP. data count_; input year name $ value; cards; 2006 xxx 10 2007 yyy 12 2006 xxx 20 2008 yyy 15 2007 xxx 15 ; out put should be like this year name T_value ----------------------- 2006 xxx 30 2007 xxx 15 2007 yyy 12 2008 xxx 15
What r all the reporting procedures...?
how sas deals with business intelligence? : Sas-bi
explain the key concept of sas? : Sas-administrator
How do you debug macros?
How can I remove header from output data set?
What is the difference between proportion and average?
What is Linear Regression?
Mention few capabilities of sas framework.
Teradata 
