Answer Posted / krishna

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

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

What is slibref?

1221

---

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

1127

---

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

2196

---

How to limit decimal places for variable using proc means?

1061

---

What is the general format of function in sas? : sas-grid-administration

932

---

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

1120

---

how does sas handle missing values in sort order? : Sas programming

881

---

what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

1092

---

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

2188

---

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

1064

---

What is the use of %include statement?

1011

---

What are the difficulties u faced while doing vital signs table or dataset?

2353

---

what is the purpose of _error_? : Sas programming

1090

---

Have you used macros? For what purpose you have used? : sas-macro

1010

---

How would you define the end of a macro?

1056

---