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 is a pdv and what are its functions?

789

---

Name validation tools used in SAS

905

---

Explain why double trailing @@ is used in input statement?

795

---

how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

1095

---

Explain what is the use of proc gplot?

911

---

what is study design in while working with SAS? what are screening variables in SAS?

1908

---

What is the sas data set? : sas-grid-administration

759

---

how to read the variables in sas? : Sas-administrator

773

---

Explain what is SAS informats?

825

---

do you need to know if there are any missing values? : Sas programming

764

---

How do you specify the number of iterations and specific condition within a single do loop?

838

---

What is maximum storage capability of SAS?

1088

---

How is character variable converted into numeric variable and vice versa?

873

---

What is the difference between reading data from an external file and reading data from an existing data set?

904

---

what is hash files in sas and why we are using this one in sas?

1935

---