Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> SAS
  2. Suggest New Category

how to delete the duplicates by using proc sql?

Question Posted / ram

Answers were Sorted based on User's Feedback



how to delete the duplicates by using proc sql?..

Answer / shivakrishna.yenaganti

Proc SQL noprint;
create table unique as select distinct (*) from dsn;
quit;

Is This Answer Correct ?    22 Yes 2 No

how to delete the duplicates by using proc sql?..

Answer / arpit

proc sql;
select distinct (*) from sasuser.xyz;
quit.

Is This Answer Correct ?    6 Yes 0 No

how to delete the duplicates by using proc sql?..

Answer / chowdary

In constraints time using unique
In datasets using distinct()

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SAS Interview Questions

How to find out no. of business days in a month using macros.???(excluding weekends and holidays).

2 Answers   HSBC,

how can you create zero observation dataset? : Sas programming

0 Answers  

what is the prob plot in clinical domain

1 Answers   TCS,

what are different type of sas servers ? On which server does the sas code execute ?

4 Answers   TCS,

How do you read in the variables that you need?

9 Answers   Accenture,

what is the difference between the SAS v8 and SAS v9?

7 Answers   TCS,

how could you generate test data with no input data? : Sas programming

0 Answers  

What is proc sort?

0 Answers  

explain what is data set in sas? : Sas-administrator

0 Answers  

What are the Aggregate functions in SQL ?

2 Answers   AON,

what is the effect of the options statement errors=1? : Sas programming

0 Answers  

Can you excute a macro within a macro? Describe.

2 Answers   Genta,

For more SAS Interview Questions Click Here
Categories