Explain different ways to remove duplicate values in SAS.

1.	Explain different ways to remove duplicate values in SAS.
Answer» Below are two ways to delete duplicate values in SAS: The use of nodups in the procedure: The NODUPRECS (or NODUPREC or NODUP) option of PROC SORT identifies observations with identical values for all columns and REMOVES them from the output DATA set. Proc sort data=SAS-Dataset nodups; By varname; run; The use of PROC SQL in the procedure: PROC SQL can be used to remove duplicates. The DISTINCT keyword is used in the SELECT CLAUSE to ACCOUNT for duplicate observations. proc sql; create table New_dataset as select distinct * from Old_dataset where var=distinct(var); quit;

Answer»

Below are two ways to delete duplicate values in SAS:

The use of nodups in the procedure:

The NODUPRECS (or NODUPREC or NODUP) option of PROC SORT identifies observations with identical values for all columns and REMOVES them from the output DATA set.

Proc sort data=SAS-Dataset nodups; By varname; run;

The use of PROC SQL in the procedure:

PROC SQL can be used to remove duplicates. The DISTINCT keyword is used in the SELECT CLAUSE to ACCOUNT for duplicate observations.

proc sql; create table New_dataset as select distinct * from Old_dataset where var=distinct(var); quit;

Discussion

No Comment Found

Related InterviewSolutions

What do you mean by %Include and %Eval?
Explain what is INPUT and INFILE Statement.
Name the command used for sorting in SAS programs?
What do you mean by NODUP and NODUPKEY options and write difference between them?
Explain different ways to remove duplicate values in SAS.
Explain the usage of trailing .
How do you specify the number of iterations and specific conditions within a single do loop?
What is the importance of the Tranwrd function in SAS.
Explain what you mean by SYMGET and SYMPUT.
Identify the error in the following code.