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;

For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

1009

---

Mention common programming errors committed in sas ?

1127

---

what are _numeric_ and _character_ and what do they do? : Sas programming

1156

---

explain about various caches available in data integrator? : Sas-di

1052

---

Mention sas system options to debug sas macros.

1177

---

Why double trailing @@ is used in input statement?

1222

---

Differentiate between format and informat? : sas-grid-administration

1062

---

what are the component of range? : Sas-bi

1100

---

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

1539

---

explain about sas business intelligence? : Sas-bi

1146

---

What are the features of base sas system?

1068

---

What is the difference between where and if statement?

1116

---

what is hierarchy flattening? : Sas-di

1083

---

i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;

2494

---

what is the difference between nodup and nodupkey options? : Sas programming

1192

---