Answer / mohan reddy

proc sort data=work.abc nodupkey;
by eno;
run;

when u have delete duplicatie obervation from dataset. u can
use the nodupkey along with the by variable.

Answer / g.jyotshna

proc sort data=datasetname nodup;
by var;
run;
proc sort data=datasetname nodupkey;
by var;
run;
proc sort data=datasetname noduprecs;
by var;
run;

Answer / rohit

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

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

Answer / vijay

proc sort nodupkey;by var;run;

Answer / upendra

Data <datasetname>;
Set <datasetname>;
by <var>;
If last.var;
run;

Answer / siddu

proc sort data=<master dataset> out=(newdata set name>
nodup key;
by <key variable>;
run;

how can u join the two tables without using proc sql Joins and nested queries ?

6 Answers   IBM,

What are Dashboard reports?And significance of these in analysis?

1 Answers  

How would you identify a macro variable?

0 Answers  

What is the use of PROC gplot?

0 Answers  

what are sas/access and sas/connect? : Sas programming

0 Answers  

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

0 Answers   Axis Bank,

How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?

0 Answers   Quintiles,

If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable?

2 Answers  

how to generate the test data in sas without input data? : Sas-administrator

0 Answers  

You have a data set of 100 observations,how can you restrict the output so that the output has only data from row no. 10 to row no. 20

9 Answers  

What Proc glm does?

0 Answers  

What is the registered Key word is sas????

2 Answers   TCS,