• Print |
• E-mail  |
• Bookmark

PROC ACCESS and PROC SQL Pass-Through do NOT automatically assign the
long variables names the same.

For example, 6 columns named: verylongvar1, verylongvar2, verylongvar3,
averylong1, averylong2, averylong3.  PROC ACCESS with ASSIGN=YES
will automatically assign the variables: verylong, verylon0, verylon1,
averylon, averylo2, averylo3.  However, PROC SQL assign thems as:
verylong, verylon0, verylon1, averylon, averylo0, averylo1.  PROC ACCESS
continues with the numbering scheme from one group of duplicate names to
another and PROC SQL Pass-Through restart the numbering at 0 for each
group of duplicate names.

To replicate this you MUST have more than one group of duplicate column
names and a few columns in each duplicate group.

The work around would be to use the rename option on the variables so
that the PROC SQL Pass-Through variables and PROC ACCESS variables are
consistent.  With SAS V7/V8, the option VALIDVARNAME=V6 will provide
the same results as V6. However, to have columns match with PROC ACCESS
and PROC SQL you must use the work-around of using RENAME.

Operating System and Release Information