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

how to know the attributes of first five datasets in a library

2 Answers  

---

What do the mod and int function do? : Sas programming

0 Answers  

---

How would you code a merge that will keep only the observations that have matches from both sets?

5 Answers  

---

what is the difference between SET and MERGE?

19 Answers   CitiGroup,

---

name the scheduler for scheduling job and explain the scheduler? : Sas-di

0 Answers  

---

---

1.we can execute a macro with in a macro,by using call symput and symget can any one give me one example? 2.We can create the macro variables by using %let,%do,macro parameters,INTO clause in proc sql and call symput, can any one give me example to create macro variable with INTO clause and call symput? 3.

1 Answers  

---

How to read multiple excel sheets from a single excel file at once????

7 Answers   HCL, Verinon Technology Solutions,

---

Dear all, proc means data=dsn noprint completetypes; class trtmntgroup /preloadfmt; output out=tot n=n; format trtmntgroup trtf. ; by vstgrp descending severity; run; This is the code I used for AE table. I got the values without giving the variable ‘trtmntgroup(numeric)’ in var statement. And if I give the var statement for that variable i’m getting the same values.How is that possible? What is the difference between class and var statement? Could any one explain me how does proc means work at the back end. And what is the difference between _freq_ value and N value in proc means. Thanks and regards, Rajesh.

1 Answers  

---

How would you code the criteria to restrict the output to be produced?

6 Answers   Accenture,

---

Hi, I need to create a SAS Map of USA using SAS Graphs(Proc Gmap).The data i have dosent contain any co-ordinates of USA cities or counties or states, and the zip codes are diffrent in the data i have from the zip code in the Maps.US dataset in the Maps Library for SAS MAPS. the data i have is a sales report. i have to generate the maps according to the states,cities aligned in the sales data, HELP Appriciated

1 Answers  

---

What is the maximum length of the macro variable?

0 Answers  

---

what is ae onset date n what is RDS

0 Answers   Accenture,

---