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.

How necessary is it to be creative in your work?

0 Answers   Oracle,

---

How could you generate test data with no input data?

14 Answers   CTS,

---

Mention what is the difference between nodupkey and nodup options?

0 Answers  

---

What are the parameters of scan function?

0 Answers  

---

Tell e how how dealt with..

0 Answers  

---

what is the function of catx syntax? : Sas-administrator

0 Answers  

---

How do I CREATE an external dataset with sas code? I would like to create within a sascode a non-exsistent textfile on the host. So I am not forced to create the file befor filling it.

2 Answers  

---

Describe the ways in which you can create macro variables? : sas-macro

0 Answers  

---

WHAT IS DEBUGGING? HOW TO TEST THE DEBUGGING IN SAS?

3 Answers   Accenture,

---

How will you generate test data with no input data?

0 Answers  

---

Difference b/n proc means and proc summary procedures?

3 Answers   Accenture,

---

What statement do you code to tell SAS that it is to write to an external file? What statement do you code to write the record to the file?

2 Answers   Accenture,

---