Answer / bitla

ex:

data dup1 dup2;
set original;
by dup_var;
if first.dup_var then output dup1 else output dup2;
run;

Answer / mallikarjuna reddy.vanna

use DUPOUT option in proc sort statement.

Answer / natrajboga

use the dupout= and nodupkey options in proc sort and
followed by BY statemet with list of vars

proc sort data=xxx dupout=dup_xxx nodupkey;
by var1;
run;

/* see the log window */

proc print data=dup_xxx;
run;

Answer / vipin choudhary

Proc sort data = indata;
by name;
run;
Data outdata;
set indata;
by name;
if first.name and last.name then delete;
run;
proc print data = outdata;
run;

or else you can use the dupout option in proc sort

Answer / rajaanku11

First sort them in descending order and then using first.var
separate all the first observations into a new dataset and
the remaining into another. So unique observations from each
group
will come into one dataset and the other duplicate
observations will enter into another dataset.

Answer / rajaanku11

proc sql;
create table dup_obs as (
select * from <lib>.<dsn>
group by <dup var>,<list of other vars>
having count(*)>1 )
quit;

i have a data set with 20 observations i want label from 8 to 15 observations ? how you create this one.

6 Answers   CTS,

if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

0 Answers  

how to write code for left outer join in SAs using datastep?

8 Answers   CitiGroup,

What is the difference between nodup and nodupkey options?

20 Answers   iFlex, Makro, Talwar,

what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

0 Answers  

I have a dataset with variables empid and doj how to calculate retirement age?

1 Answers  

Describe a time when you were really stuck on a problem and how you solved it?

0 Answers   DELL,

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

0 Answers  

what is sas database server? : Sas-di

0 Answers  

i have multiple .csv files in a unix directory. every file is having variable names as header.even for empty file also. suppose take 3 files a.csv b.csv c.csv a.csv contains data as name;age,salary; raja;34;4000; ravi;33;5000; kumar;25;3000; b.csv contains data as name;age,salary; ajay;40;4500; and c.csv contains name;age,salary; (only headers) Now i want to import and append all these files in to a single dataset. i tried infile statement with *.csv to import all at a time. but i m not getting correct data. please help me . its urgent. thank you in advance

2 Answers   Tech Mahindra,

Which is the Best SAS training Institute in Delhi NCR for SAS certification preparation

1 Answers   SAS,

Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma

0 Answers