Answer Posted / khaja

proc import out=<datasetname>
datafile="path\file.xls"
dbms=excel replace;
sheet='sheetno$';
run;

proc export outfile=filepath data=<datasetname> dbms=csv
replace;
run;

What are the scrubbing procedures in sas?

578

---

Mention what is SAS data set?

679

---

Which statement does not perform automatic conversions in comparisons?

1206

---

What is connection profile? : sas-grid-administration

654

---

What are the functions used for character handling?

649

---

---

what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

637

---

Explain translate function?

638

---

What will calendar procedure do?

604

---

Give some examples where proc report’s defaults are same as proc print’s defaults?

649

---

Describe the ways in which you can create macro variables?

641

---

What is the basic syntax style in SAS?

621

---

Name any two sas spawners? : sas-grid-administration

564

---

How do you control the number of observations and/or variables read or written?

753

---

What are the ways to do a “table lookup” in sas?

595

---

Explain the use of proc print and proc contents?

562

---