In the SAS Data step what is the difference between the subsetting done by Where and subsetting done by If?
6 20051We 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 6804How can a SAS WEB REPORT STUDIO USER identify which report tabs they have been permitted without entering the SAS WEB REPORT STUDIO
TCS,
2 11261how 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 6512what 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 6774what are the methods that you would employ to fine tune your SQL extract process using SAS/Access or Proc SQL?
1 5240
do you need to know if there are any missing values? : Sas programming
Explain what Proc glm does?
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
Give e an example of..
What will calendar procedure do?
How sas treats the dsd delimiters?
What is PROC in SAS?
What are the automatic variables for macro? : sas-macro
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
Mention what is SAS data set?
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 sas deals with business intelligence? : Sas-bi
Which command is used to perform sorting in sas program?
what is the effect of the options statement errors=1? : Sas programming
How would you identify a macro variable? : sas-macro