Answer Posted / solasa

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.

What is the use of divide function?

1067

---

what are the benefits of data integration? : Sas-di

1108

---

what are the types of interactive display types? : Sas-bi

1100

---

what are 5 ways to perform a table lookup in sas? : Sas-administrator

1239

---

how can you put a "trace" in your program? : Sas programming

1067

---

Which date function advances a date, time or datetime value by a given interval?

1155

---

Mention what are the data types does SAS contain?

1153

---

How sas treats the dsd delimiters?

1216

---

where to use sas business intelligence? : Sas-bi

1093

---

what can you learn from the sas log when debugging? : Sas programming

1090

---

What are the default statistics for means procedure?

1246

---

what is snowflake schema? : Sas-di

1215

---

Are you involved in writing the inferential analysis plan? Tables specfications?

2566

---

how are numeric and character missing values represented internally? : Sas programming

1150

---

What are the difference between ceil and floor functions in sas?

1354

---