How to display duplicate observations in data?
Answer / ravi
we can use the sort DUPOUT in the sort procedure to display the duplicate records as a separate dataset.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are all the problems you faced while validating tables and reports?
0 Answers Accenture, Quintiles,
What is the difference between reading data from an external file and reading data from an existing data set?
Have you been involved in editing the data or writing data queries?
1 Answers BioServe, Oracle, Sasken,
How would you code a merge that will keep only the observations that have matches from both sets?
Can we use where and having clauses in a single SAS program. ex: proc sql; select a,b,c from test where state in 'KA' and having <some condition>. Is the above program run correctly, if not why ?
What other SAS features do you use for error trapping and data validation?
Explain proc sort?
What are the parameters of scan function?
what are the validation tools in sas?
What is the basic structure of a sas program?
What are the functions which are used for character handling functions?
what are all the default values getting in PROC MEANS...???