what is validvarname and varnum? why we are using this
options; explain with a syntax for this options?
- 1 Answers
- 5849 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 |
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
what is the difference between SET and MERGE?
Differences between where and if statement?
How would you delete observations with duplicate keys?
what is function of retain statment
firstobs and obs are working only option wise,but we are using infile statement with firstobs and obs in a statement wise? so firstobs,obs working at options and statemnts or not?
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?
how do you want missing values handled? : Sas programming
What are the rows present in protocol Violation table?
2 Answers Accenture, Quintiles,
what is the main difference between rename and label? (don't say that they both perform the same function).
Does anybody have SAS Training manual or documentation or can you refer me any book to have better understanding on SAS. I am fresher to SAS tool. (Ready to pay)
what is the SAS/ACCESS and SAS/CONNECT?
9 Answers Accenture, iFlex, TCS,
Teradata 
