Answer Posted / vishnu

xpt and xml files for FDA submissions.

How to specify variables to be processed by the freq procedure?

619

---

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?

2387

---

Explain by-group processing?

591

---

What is the sas data set? : sas-grid-administration

576

---

What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?

2010

---

---

What are the features of SAS?

583

---

I have a dataset concat having a variable a b & c. How to rename a b to e & f?

764

---

what are _numeric_ and _character_ and what do they do? : Sas programming

680

---

What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

687

---

What is the SAS data set?

679

---

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.

1803

---

what does the run statement do? : Sas programming

560

---

describe about metadata object? : Sas-di

630

---

What are the different servers in sas? : sas-grid-administration

605

---

Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?

1216

---