Interested to Buy Any Domain ? << Click Here >> for more details...
In the SAS Data step what is the difference between the subsetting done by Where and subsetting done by If?
6 19785We 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 6641How can a SAS WEB REPORT STUDIO USER identify which report tabs they have been permitted without entering the SAS WEB REPORT STUDIO
TCS,
2 11128how 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 6406what 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 6689what are the methods that you would employ to fine tune your SQL extract process using SAS/Access or Proc SQL?
1 5160
What is a pdv and what are its functions?
Explain what Proc glm does?
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
How do dates work in SAS data?
In sas admin differentiate between roles and capabilities? : sas-grid-administration
Have you ever used the SAS Debugger?
Compare sas with other data analytics tools.
What is factor analysis?
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
how would you determine the number of missing or nonmissing values in computations? : Sas programming
explain the concepts and capabilities of business object? : Sas-bi
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
How do you use the do loop if you don’t know how many times you should execute the do loop?
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 the good sas programming practices for processing large data sets?
