what is validvarname and varnum? why we are using this
options; explain with a syntax for this options?
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 |
Where do the database management systems store data and how do u import them.
What are the default statistics that proc means produce?
How will you assign all the variables of an dataset into a macro variable separated by a space? For example if a dataset has variables A,B,C. Assign them to a macro variable X as X=A B C
how can you get the single data set from the library(which has the number of data sets)?
3 Answers Accenture, Deloitte,
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
what are the considerations when picking a SAS/STAT procedure?
0 Answers Accenture, Quintiles,
what is picture format? give any one example?
How do you put a giraffe into the refrigerator?
In proc transpose and data step with arrays which one you pick?
0 Answers Accenture, Quintiles,
in ods is there any lib's
What does a PROC TRANSPOSE do?
what are the different ways of merging two datasets.name atleast 4.