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
- 6340 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 application server? : Sas-di
What are common programming errors committed in sas
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
why a stop statement is needed for the point= option on a set statement?
what is proc Index? and what is proc document?
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
What is a method to debug and test your SAS program?
How do you debug and test your SAS programs?
What does the RUN statement do?
What are the differences between proc means and proc summary?
How would you identify a macro variable? : sas-macro
What is the role of unrestrictive users? : sas-grid-administration
what is the use of proc sql? : Sas programming
How do you connect the desktop application to metadata server? : sas-grid-administration
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
