Question-151: As soon as execution phase completed two automatic variables _N_ and _ERROR_ also stored with the output Datasets?

Answer: No, these two variables are not stored with the newly created output Datasets.

Question-152: The format to the variable is applied once the variables are added in the PDV during the execution phase?

Answer: No, the formats for each variable are applied before the SAS adds the values to the PDV. Even before each iteration PDV is reset to missing values.

Question-153: Which all variables are not reset in the PDV in each iteration during the execution phase?

Answer:  following variables are not reset to the missing

• variables that are named in a RETAIN statement
• variables that are created in a sum statement
• automatic variables
• Variables that are created with options in a SET or MERGE statement also retain their values from one cycle of execution to the next.

Question-154: How FREQ procedure can be used to determine the errors in the Data?

Answer: You can use the FREQ procedure which detects the invalid character and numeric values by looking values. You can use the FREQ procedure to identify any variables that were not given an expected value.

Question-155: How does procedure means helps in finding the error in the data?

Answer:  Using the MEANS procedure you can generate the summary statistics for a particular value and based on that statistics you can check whether the values are in range or not. Like if you get the max COURSEFEE around 700000 for Hadoop, it means something wrong.  In the data, decimal is missed, actual value should be 7000.00 but that is an example of data entry error.