Interested to Buy Any Domain ? << Click Here >> for more details...
what 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 Answers
- 6702 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / sushil nayak
1) System options are global instructions that affect the entire SAS session and control the way SAS performs operations. Once you invoke a system option, it remains in effect for all subsequent data and proc steps in a SAS job, unless you specify them. For example .. OPTIONS NODATE PAGESIZE=MAX LINSIZE=MAX NOCENTER; ..search SAS online doc to knw more options.
2)Dataset options are options that you code after dataset name,for example KEEP= DROP= WHERE= FIRSTOBS= OBS=..etc dataset statement are coded anywhere within the data and run statements..for example KEEP DROP WHERE RETAIN ..etc
3)If KEEP= and KEEP statement is coded then KEEP option gets executed 1st and then the statement.
4) The following are some of the differences between the IF and WHERE statement ::
a)IF works on newly created variable within the same DATASTEP(for example, variable created by reading a raw file), but WHERE would not work for newly created variable.
b) IF works on Automatic variable (_n_,first. , last.), but WHERE would not work for the same.
c)WHERE can be applied in PROC and DATASTEPS, but IF can be applied to DATASTEPS only.
d) IF does a char to num conversion or visa-versa while checking a condition (IF NEEDED), but WHERE would no cause ERROR, stating that variable being checked is incompatible variable.
There are other differences, would recommend searching sas online or sas sugi papers to knw more.
5) If a WHERE and IF can be applied with a datastep then WHERE should be choosen, reason being, the WHERE statement is more efficient than IF statement.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
what is sas olap server? : Sas-di
what is the Population you used in your project, is it ITT or PP?
Explain the use of proc gplot? : sas-grid-administration
How would you invoke a macro? : sas-macro
What’s the difference between var b1 – b3 and var b1 — b3?
What is the use of PROC gplot?
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
Give some examples where proc report’s defaults are same as proc print’s defaults?
What is the function of Stop statement in a SAS Program?
What is the good sas programming practices for processing large data sets?
what can you learn from the sas log when debugging? : Sas programming
Mention common programming errors committed in sas ?
How do you test for missing values?
What is the purpose of _character_ and _numeric_?
AE datasets names? how many types?
