Question 1:- Which one of the following SAS DATA steps saves the temporary data set named HADOOPDATA as a permanent data set? a) libname sasdata `SAS-data-library`; data sasdata.hadoopdata; copy hadoopdata; run; b) libname sasdata `SAS-data-library`; data sasdata.hadoopdata; keep hadoopdata; run; c) libname sasdata `SAS-data-library`; data sasdata.hadoopdata; save hadoopdata; run; d) libname sasdata `SAS-data-library`;data sasdata.hadoopdata; set hadoopdata; run;
BASE SAS PROGRAMMING
Question 1:- Which one of the following SAS DATA steps saves the temporary data set named HADOOPDATA as a permanent data set?
a) libname sasdata `SAS-data-library`; data sasdata.hadoopdata; copy hadoopdata; run;
b) libname sasdata `SAS-data-library`; data sasdata.hadoopdata; keep hadoopdata; run;
c) libname sasdata `SAS-data-library`; data sasdata.hadoopdata; save hadoopdata; run;
d) libname sasdata `SAS-data-library`;data sasdata.hadoopdata; set hadoopdata; run;
Question 2:- The data set orion.sales contains nine variables. Given this DATA step, how many variables does the descriptor portion of work.comp contain? data work.comp; set orion.sales; drop Gender Salary Birth_Date; run;
a) Four
b) Six
c) Eight
d) Nine
Question 3:- Which one of the following is true when SAS encounters a data error in a DATA step?
a) The DATA step stops executing at the point of the error, and no SAS data set is created.
b) A note is written to the SAS log explaining the error, and the DATA step continues to execute.
c) A note appears in the SAS log that the incorrect data record was saved to a separate SAS file for further examination.
d) The DATA step stops executing at the point of the error, and the resulting DATA set contains observations up to that point.
Question 4:- After executing below SAS program, how many observations would be AV dataset? data AV; merge employee (in=ine) salary(in=ins); by name; run;
a) 6
b) 7
c) 3
d) 8
Question 5:- The following SAS program is submitted: data test; infile `file specification`; input name $ amount@@; run; Which of the following is true?
a) Two @@ together are the same as one c
b) Two @@ hold the data records until the bottom of the DATA step.
c) Two @@ hold the raw data record across iterations of the DATA step.
d) Two @@ are invalid syntax and will cause the program to fail to execute.
Question 6:- Which of the following DATA steps correctly reads the permanent data set salesinfo from the sporting library and creates a new data set named salesinfo2 in the same library?
a) data sporting.salesinfo2; set salesinfo; run;
b) data salesinfo2; set sporting.salesinfo; run;
c) data sporting.salesinfo2; set sporting.salesinfo; run;
d) None of these
Question 7:- In this SAS/ACCESS LIBNAME statement, what does oracle represent? libname sports oracle user=edu001 pw=edu001 path=dbmssrv schema=educ;
a) libref
b) option
c) table name
d) engine name
Question 8:- Which of the following statements are used to read delimited raw data file and create an SAS data set?
a) DATA, SET and INFILE
b) DATA and SET
c) DATA, INFILE and INPUT
d) DATA, SET and INPUT
Question 9:- What does the program shown here create? libname sales excel `c:\mydata\annual.xls`; data sales.qtr1_2011; set sasdata.qtr1_2011; run; data sales.qtr2_2011; set sasdata.qtr2_2011; run;
a) a data set named sales.qtr1_2011 and a data set named sales.qtr2_2011
b) a.an Excel workbook named sales.qtr1_2011 and an Excel workbook named sales.qtr2_2011
c) a.an Excel workbook named annual that contains two worksheets, qtr1_2011 and qtr2_2011
Question 10:- If you submit the following program on above data set, which variables appear in table "Emp"? data emp(drop=Manager_EMP_ID Salary); set emp (keep=Manager_EMP_ID Employee_ID Salary); if Manager_Emp_ID=101 and Salary >45000; Age = yrdif(DOB,`05Feb2017`d,`Actual`d); run;
a) Employee_Id, Gender, Name, Location, Salary, DOB, Manager_Emp_ID
b) Employee_ID, Age
c) Employee_ID
d) Employee_Id, Gender, Name, Location, Salary, DOB, Manager_Emp_ID, Age
Question 11:- When a date value is read from a worksheet, it is converted automatically to a SAS date. Which SAS format is used to display the value?
a) MMDDYY8.
b) MMDDYY10.
c) DATE7.
d) DATE9.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
