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
- 6458 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 are the considerations when picking a SAS/STAT procedure?
Differentiate between format and informat? : sas-grid-administration
Tell e how how dealt with..
How do you control the number of observations and/or variables read or written?
Describe the function and utility of the most difficult SAS macro that you have written?
Give some examples where proc report’s defaults are same as proc print’s defaults?
What is interleaving in SAS?
what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi
How would you include common or reuse to be processed along with your statements?
Give some examples where proc report’s defaults are different than proc print’s defaults?
Explain what is data step?
What are pdv and it functions?
Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
What are the prime responsibilities of data integration administrator? : Sas-di
