Answer Posted / paul

step#1:Import excel file into SAS
proc import datafile='file location/filename.xls'
out=datasetname dbms=excel replace;
sheet='sheetname$';
getnames=yes;
run;
step#2: Export file to csv file.
data _null_;
set datasetname;
file 'location/file1.csv';
put <var list> ;
run;

Explain input and put function?

1146

---

Which function is used to count the number of intervals between two sas dates?

1133

---

Describe 5 ways to do a “table lookup” in SAS?

1154

---

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.

2207

---

What are the new features included in the new version of SAS Programming Language?

1213

---

To what type of programms have you used scratch macros?

2572

---

Are you involved in writing the inferential analysis plan? Tables specfications?

2567

---

What are the different versions of sas that you have used until now? : sas-grid-administration

1342

---

what do you mean by data staging area? : Sas-di

1143

---

how do you test for missing values? : Sas programming

1060

---

What is the maximum length of the macro variable? : sas-macro

1096

---

What would you change about your job?

2390

---

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

2553

---

For what purposes have you used sas macros? : sas-macro

1001

---

What do you know about symput and symget?

1254

---