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 Answers
- 20229 Views
- Cognizant, I also Faced
- E-Mail Answers
Answer Posted / k
There is difference between how SAS handles IF and WHERE
conditions. The 'WHERE' condition is applied on data before
they enter Program Data Vector (PDV) and in case of 'IF' it
is applied after data comes out from PDV. Now, if you have
created a variable in the same data step using
Where : the created variable will not be applied condition.
IF: the created variable will be subjected to the condition
applied.
| Is This Answer Correct ? | 19 Yes | 0 No |
Post New Answer View All Answers
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
what are the types of interactive display types? : Sas-bi
explain the use of % includes a statement in sas? : Sas-administrator
how can you import .csv file in to sas? : Sas programming
what is data integration? : Sas-di
What makes sas stand out to be the best over other data analytics tools?
Which function is used to count the number of intervals between two sas dates?
Describe a time when you were really stuck on a problem and how you solved it?
How do you test for missing values?
How would you define the end of a macro?
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
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 to sort in descending order?
What does P-value signify about the statistical data?
What is the good sas programming practices for processing large data sets?
