a*****i 发帖数: 1045 | 1 1. Which of the following will cause PROC SQL to list rows that have no data
in the Address column?
a. WHERE address is missing
b. WHERE address not exists
c. WHERE address is null
d. both a and c
2. What is a SAS library?
a. a collection of SAS files, such as SAS data sets and catalogs
b. in some operating environments, a physical collection of SAS files
c. in some operating environments, a logically related collection of SAS
files
d. all of the above
3. What is the length of the variable Type, as created in the DATA step
below?
data finance.newloan;
set finance.records;
TotLoan+payment;
if code='1' then Type='Fixed';
else Type='Variable';
length type $ 10;
run;
a. 5
b. 8
c. 10
d. it depends on the first value of Type
4. Suppose your program creates a macro variable named libref that contains
the value sales. Another macro variable, named dsname, contains the value
q3y2001. How would you use these macro variables to reference the data set
Sales.Q3y2001?
a. data %libref.%dsname;
b. data &libref..&dsname;
c. data %libref".%dsname";
d. data "&libref."&dsname;
5. Which of the following is false?
a. A %MACRO statement must always be paired with a %MEND statement.
b. A macro definition can include macro variable references, but it
cannot include SAS language statements.
c. Only macro language statements are checked for syntax errors when the
macro is compiled.
d. Compiled macros are stored in a temporary SAS catalog by default.
都是选择题,多谢啦。 | Z********6 发帖数: 10 | 2 You may try testing code or google to find out.
1. Which of the following will cause PROC SQL to list rows that have no data
in the Address column?
a. WHERE address is missing
b. WHERE address not exists
c. WHERE address is null
d. both a and c
Answer: d
3. What is the length of the variable Type, as created in the DATA step
below?
data finance.newloan;
set finance.records;
TotLoan+payment;
if code='1' then Type='Fixed';
else Type='Variable';
length type $ 10;
run;
a. 5
b. 8
c. 10
d. it depends on the first value of Type
Answer is d.
4. Suppose your program creates a macro variable named libref that contains
the value sales. Another macro variable, named dsname, contains the value
q3y2001. How would you use these macro variables to reference the data set
Sales.Q3y2001?
a. data %libref.%dsname;
b. data &libref..&dsname;
c. data %libref".%dsname";
d. data "&libref."&dsname;
Answer is b. |
|