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 the function of substr in sas? : Sas-administrator

1063

---

What do the SAS log messages "numeric values have been converted to character" mean?

1428

---

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

1280

---

How would you determine the number of missing or nonmissing values in computations?

1128

---

how could you generate test data with no input data? : Sas programming

1235

---

Name few SAS functions?

1143

---

what is null hypothesis? why do you consider that?

2958

---

Explain the main difference between the sas procedures and functions? : Sas-administrator

1112

---

State the difference between INFORMAT and FORMAT ?

1150

---

what are the benefits of data integration? : Sas-di

1174

---

Differentiate between ceil and floor functions.

1197

---

Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2129

---

how to do user inputs and command line arguments in sas?

3086

---

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

4004

---

What is the use of %include statement?

1101

---