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;

What is the difference between proportion and average?

2993

---

how can you put a "trace" in your program? : Sas programming

800

---

Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro

933

---

How does proc sql work?

818

---

If you use a symput in a data step, when and where can you use the macro variable? : sas-macro

817

---

Explain the difference between informat and format with an example.

919

---

Approximately what date is represented by the SAS date value of 730?

966

---

What is data _null_?

888

---

Mention what is SAS data set?

890

---

Difference between nodup and nodupkey options?

855

---

What is the basic structure of the SAS base program?

903

---

How to create a permanent sas data set?

860

---

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

763

---

Mention the difference between ceil and floor functions in sas?

892

---

Name some categories in sas 9? : sas-grid-administration

731

---