Interested to Buy Any Domain ? << Click Here >> for more details...
what is validvarname and varnum? why we are using this
options; explain with a syntax for this options?
- 1 Answers
- 6449 Views
- Max India, I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what is sas metadata server? : Sas-di
What is the differnce between SDTM 3.1.2 to 3.1.1 version
what other sas products have you used and consider yourself proficient in using? : Sas programming
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
What are the data types in sas?
Explain what is SAS informats?
Differentiate between sas functions and sas procedures.
what is sas enterprise intelligence architecture? : Sas-bi
Why and when do you use proc sql?
what is sas olap server? : Sas-di
what is operational data and operational system? : Sas-di
how the sas basic syntax style described? : Sas-administrator
How sas treats the dsd delimiters?
what is the Population you used in your project, is it ITT or PP?
Did you used proc test? when?
