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;

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3540

---

Explain the difference between using drop = data set option in set and data statement?

1118

---

Enlist the syntax rules followed in sas statements.

1040

---

Mention what is SAS data set?

1100

---

What is maximum number of rows and cols can be handled in SAS?

1500

---

explain about sas business intelligence? : Sas-bi

1085

---

Mention what is the difference between nodupkey and nodup options?

969

---

Explain why double trailing @@ is used in input statement?

1018

---

what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

1004

---

How substr function works in sas?

1163

---

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

1148

---

Mention the difference between ceil and floor functions in sas?

1109

---

what is the purpose of _error_? : Sas programming

1088

---

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

945

---

Mention common programming errors committed in sas ?

1072

---