Answer Posted / dupe

Data set option :
Data new(keep=age race gender);
set old;
run;

Data set statemnet:
Data new;
set old;
drop age race and gender;
run;

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

1060

---

How to test the debugging in sas?

1187

---

where are dashboard components are created and maintained? : Sas-bi

1024

---

What is the difference between proportion and average?

3345

---

how to read the variables in sas? : Sas-administrator

1028

---

How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

2944

---

What are the features of base sas system?

1078

---

Mention how to limit decimal places for the variable using proc means?

1134

---

Describe the function and untility of the most difficult SAS macro that you have written.

2123

---

Enlist the functions performed by sas.

1136

---

What is your favorite all time computer book? Why?

2520

---

Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?

1926

---

What is the sas data set? : sas-grid-administration

995

---

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.

2208

---

Differentiate between ceil and floor functions.

1170

---