You can also use a Proc SQL statement with a Distinct keyword. Proc Sq

How would you delete observations with duplicate keys?

Question Posted / rohit

Answer Posted / rohit

You can also use a Proc SQL statement with a Distinct
keyword.

Proc Sql;
Select Distinct tablename.* from tablename;
Quit;

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is sas olap server? : Sas-di

1247

What are the implications?

1700

I need level 2 to 5 sas using companies in india

2375

Enlist the functions performed by sas.

1114

Name few SAS functions?

1088

what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming

1264

what is sas application server? : Sas-di

1064

What would you change about your job?

2383

how to read the variables in sas? : Sas-administrator

1011

What do you know about sas and what we do? : sas-grid-administration

1135

What do the mod and int function do? : Sas programming

1208

What is a method to debug and test your SAS program?

1347

If you use a symput in a data step, when and where can you use the macro variable? : sas-macro

1070

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2069

what are the categories that sas informats are used to the place the data? : Sas-administrator

1036