if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

1005

What is the order of application for output data set options, input data set options and SAS statements?

1506

explain what is data set in sas? : Sas-administrator

915

If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

1111

What would you change about your job?

2332

Why and when do you use proc sql?

1185

How many data types are there in SAS?

1007

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.

2163

What can be the size of largest dataset in SAS?

1174

What is the difference between the proc sql and data step?

1108

How do you control the number of observations and/or variables read or written?

1193

explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di

1005

How can you create a macro variable with in data step? : sas-macro

988

what has been your most common programming mistake? : Sas programming

1033

Can you execute macro within another macro? : sas-macro

938