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’s the difference between var b1 – b3 and var b1 — b3?

1355

---

what are the component of range? : Sas-bi

1081

---

What function CATX syntax does?

1209

---

why is a stop statement needed for the point=option on a set statement? : Sas programming

1076

---

For clinical entire study how many tables will create approx?

1962

---

How do you convert basic cube to transaction cube and transaction cube to basic cube?

2222

---

How will you generate test data with no input data?

1163

---

what are sas/access and sas/connect? : Sas programming

986

---

what is the function of catx syntax? : Sas-administrator

1094

---

how does sas handle missing values in formats? : Sas programming

1130

---

name the scheduler for scheduling job and explain the scheduler? : Sas-di

1042

---

Name and describe few sas character functions that are used for data cleaning in brief.

1114

---

How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

1530

---

what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake

2363

---

how to change the execute of macro

2301

---