What is difference between rename and lable in sas?
Answer Posted / gopi
1) rename can be used as statement or dataset option to
change the name of variable.
2) label, if used as a statement it changes or assigns label
to a variable and if used as a dataset option it changes or
assigns label to the dataset.
Reaname:
a) If you use rename data set option for input dataset, then
SAS renames the variable name in Input dataset.
Data new;
x=1;
y=2;
run;
Data ren ;
set new(rename=(x=z));
run;
This will create ren dataset with z and y variables, and you
can use z varible in the same data step if you want to do
any calculations.
b) If you use rename data set option for output dataset,
then SAS renames the variable in output dataset.
Data new;
x=1;
y=2;
run;
Data ren (rename=(x=z));
set new;
run;
This will create ren dataset with z and y variables, and you
can not use z varible in the same data step if you want to
do any calculations.
3)You can use Rename as statement also, in which case it
effects only output dataset. i.e you can not use the renamed
variable in same data step in calculations
Label:
a) If you use label statement in data step, it assigns or
changes the label name for a variable permanently.
b) If you use label statement in proc step, it assigns or
changes the lable name for a variable temporarily for that
proc step.
c) If you use label as dataset option it assigns label to
the dataset, but not the variable.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What are the prime responsibilities of data integration administrator? : Sas-di
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??
What are the functions used for character handling?
What are the scrubbing procedures in sas?
Explain proc sort?
what are some differences between proc summary and proc means? : Sas programming
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
What are the implications?
what versions of sas have you used (on which platforms)? : Sas programming
Intern stastical programmer written test
Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya
What is the basic structure of the SAS base program?
What is factor analysis?
which features do you use to check the data validations and errors? : Sas-administrator