Answer / 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 are the methods that you would employ to fine tune your SQL extract process using SAS/Access or Proc SQL?

1 Answers  

---

what is AE onset date and what is RDS?

4 Answers   Accenture,

---

Does SAS ‘Translate’ (compile) or does it ‘Interpret’? Explain.

4 Answers   Accenture,

---

Do you prefer Proc Report or Proc Tabulate? Why?

9 Answers   Oracle,

---

What are the prime responsibilities of data integration administrator? : Sas-di

0 Answers  

---

How would you delete observations with duplicate keys?

6 Answers  

---

How to convert a given date value into SAS date

9 Answers   CitiGroup, Quintiles,

---

wat is sas? is a package or programming language?

4 Answers  

---

do you prefer proc report or proc tabulate? Why? : Sas programming

0 Answers  

---

what is the formula to measure Baseline

3 Answers   Sristek,

---

What is factor analysis?

0 Answers  

---

How do you control the number of observations and/or variables read or written?

0 Answers  

---