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 the difference between class statement and by statement in proc means?

1281

---

What is the difference between match merge and one to one merge?

1241

---

What is by-group processing?

991

---

Name some categories in sas 9? : sas-grid-administration

967

---

What would be the value of month at the end of data step execution and how many observations would be there?

1137

---

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

1037

---

What is the SAS data set?

1125

---

What are the differences between proc means and proc summary?

1129

---

what is sas data set?

1096

---

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

1046

---

what are the component of range? : Sas-bi

1081

---

How to limit decimal places for the variable using proc means?

1053

---

How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?

1358

---

How does the internal authentication work in sas? : sas-grid-administration

1113

---

What do the SAS log messages "numeric values have been converted to character" mean?

1371

---