Answer / ganesh k

data dset1;
set dset;
by var1;
if last.var1>1 then output;
run;

Answer / suresh babu prattipati

hi,
to display the dups in seperate dataset please find the
below program.

eg:
data dups;
input var1;
1
2
3
4
4
3
5
6
;
run;

/*to find the dups*/


data dups1;
set dups;
by var1;
if not(first.var1 and last.var1) then output;
run;

*now you can see the dups ;

If any one have any sas question please e.mail me to

suresh.sasv9@gmail.com

thanks
suresh

Answer / harish

we can find duplicated by using missover&scanover

What procedure you used to calculate p-value?

2 Answers   Accenture, Quintiles,

---

what is hash files in sas and why we are using this one in sas?

0 Answers   L&T, SAS,

---

Describe what are the different levels of administrative users in sas? : sas-grid-administration

0 Answers  

---

Name statements that function at both compile and execution time?

1 Answers  

---

For what purpose would you use the RETAIN statement?

0 Answers   Quintiles,

---

Compare sas with other data analytics tools.

0 Answers  

---

libname deepak 'C:\SAS Files'; proc format; invalue convert 'A+' = 100 'A' = 96 'A-' = 92 'B+' = 88 'B' = 84 'B-' = 80 'C+' = 76 'C' = 72 'F' = 65; data deepak.grades; input ID $3. Grade convert.; *format Grade convert. ; datalines; 001 A- 002 B+ 003 F 004 C+ 005 A ; proc print data = deepak.grades; run; I get the following output Obs ID Grade 1 001 . 2 002 . 3 003 . 4 004 . 5 005 . I don’t understand why Grade shows up as a missing value. Everything seems fine, including ID $3. Now, in case I use ID : $3. Or use column input, I get the desired output. Kindly help Deepak

7 Answers  

---

What is maximum number of rows and cols can be handled in SAS?

0 Answers   Signetsoft,

---

Name types of category in which SAS Informats are placed?

0 Answers  

---

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

0 Answers  

---

What is the difference between %local and %global?

1 Answers  

---

How do dates work in SAS data?

0 Answers  

---