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 to extract data from SAP servers? Is like oracle servers or any other methods to extract please reply me.

1 Answers  

---

How will you use the WHO Drug Dictionary for Reporting Clinical Trials?

0 Answers  

---

what other SAS features do you use for error trapping and data validation?

3 Answers   Quintiles,

---

explain the proc in sas? : Sas-administrator

0 Answers  

---

How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

0 Answers   Accenture,

---

How to get part of string form the source string without using sub string function in SAS?

3 Answers  

---

Describe a time when you were really stuck on a problem and how you solved it?

0 Answers   Oracle,

---

In the following DATA step, what is needed for ‘fraction’ to print to the log? data _null_; x=1/3; if x=.3333 then put ‘fraction’; run;

1 Answers  

---

How are numeric and character missing values represented internally?

0 Answers   Quintiles,

---

How would you determine how far down on a page you have printed in order to print out footnotes?

3 Answers  

---

In SAS how to read the variable values having different formats. eg:mar99,mar1999 (in a single variable)

8 Answers   GSK GlaxoSmithKline,

---

What are Dashboard reports?And significance of these in analysis?

1 Answers  

---