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 factor analysis?

0 Answers  

---

Hi, If anyone has base SAS certification dumps, please share.

0 Answers  

---

what is Global Symbol table and Local symbol table?

4 Answers   CitiGroup,

---

what is prime numbers? how we can get plc write sas code?

5 Answers   Icon,

---

how to remove the duplicates by proc sql?

2 Answers   Genpact,

---

Name the option to produce a frequency line items rather that a table.

2 Answers  

---

is it possible to generate sas datasets using proc print ???

1 Answers   GSK GlaxoSmithKline,

---

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data set to a second data set, and the non-matches of the right-most data set to a third data set.

10 Answers   Accenture,

---

HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES? WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL?

3 Answers   Accenture, Novartis,

---

how sas deals with business intelligence? : Sas-bi

0 Answers  

---

how many types of prompts are there? : Sas-bi

0 Answers  

---

What was the last computer book you purchased? Why?

0 Answers   Oracle,

---