SAS Chapter 10: Processing Macro Variables At Execution Time

Information Technology

Programming

Data Analysis

Reviewed by Editorial Team

The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.

Learn about Our Editorial Process

| By Moxleyv

Moxleyv

Community Contributor

Quizzes Created: 38 | Total Attempts: 21,992

| Attempts: 357 | Questions: 10

Quiz Flashcard

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

Question 1 / 10

0 %

0/100

Score 0/100

1. In which of the following situations would you use SYMGET rather than a macro variable reference (&macvar)?

To create a DATA step variable from a macro variable value during the execution of the DATA step

To include a macro variable reference in a PROC SQL view

To access the value of a macro variable during the execution of an SCL program

All of the above

A macro variable reference (&macvar) is resolved before any SAS language statements are sent to the compiler. The SYMGET function enables you to obtain the value of a macro variable during the execution of a DATA step or a PROC SQL step. The SYMGET function can also be used to obtain the value of a macro variable during the execution of an SCL program.

Explanation

Submit

About This Quiz

This quiz, titled 'SAS Chapter 10: Processing Macro Variables at Execution Time,' tests knowledge on macro variable processing in SAS. It covers creating, assigning, and referencing macro variables, and differentiating true statements from false regarding macro processing.

What's your name? Personalize your quiz and earn a certificate with your name on it!

2. Which of the following correctly creates a macro variable in a PROC SQL step?

