Working with PROC SQL Views
When
you submit a PROC SQL step, the PROC SQL program code is placed into
the input stack, and word scanning is performed for macro triggers
in the same process as in other SAS programs.
In the following code,
the macro variable reference
&crsid
is
resolved during the creation of the PROC SQL view, resulting in a
constant value whenever the view is used. For example, if the value
of crsid
is C003
when
this code is submitted, the view Subcrsid is based on the course code
C003. proc sql; create view subcrsid as select student_name, student_company,paid from sasuser.all where course_code="&crsid"; quit;
A better approach would be to use the SYMGET function to enable the view to look up the macro variable value. In ...
Get SAS Certification Prep Guide, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.