Answer Posted / g.jyotshna

whenever the data in .txt .dat format we can directly us
infile and input statements.
but incase of .xls
it is not possible to read excel data file directly through
infile input.
we have to use:
wizard
DDE(dynamic data exchange)
proc import (its best one)
(in projects we go for proc import only)
after reading into sas session we will go for cleaning.

Mention the category in which sas informats are placed?

1020

---

What function CATX syntax does?

1225

---

Explain what is the use of proc gplot?

1200

---

Difference between informat and format?

1098

---

explain the proc in sas? : Sas-administrator

1093

---

what is business intelligence? : Sas-bi

1068

---

Give e an example of..

2346

---

Describe the ways in which you can create a macro variable?

1085

---

Given an unsorted data set, how to read the last observation to a new data set?

1356

---

Name any two sas spawners? : sas-grid-administration

1040

---

i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;

2494

---

How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

2129

---

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

1182

---

explain the use of % includes a statement in sas? : Sas-administrator

1008

---

what is broad cast agent? : Sas-bi

1071

---