Answer / guest

Dupout option

Answer / vimal

PROC SORT DATA=data_a DUPOUT=dup_data
NODUPKEY
OUT=nodup_data;
BY x;
RUN;

Answer / yam

First sort the data set by the key variable and then

data dup;
set indata1;
if not(first.keyvar) then output dup;
run;

Answer / charan araveti

if u dont want to use DUPOUT,hear is some code:

data dup(drpo temp_id);
set ds1;
retain temp_id;
if temp_id ne id then
output;
temp_id=id;

What is Linear Regression?

0 Answers  

---

here is a string like chq.2312244%4452- from that i want only special characters in a column. dont use compress. bcoz i have 1.2 billion of records.i want another process to find the values instant from the data.

2 Answers   Cap Gemini, L&T,

---

How long can a macro variable be? A token? : sas-macro

0 Answers  

---

Can you continue to write code while the rest of the people on the floor where you work have a noisy party to which you were not invited?

2 Answers   Oracle,

---

What is difference between Global n Local Macro Variables..?

6 Answers   TCS,

---

How to find out no. of business days in a month using macros.???(excluding weekends and holidays).

2 Answers   HSBC,

---

what is the difference between infile and input? : Sas-administrator

0 Answers  

---

How to convert HTML file into SAS dataset?

0 Answers  

---

how to intersect the tables by using PROC MIXED?

1 Answers   CitiGroup,

---

I use NOCUM/NOPERCENT option in the tables statement like this Proc freq data = deepak; tables x y /nocum nopercent; run; Here I get nopercent and nocum in the output only for variables x and y. How do i do it for all variables? Deepak

1 Answers  

---

Do you know the features of sas?

0 Answers  

---

"What is the difference between proc sort nodup and proc sort nodupkey?"

2 Answers  

---