The following example shows how the Pass-Through Facility

works with

VALIDVARNAME=UPPERCASE.

options validvarname=uppercase;

proc sql;

connect to oracle as tables(user=USERID orapw=passward

path=’INSTANCE’);

create table lab as

select lab_rslt, lab_test

from connection to oracle

(select "laboratory result$", "laboratory test$"

from DBMStable);

quit;

When we check the Output we observe that the variables in

the DBMS column is changed to upper case as well as V7

(default option) converts those variables into UPPERCASE

variables. Ex: " laboratory result$" becomes LAB_RSLT and "

laboratory test$" becomes LAB_TEST

VARNUM returns the number of a variable's position in a SAS

data set, or 0 if the variable is not in the SAS data set.

This is the same variable number that is next to the

variable in the output from PROC CONTENTS.