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 is the purpose of _error_?

1 Answers   Quintiles,

---

What does PROC print, and PROC contents do?

1 Answers  

---

Do you need to combine data sets? How should you combine data sets– MERGE or SET statements in DATA steps,PROC APPEND,PROC SQL?

3 Answers  

---

I Here clinical SAS training by Ramesh Azmeera is good. Is it confirm ?

2 Answers  

---

How would you delete duplicate observations?

10 Answers   Accenture,

---

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

0 Answers   Pfizer,

---

What does a PROC TRANSPOSE do?

8 Answers   Accenture,

---

What is LOGICAL VARIABLES in SAS.And how it can be used..Can anyone support..???

3 Answers  

---

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

1 Answers  

---

Explain the message 'Merge has one or more datasets with repeats of by variables'.

5 Answers  

---

Explain bmdp procedure?

1 Answers  

---

Tell e how how dealt with..

1 Answers   Wipro,

---