Under what circumstances would you code a SELECT construct instead of IF statements?7 11729
What statement do you code to tell SAS that it is to write to an external file? What statement do you code to write the record to the file?2 8564
If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?7 20057
If you’re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?8 17381
What is the one statement to set the criteria of data that can be coded in any step?4 8710
Have you ever linked SAS code? If so, describe the link and any required statements used to either process the code or the step itself.2 8056
How would you include common or reuse code to be processed along with your statements?3 6648
When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?2 6997
If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?10 15700
Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables.7 12914
What are the statements that are executed only?
what is the function of catx syntax? : Sas-administrator
AE datasets names? how many types?
what is the Population you used in your project, is it ITT or PP?
What are the automatic variables for macro? : sas-macro
What is factor analysis?
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 can I remove header from output data set?
Explain the difference between informat and format with an example.
Explain the purpose of retain statement.
what is study design in while working with SAS? what are screening variables in SAS?
What is the basic syntax style in SAS?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
which features do you use to check the data validations and errors? : Sas-administrator
explain the main difference between the nodup and nodupkey options? : Sas-administrator