Answer Posted / mohan reddy

proc sort data=work.abc nodupkey;
by eno;
run;

when u have delete duplicatie obervation from dataset. u can
use the nodupkey along with the by variable.

What’s the difference between var b1 – b3 and var b1 — b3?

1440

---

please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??

2138

---

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

1265

---

I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com

2773

---

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

1208

---

How can you create a macro variable with in data step? : sas-macro

1090

---

how can you create zero observation dataset? : Sas programming

1202

---

name several ways to achieve efficiency in your program? : Sas programming

1142

---

I have a dataset concat having variable a b & c. How to rename a b to e & f?

1079

---

Have you used macros? For what purpose you have used? : sas-macro

1087

---

What is the difference between reading data from an external file and reading data from an existing data set?

1232

---

what are the considerations when picking a SAS/STAT procedure?

3419

---

data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.

2247

---

Explain what is SAS informats?

1132

---

how does sas handle missing values in a merge? : Sas programming

1100

---