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
- 6230 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
Explain what is SAS informats?
what is sas and what are the functions? : Sas-administrator
How to test the debugging in sas?
What is the SAS data set?
how does sas handle missing values in sort order? : Sas programming
In ARRAY processing, what does the DIM function do?
How necessary is it to be creative in your work?
What is the difference between the proc sql and data step?
How to specify variables to be processed by the freq procedure?
what are all the reports you generated in your recent project?
explain about various caches available in data integrator? : Sas-di
Describe the function and utility of the most difficult SAS macro that you have written?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
Explain by-group processing?
What is a method to debug and test your SAS program?
