What do the put and input function do?

0 Answers  

---

How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

0 Answers  

---

What are the difference between ceil and floor functions in sas?

0 Answers  

---

Where do the database management systems store data and how do u import them.

2 Answers   L&T,

---

How would you code the criteria to restrict the output to be produced?

6 Answers   Accenture,

---

Best trainer in hyderabad for sas banking.if any one have details pls provide contact details.

1 Answers  

---

I have 2 data sets A & B. Both have a variable called Age in them, each of them specifying a different functionality. In my program I use bot these data sets. How do I specify which Age variable I want to use?

6 Answers  

---

If you?re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?

1 Answers  

---

data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.

0 Answers  

---

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

0 Answers  

---

What is Tabulate.?Why we use it.? Which type of output we get from Tabulate.?

3 Answers   TCS,

---

in ods is there any lib's

2 Answers   SAS,

---