Answer Posted / mohan reddy

NODUP OR NODUPREC OPTION IN PROC SORT STATEMENT.
EX;
PROC SORT DATA=EMP NODUP;
RUN;

NODUPKEY OPTION WILL ALSO DELETE THE DUPLICATE OBSERVATION
VALUES.BUT IT CAN USE THE BY VARIABLE.

EX

PROC SORT DATA=EMP NODUPKEY;
BY ENO;
RUN;

What is the order of application for output data set options, input data set options and SAS statements?

1618

---

What is the length assigned to the target variable by the scan function?

1204

---

What do you know about symput and symget?

1316

---

What do you code to create a macro? : sas-macro

1189

---

what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

1146

---

What is substr function?

1240

---

how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

1402

---

Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

2451

---

How do you add a number to a macro variable? : sas-macro

1050

---

Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com

2086

---

What are the difference between sas functions and procedures?

1203

---

What are the functions used for character handling?

1303

---

what is star schema? : Sas-di

1186

---

Explain how you can debug and test your SAS program?

1051

---

what is function of retain statment

2081

---