In the SAS Data step what is the difference between the subsetting done by Where and subsetting done by If?
6 18914We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge the data according to age in file B
3 6156How can a SAS WEB REPORT STUDIO USER identify which report tabs they have been permitted without entering the SAS WEB REPORT STUDIO
TCS,
2 10720how does sas know on which server the piece of code to be executed ? say if a proc olap code is written then how the sas application would detect on which server to execute.
TCS,
1 6024what are system option ? give few examples ? what are dataset options and dataset statements ? if there is a keep option and keep statement ? which one is executed first ? Difference between a WHERE statement and IF statement ? what is the advantage of using WHERE statement option on the dataset ?
1 6333what are the methods that you would employ to fine tune your SQL extract process using SAS/Access or Proc SQL?
1 4892
Which function is used to count the number of intervals between two sas dates?
what are sas bi dashboard components? : Sas-bi
What are the special input delimiters used in SAS?
What is the use of PROC gplot?
what is business intelligence? : Sas-bi
what is sas database server? : Sas-di
What is the order of application for output data set options, input data set options and SAS statements?
what is sas enterprise intelligence architecture? : Sas-bi
what are the scrubbing procedures in sas? : Sas programming
If you could design your ideal job, what would it look like?
How many data types are there in SAS?
what is metadata? : Sas-bi
what versions of sas have you used (on which platforms)? : Sas programming
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
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.
