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
- 6339 Views
- Max India, I also Faced
- E-Mail Answers
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 |
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
what is factor analysis? : Sas-administrator
what is sas? is a package or tool? give me introduction about sas?
what is prime numbers? how we can get plc write sas code?
How does the internal authentication work in sas? : sas-grid-administration
Intern stastical programmer written test
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
for whom is sas data integration studio designed? : Sas-di
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 is the difference between nodup and nodupkey options? : Sas programming
Tell me more about the parameters in macro? : sas-macro
what are all the ways to define macro variable??
2 Answers GSK GlaxoSmithKline,
Teradata 
