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

0 Answers  

---

How do you add a prefix to some or all variables in a dataset using a SAS macro?

2 Answers  

---

Why is a STOP statement needed for the point=option on a SET statement?

2 Answers   Quintiles,

---

what other SAS features do you use for error trapping and data validation?

3 Answers   Quintiles,

---

What commands are used in the case of including or excluding any specific variables in the data set?

0 Answers  

---

Explain the special input delimiters used in sas programming.

0 Answers  

---

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.

1 Answers  

---

what is null hypothesis? why do you consider that?

0 Answers   Accenture, Quintiles,

---

How necessary is it to be creative in your work?

0 Answers   Oracle,

---

hi guys ...i have one query... data abc; input s w k g o t a m; cards; 1 2 3 4 5 6 7 8 2 3 4 5 6 7 8 9 ; run; i want the output to be the sorted order(only variables).observations should not be changed..

14 Answers  

---

how to perform paired t-test using Base/SAS & SAS/Stat?

2 Answers  

---

Explain append procedure?

0 Answers  

---