Answer Posted / krishna

In base sas
we can data from external data by

data <datasetname>;
infile 'path\file.txt';
run;

by procedure

proc import datafile='path\file.xls' out=<datasetname>
dbms=excel;
sheet='sheetname';
run;

proc import table=tablename out=<datasetname>
dbms=access;
database='path\file.mdb';
run;

what is broad cast agent? : Sas-bi

597

---

What is the use of %include statement?

623

---

how to remove duplicates using proc sql?

632

---

Define run-group processing?

583

---

Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?

1771

---

---

What is program data vector (pdv) and what are its functions?

631

---

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

1685

---

do you prefer proc report or proc tabulate? Why? : Sas programming

576

---

how to debug and test the sas program? : Sas-administrator

574

---

what is the use of proc contents and proc print in sas? : Sas-administrator

607

---

What makes sas stand out to be the best over other data analytics tools?

591

---

what are the benefits of data integration? : Sas-di

540

---

what other sas products have you used and consider yourself proficient in using? : Sas programming

688

---

What are types of transport files?

6873

---

How do dates work in sas?

648

---