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...


How to write duplicate records into a separate dataset using
sort?

Answers were Sorted based on User's Feedback



How to write duplicate records into a separate dataset using sort?..

Answer / guest

Dupout option

Is This Answer Correct ?    27 Yes 1 No

How to write duplicate records into a separate dataset using sort?..

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

How to write duplicate records into a separate dataset using sort?..

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

How to write duplicate records into a separate dataset using sort?..

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

Post New Answer

More SAS Interview Questions

Are you familiar with special input delimiters How are they used?

3 Answers  


please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??

0 Answers  


Difference b/n proc means and proc summary procedures?

3 Answers   Accenture,


What is the use of divide function?

0 Answers  


what other sas products have you used and consider yourself proficient in using? : Sas programming

0 Answers  


data jagan1.s; input bp$; cards; 100/90 120/89 112/87 run; in the above code how to convert character data values to numeric data values?

3 Answers  


how to import HTML files into SAS datasets?

3 Answers   HP,


What is the difference between SAS Data step and SAS PROC SQL, and which is better?

1 Answers   TCS,


Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya

0 Answers  


Approximately what date is represented by SAS date value of 730

9 Answers  


There are 200 observations in a dataset, i want to pull out the observation no's 100, 150,180,190 by using Proc SQL? How you can get it?

5 Answers  


Describe the ways in which you can create macro variables?

0 Answers  


Categories