diff between nodup rec and ondup key???
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 |
In a shcool there are 1000 students. After completion of every test in 6 subjects , each subject teacher submit the marks of every student at different times and loaded in the database commonly. How will you seperate the top two subject marks for each each studet using SAS?
What are the advantages of using sas?
data task; input id date date9. visit; cards; 101 01jan2015 1 101 02jan2015 2 101 06jan2015 3 102 04jan2015 1 102 07jan2015 2 102 12jan2015 3 103 06jan2015 1 103 13jan2015 2 ; run; write a program to find out missing dates between visits by each subject.
What is the difference between match merge and one to one merge?
Do you know the features of sas?
When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?
what are the sites did u refer for enquiries and doubts for SAS
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
which date function advances a date, time or datetime value by a given interval? : Sas programming
what is the difference between unique key and primary key? : Sas-di
What is _n_?
How would you remove a format that has been permanently associated with a variable? ________________