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
- 6843 Views
- Satyam, I also Faced
- E-Mail Answers
Answer / 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 |
I have a dataset with variables empid and doj how to calculate retirement age?
why a stop statement is needed for the point= option on a set statement?
"What is the difference between proc sort nodup and proc sort nodupkey?"
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
how does sas handle missing values in functions? : Sas programming
Can we use where and having clauses in a single SAS program. ex: proc sql; select a,b,c from test where state in 'KA' and having <some condition>. Is the above program run correctly, if not why ?
Difference between informat and format?
Which is the best training institute for SAS in hyderabad.
112 Answers Stansys Software Solutions,
how are numeric and character missing values represented internally? : Sas programming
what is the primary data source for the wrs? : Sas-bi
How would you include common or reuse code to be processed along with your statements?
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.
Teradata 
