Question-: In the DATA Step what is the implicit Output and explicit output?
Answer: As we know SAS Data step runs in a loop, hence, at the end of each iteration there is an implicit output statement which writes data to the Dataset which is generated in the current data step. If we explicitly put output statement in the Data step it means then it overrides the automatic output and SAS adds observation to a data set only when an explicit OUTPUT statement is executed. Once you use an OUTPUT statement to write an observation to any one data set, however, there is no implicit OUTPUT statement at the end of DATA step. We can use the OUTPUT statement alone as part of an IF-THEN or SELECT or DO-LOOP processing.
Question-: When and where the OUTPUT statement writes the observation?
Answer: SAS DATA step output statement tells the SAS to write current observation to a SAS data set immediately, not the end of the DATA step. If you are not providing any name of the DATA set then output statement would write data in the data sets which is listed in the DATA statement.
Question-: What delimited file by default read by the IMPORT proc?
Answer: By default, IMPORT proc reads delimited files as varying record length files.
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
Question-: While importing fixed length file how to use IMPORT proc?
Answer: If your external file has fixed length format, then use the OPTIONS statement before the PROC IMPORT statement that includes the RECFM=F and LRECL=options.