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
- 6227 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 |
What is the difference between %local and %global?
What are the functions which are used for character handling functions?
Have you ever linked SAS code, If so, describe the link and any required statements used to either process the code or the step itself?
Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com
Explain translate function?
What are the difference between ceil and floor functions in sas?
What is the basic structure of the SAS base program?
if a program has some 1000 or more line and how to know whether the syntax of the particular code is correct without checking it manually
Have you ever linked SAS code? If so, describe the link and any required statements used to either process the code or the step itself.
what are input dataset and output dataset options? : Sas programming
Which is the best training Institute for SAS Business Intelligence course?
how do we mail reports from SAS environment to our team leader
Teradata 
