Question-: 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-: 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-: 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.
Question-: What all is created during the compilation phased?
Answer: During the compilation phase following things are created. - Program Data vector - Two automatic variables in the PDV _N_ and _ERROR_ - The descriptor portions of the new SAS data set is created at the end of the compilation phase. Which include o Name of the Dataset o Number of observations and variables. o Name and attributes of the variables. - Observations are only written after the execution steps.
Thanks for considering SAS A00-215 Certification Preparation Material from http://hadoopexam.com . You can get access to all the 150+ questions and answer for your real exam preparation from below link. Where you would find the same quality of questions and correct answers with the detailed explanation. Below are most popular SAS Certification preparation material and we are continuously updating and adding more questions.
You can check all the available products across the website and have Annual Pro subscription which includes - Trainings - Certification Preparation - Interview Preparation material - Interview Preparation Audio and Video Books - eBooks on various subjects - Project Implementations - Anything newly added during your active subscription also you can get.
Please join this google group to get notified whenever new questions are added JOIN GOOGLE GROUP TO RECEIVE UPDATE NOTIFICATIONS