Answer Posted / chiranjeevi

using variable control options.
keep:It decides the no. of variable should remain within the
dataset.

syntax:keep<variablelist>;
example:
data code;
input name$ no sal;
keep name sal;
datalines;
a 32 3000
b 56 7000
c 12 7890
run;
proc print data=code;
run;

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

983

---

How to limit decimal places for variable using proc means?

1044

---

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.

2163

---

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

2578

---

what is treatment emergent events and treatment emregent adverse event

2325

---

Can you execute macro within another macro? : sas-macro

936

---

how does sas handle missing values in formats? : Sas programming

1077

---

What is the difference between match merge and one to one merge?

1152

---

name some data transformation used in sas di? : Sas-di

911

---

What sas features do you use to check errors and data validation?

1161

---

What can be the size of largest dataset in SAS?

1173

---

How does proc sql work?

1026

---

How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro

989

---

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

2655

---

What is the general format of function in sas? : sas-grid-administration

917

---