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 %local and %global? : sas-macro

1127

---

What are the 3 components in sas programming?

1155

---

Explain the difference between informat and format with an example.

1125

---

explain about sas business intelligence? : Sas-bi

1085

---

Explain how merging helps to combine data sets.

1000

---

what do the pad and dim functions do? : Sas programming

973

---

what is sas olap server? : Sas-di

1207

---

where to use sas business intelligence? : Sas-bi

1016

---

what is function of retain statment

1983

---

Describe the ways in which you can create macro variables?

1123

---

What are the functions used for character handling?

1191

---

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

1131

---

Compare sas with other data analytics tools.

988

---

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

1004

---

What are the difference between the sas data step and sas procs?

1111

---