yes

Cog.7 is thick client (the client has to be installed on 
your pc) where as Cog.8 is thin client (no client is 
needed , u can access thru webpage (url), But if the 
interviewer is looking for differnt answer, then say like 
this: Cog.7 is Window Based and Cog.8 is Web Based(except 
framework manager)

go for it, because using java scripts you can develop 
cognos reports which is not even possible by the existing 
GUI.

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.

Make sure you apply the following rules when determining 
which approach to take when subsetting your data set using 
the DATA step. If your subset condition does not meet the 
requirements below, then the WHERE and IF statements should 
produce identical results. For cases such as this, use the 
WHERE statement since it is more efficient. Note that 
having both WHERE and IF statements within the same DATA 
step has a cumulative effect.
•	Can use WHERE statement when only specifying data 
set variables 
•	Use IF statement when specifying automatic 
variables or new variables created within DATA step 
•	Use IF statement when specifying FIRST.BY or LAST. 
BY variables 
•	Use IF statement when specifying data set options 
such as OBS = , POINT = or FIRSTOBS = 
•	In general, use IF statement when merging data sets 
to apply subset condition after merging data set 
•	Use WHERE statement when specifying indexes

WHERE Statement can be only be used with variables in the 
existing dataset where as IF statement can also be used raw 
data as well

Hi Saggy Desai,

I think you can get Genuine SAS Dumps from: sasiexam@gmail.com

Regards
Bharath

1.Refreshing of data is possible in materialised views. we 
can restrict rows of data for acces from other users in 
materialised views.

above mentioned two points are not possible with table.

Thanks
Deepthi