Answer Posted / majid

data test1;
input id1 $ id2 $ extra ;
cards;
aa ab 3
aa ab 1
aa ab 2
aa ab 3
;
proc sort nodup data=test1;
by id1 ;
run;
proc print data=test1;
run;
output will be like this:

Obs id1 id2 extra

1 aa ab 3
2 aa ab 1
3 aa ab 2
4 aa ab 3

*nodup" is an alias for "noduprecs" which appears to
mean "no duplicate records" but there is no way sas can
know about these duplicate records unless they, by chance,
land next to each other in sequence It is a big mistake
to think sorting "nodup" will remove duplicate records.
Sometime it will, sometime it won't. The only way you can
be sure of removing duplicate records is to "proc sort
nodupkey" and include enough key variables to be sure you
will lose the duplicates you want to lose. In the case
shown above, then if we knew of the same "extra" values
being duplicates we wanted to remove then this variable
should be included in the list of sort variables and
then "nodupkey" will remove the duplicates as shown below.
;
proc sort nodup data=test1;
by id1 id2 extra;
run;

proc print data=test1;
run;
output will be like this:

Obs id1 id2 extra

1 aa ab 1
2 aa ab 2
3 aa ab 3

so as u can see nodup eliminated all duplicate observations
if you sort them by all variables but nodupkey will show
only the duplicate observation.

proc sort nodupkey data=test1;
by id1 ;
run;
options nocenter;
proc print data=test1;
run;
output will be like this:

Obs id1 id2 extra

1 aa ab 3

What is the difference between order and group variable in proc report?

1486

---

How we can call macros with in data step? : sas-macro

1177

---

Mention the validation tools used in SAS?

1231

---

If you were told to create many records from one record, show how you would do this using array and with proc transpose?

1546

---

How substr function works in sas?

1272

---

Describe a time when you were really stuck on a problem and how you solved it?

2606

---

what is the one statement to set the criteria of data that can be coded in any step? : Sas programming

1192

---

what are several options for creating reports in web report studio? : Sas-bi

1229

---

what are informats in sas? : Sas-administrator

1152

---

What are the statements that are executed only?

1212

---

Describe crosslist option in tables statement?

1269

---

Tell me more about the parameters in macro? : sas-macro

1095

---

What does P-value signify about the statistical data?

1403

---

In SAS explain which statement does not perform automatic conversions in comparisons?

1373

---

what can you learn from the sas log when debugging? : Sas programming

1144

---