what do the mod and int function do? What do the pad and dim functions do? : Sas programming
what is data access? : Sas-di
describe about metadata object? : Sas-di
What techniques and/or PROCs do you use for tables?
To what type of programms have you used scratch macros?
how to generate means for every subject;
what is validvarname and varnum? why we are using this options; explain with a syntax for this options?
what is Business Intelligence?
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
how does sas handle missing values in an update? : Sas programming
What is the order of evaluation of the comparison operators: + - * /** ()?
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.
What is Transaction...? And what are Comment, Roll back n Save point..?