Free SASInstitute A00-280 Exam Dumps Questions & Answers

Which clause allows macro variable creation on a select statement in PROC SQL?

• A.  AS
• B.  SYMPUT
• C.  INTO
• D.  %MACRO

This question will ask you to provide a section of missing code. Given the input SAS data set LABRAW:

Which DO LOOP will create the output SAS data set WORK.LAB_NEW?

• A.  do i=1 to 2;
  visit=i;
  date=dat{i};
  result=num{i};
  end;
  output;
• B.  do i=1 to 2;
  do j=1 to 2;
  visit=i;
  date=dat{j};
  result=num{j};
  end;
  output;
  end;
• C.  do i=1 to 2;
  visit=i;
  date=dat{i};
  result=num{i};
  output;
  end;
• D.  do i=1 to 2; do j=1 to 2; visit=i;
  date=dat{j};
  result=num{j};
  output;
  end;

The following SAS program is submitted:

What is the value of the second variable in the data set WORK.DIGESTL?

• A.  a missing value
• B.  diverticulosis
• C.  No variables are created.
• D.  divertic

A SAS report procedure results in the log below.

What should you add to the PROC REPORT to address the blue note in this log?

• A.  Use DEFINE statements where FLOW is specified for each numeric variable
• B.  Specify COLWIDTH= option with a value large enough to print all values in the data
• C.  Use a FORMAT statement with formats large enough to print all values for each numeric variable
• D.  Use DEFINE statements with the WIDTH= option set large enough to print all values for each variable

Given the data set WORK.BP with the following variable list: Which output will be created by the program?

• A.  Option A
• B.  Option D
• C.  Option C
• D.  Option B