How to specify variables to be processed by the freq procedure?
No Answer is Posted For this Question
Be the First to Post Answer
What do the put and input function do?
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?
What are the difference between ceil and floor functions in sas?
Where do the database management systems store data and how do u import them.
How would you code the criteria to restrict the output to be produced?
Best trainer in hyderabad for sas banking.if any one have details pls provide contact details.
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?
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?
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.
explain about various caches available in data integrator? : Sas-di
What is Tabulate.?Why we use it.? Which type of output we get from Tabulate.?
in ods is there any lib's