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

When merging 2 datasets with a common variable (not merge key), how to keep both?

3 Answers  

---

What are the applications primarily used by business analyst? : Sas-bi

0 Answers  

---

There is a field containing a date. It needs to be displayed in the format "ddmonyy" if it's before 1975, "dd mon ccyy" if it's after 1985, and as 'Disco Years' if it's between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT

8 Answers   D&B,

---

Describe the ways in which you can create a macro variable?

0 Answers  

---

In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;

1 Answers  

---

Can you excute a macro within a macro? Describe.

2 Answers   Genta,

---

calculate the sum of value using only DATA STEP. data count_; input year name $ value; cards; 2006 xxx 10 2007 yyy 12 2006 xxx 20 2008 yyy 15 2007 xxx 15 ; out put should be like this year name T_value ----------------------- 2006 xxx 30 2007 xxx 15 2007 yyy 12 2008 xxx 15

6 Answers  

---

Name and describe three SAS functions that you have used, if any?

2 Answers  

---

how would you create multiple observations from a single observation? : Sas programming

0 Answers  

---

How do you read in the variables that you need?

9 Answers   Accenture,

---

what is factor analysis? : Sas-administrator

0 Answers  

---

How would you define the end of a macro? : sas-macro

0 Answers  

---