How to write duplicate records into a separate dataset using
sort?
- 4 Answers
- 11827 Views
- HSBC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vimal
PROC SORT DATA=data_a DUPOUT=dup_data
NODUPKEY
OUT=nodup_data;
BY x;
RUN;
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / yam
First sort the data set by the key variable and then
data dup;
set indata1;
if not(first.keyvar) then output dup;
run;
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / charan araveti
if u dont want to use DUPOUT,hear is some code:
data dup(drpo temp_id);
set ds1;
retain temp_id;
if temp_id ne id then
output;
temp_id=id;
| Is This Answer Correct ? | 1 Yes | 3 No |
How do you delete duplicate observations in sas?
In sas, what are the areas that you are most interested in? : sas-grid-administration
How does the internal authentication work in sas? : sas-grid-administration
Name statements that are execution only.
How would you code the criteria to restrict the output to be produced?
explain about data integrator metadata reports? : Sas-di
explain the concepts and capabilities of business object? : Sas-bi
How to import the Zip files into SAS? If it is possible in SAS? If it is posible write the code...
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable?
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??
What is SAS Information Map Studio and its purpose ?
What is Linear Regression?
Teradata 
