Answer Posted / xxx

PTF is used for connect to External or internal databases
like oracle, EXCEL,ACCESS.advantage of PTF is directly
connected to database means we can directly create,
delete,manipulate modify the tables in the database.

proc sql;
connect to engine_name user_name= password=**** path=' ';
disconnect from Engine_name;
quit;

Describe 5 ways to do a “table lookup” in SAS?

1187

---

Explain the purpose of substr functions in sas programming.

1108

---

How can you limit the variables written to output dataset in data step?

1376

---

hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?

2155

---

Mention the difference between ceil and floor functions in sas?

1208

---

How do you specify the number of iterations and specific condition within a single do loop?

1153

---

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

2175

---

Mention what is the difference between nodupkey and nodup options?

1059

---

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?

2306

---

What can be the size of largest dataset in SAS?

1275

---

What is substr function?

1240

---

what are sas bi dashboard components? : Sas-bi

1228

---

What commands are used in the case of including or excluding any specific variables in the data set?

1145

---

How do you delete duplicate observations in sas?

1113

---

which date functions advances a date time or date/time value by a given interval? : Sas programming

1006

---