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
- 6265 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?
what is proc Index? and what is proc document?
What areas of SAS are you most interested in?
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma
What are the new features included in the new version of SAS Programming Language?
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?
Which function is used to count the number of intervals between two sas dates?
Give some examples where proc report’s defaults are same as proc print’s defaults?
What is a put statement?
Explain the difference between using drop = data set option in set and data statement?
AE datasets names? how many types?
what is sas and what are the functions? : Sas-administrator
What is SAS informats?
how can you import .csv file in to sas? : Sas programming
How to create a permanent sas data set?
