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 would be the value of month at the end of data step execution and how many observations would be there?

583

---

What is the difference between the proc sql and data step?

667

---

What is the length assigned to the target variable by the scan function?

679

---

Mention few capabilities of sas framework.

696

---

for report generation which one you used proc report or data_null_?

6610

---

---

What is factor analysis?

664

---

What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?

2010

---

how many display types available in sas bi dashboard? : Sas-bi

646

---

How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

2387

---

What are the default statistics for means procedure?

650

---

I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry

1329

---

Mention what is the difference between nodupkey and nodup options?

602

---

Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?

1216

---

What is the difference between class statement and by statement in proc means?

663

---

What are symget and symput? : sas-macro

735

---