Call symput(daily_fee, put(fee/days, dollar8.);

%let daily_fee=put(fee/days, dollar8.)

Select fee/days format=dollar8.into :daily_fee from sasuser.all;

Select fee/days format=dollar8.into daily_fee from sasuser.all;

To create a macro variable during the execution of a PROC SQL step, use the INTO clause of the SELECT statement. In the INTO clause, you precede the name of the macro variable with a colon.

Explanation

To create a macro variable during the execution of a PROC SQL step, use the INTO clause of the SELECT statement. In the INTO clause, you precede the name of the macro variable with a colon.

Submit

3. Which of the following statements about the resolution of macro variable references is false?

Two ampersands resolve to one ampersand.

If more than four consecutive ampersands precede a name token, the macro processor generates an error message.

Re-scanning continues until there are no remaining macro triggers that the macro processor can resolve.

The macro processor always re-scans a name token that is preceded by multiple ampersands or by multiple percent signs.

If more than four consecutive ampersands precede a name token, rescanning continues from left to right until no more triggers can be resolved. The Forward Re-scan rule describes how the macro processor resolves macro variable references that start with multiple ampersands or with multiple percent signs.

Explanation

Submit

4. According to the global symbol table shown here, what value will a reference to &&teach&crs resolve to?

&TEACH3

TEACH3

Forest, Mr. Peter

None of the above

You can use multiple ampersands to delay the resolution of a macro variable reference. You can also combine macro variable references in order to create new tokens. In this example, the reference &&teach&crs resolves to &teach3 on the first scan. On the next scan, &teach3 resolves to Forest, Mr. Peter.

Explanation

Submit

5. Which of the following correctly creates a macro variable named region and assigns to it a value that is based on the value of the data set variable Location?

Data new; set sasuser.all; if location='Boston' then do; call symput('region', 'East');... Data new; set sasuser.all; if location='Boston' then do; call symput('region', 'East'); end; else do; call symput('region', 'West'); end;run;

Data new; set sasuser.all; if location='Boston' then do; %let region=East; ... Data new; set sasuser.all; if location='Boston' then do; %let region=East; end; else %let region=West; end;run;

Data new; set sasuser.all; if location='Boston' then do; call symput(region, "East");... Data new; set sasuser.all; if location='Boston' then do; call symput(region, "East"); end; else call symput(region, "West"); end;run;

Data new; set sasuser.all; if location='Boston' then do; symput(region, East); ... Data new; set sasuser.all; if location='Boston' then do; symput(region, East); end; else symput(region, West); end;run;

To create a macro variable and assign to it a value that is based on the value of a DATA step variable, you use the SYMPUT routine. In the SYMPUT routine, to assign a literal string as a macro variable name, you enclose the literal in quotation marks. To assign a literal string as a value of the macro variable, you enclose the literal in quotation marks.

Explanation

Submit

6. Which of the following is false?

A %LET statement causes the macro processor to create a macro variable before the program is compiled.

To create a macro variable that is based on data calculated by the DATA step, you use the SYMPUT function.

Macro functions are always processed during the execution of the DATA step.

Macro variable references in a DATA step are always resolved prior to DATA step execution.

Most macro functions are handled by the macro processor before any SAS language statements in the DATA step are executed. For example, the %LET statement and any macro variable references (&macvar) are passed to the macro processor before the program is compiled. In order to create or update macro variables during DATA step execution, you use the SYMPUT routine.

Explanation

Submit

7. Which of the following is false?

The SYMPUT routine can be used to create a macro variable during execution of the DATA step or during execution... The SYMPUT routine can be used to create a macro variable during execution of the DATA step or during execution of an SCL program.

In the DATA step, the SYMPUT routine automatically converts to a character value any numeric value that you attempt to... In the DATA step, the SYMPUT routine automatically converts to a character value any numeric value that you attempt to assign as the value of a macro variable.

PROC SQL automatically converts to a numeric value any macro variable value that you attempt to compare to a numeric... PROC SQL automatically converts to a numeric value any macro variable value that you attempt to compare to a numeric value.

In an SCL program, the SYMPUTN routine can be used to assign a numeric value to a macro variable.

The SYMPUT routine can be used in either the DATA step or in an SCL program. In the DATA step, the SYMPUT routine will perform automatic conversion on numeric values that you attempt to assign as values for macro variables, using the BEST12. format. In an SCL program, you should use the SYMPUTN routine if you want to assign a numeric value as a value for a macro variable. In a PROC SQL step, you need to use the INPUT function in order to convert macro variable values to numeric before you compare them to other numeric values.

Explanation

Submit

8. The SYMPUT routine cannot

Be used to assign a data set variable as a value to a macro variable.

Create a series of macro variables in one DATA step.

Automatically convert a numeric value to a character value when used to assign a value to a macro variable in... Automatically convert a numeric value to a character value when used to assign a value to a macro variable in a DATA step.

Be used to assign a numeric value to a macro variable in an SCL program.

The SYMPUT routine enables you to assign a data set variable as the value of a macro variable. You can also use the SYMPUT routine to create a series of related macro variables. Because all macro variable values are character strings, SYMPUT automatically converts any numeric value that you attempt to assign as a value for a macro variable. In an SCL program, you must use SYMPUTN rather than SYMPUT if you are attempting to assign a numeric value to a macro variable.

Explanation

Submit

9. Which of the following programs correctly creates a series of macro variables whose names are values of the data set variableCourse_code, then indirectly references one of those macro variables in a later step?

Data _null_; set sasuser.courses; call symput(course_code, trim(course_title));%let crsid=C005;proc print data=sasuser.schedule noobs label; where course_code="&crsid";... Data _null_; set sasuser.courses; call symput(course_code, trim(course_title));%let crsid=C005;proc print data=sasuser.schedule noobs label; where course_code="&crsid"; var location begin_date teacher; title1 "Schedule for &c005";run;

Data _null_; set sasuser.courses; call symput(course_code, trim(course_title));run;%let crsid=C005;proc print data=sasuser.schedule noobs label; where course_code="&crsid";... Data _null_; set sasuser.courses; call symput(course_code, trim(course_title));run;%let crsid=C005;proc print data=sasuser.schedule noobs label; where course_code="&crsid"; var location begin_date teacher; title1 "Schedule for &&&crsid";run;

Data _null_; set sasuser.courses; call symput('course_code', trim(course_title));run;%let crsid=C005;proc print data=sasuser.schedule noobs label; where course_code="&crsid";... Data _null_; set sasuser.courses; call symput('course_code', trim(course_title));run;%let crsid=C005;proc print data=sasuser.schedule noobs label; where course_code="&crsid"; var location begin_date teacher; title1 "Schedule for &&&crsid";run;

Data _null_; set sasuser.courses; call symget(course_code, trim(course_title));run;%let crsid=C005;proc print data=sasuser.schedule noobs label; where course_code="&crsid";... Data _null_; set sasuser.courses; call symget(course_code, trim(course_title));run;%let crsid=C005;proc print data=sasuser.schedule noobs label; where course_code="&crsid"; var location begin_date teacher; title1 "Schedule for &&&crsid";run;

You can use multiple ampersands to create an indirect reference when the value of one macro variable is the name of another. If you enclose the DATA step variable name in quotation marks in the SYMPUT routine, the new macro variable will have the same name as the DATA step variable rather than having the DATA step variable's value as a name. Use the SYMGET function to obtain the value of a macro variable during the execution of a DATA step.

Explanation

Submit

10. Which of the following statements correctly creates a DATA step variable named Price and assigns to it the value of the macro variabledaily_fee during DATA step execution?

Price=&daily_fee;

Price=symget(daily_fee);

Price=symget(&daily_fee);

Price=symget("daily_fee");

You can use the SYMGET function in an assignment statement to obtain the current value of a macro variable and to assign that value to a DATA step variable. The SYMGET function enables you to obtain the value of a macro variable during execution of a DATA step, a PROC SQL step, or an SCL program.

Explanation

Submit

View My Results

Quiz Review Timeline (Updated): Mar 17, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.