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;

Give an example where SAS fails to convert character value to numeric value automatically?

1025

---

What are the differences between sum function and using “+” operator?

1028

---

How would you invoke a macro? : sas-macro

1035

---

what is sas data set?

1055

---

How to specify variables to be processed by the freq procedure?

1022

---

Enlist the functions performed by sas.

1070

---

What do the PUT and INPUT functions do?

1266

---

Explain bmdp procedure?

983

---

what is sas application server? : Sas-di

995

---

Which statement does not perform automatic conversions in comparisons?

1698

---

Did you used proc test? when?

1977

---

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

2576

---

what is data integration? : Sas-di

1061

---

do you need to know if there are any missing values? : Sas programming

985

---

What is PROC in SAS?

992

---