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 are the new features included in the new version of SAS Programming Language?

1149

---

How you can read the variables that you need?

1067

---

Where do you use proc means over proc freq?

1051

---

How substr function works in sas?

1152

---

what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

997

---

Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.

1835

---

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

1326

---

Explain the difference between nodup and nodupkey options?

959

---

for what purpose would you use the retain statement? : Sas programming

1017

---

What are the differences between sum function and using “+” operator?

1031

---

How do you connect the desktop application to metadata server? : sas-grid-administration

1027

---

For what purposes have you used sas macros? : sas-macro

950

---

Do you need to know if there are any missing values?

993

---

What would you change about your job?

2331

---

List down the reasons for choosing sas over other data analytics tools.

1213

---