What is difference between rename and lable in sas?
Answers were Sorted based on User's Feedback
Answer / smm
Rename specifies new names for variables in output SAS data
sets
Label assigns descriptive labels to variables
| Is This Answer Correct ? | 34 Yes | 4 No |
Answer / chandra
Rename permanently changes the variable name and where as
lable gives the label to the variable
| Is This Answer Correct ? | 17 Yes | 1 No |
Answer / vishal
Rename will overwrite the values in data portion and lable
displays in descriptor portion just for printing
| Is This Answer Correct ? | 14 Yes | 4 No |
Answer / vinod
Rename allows up to 64 characters only but label allows up
to 256 characters.when we use rename option we can't find
the old name of the variable in the contents procedure,but
in case of label we can see the old name & descriptive
label name of that particular variable.
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / sachin
Rename is modification of previous names into new one
and Lable is which gives more clarification for data.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / srinivas,korasavada
Rename specifies new names for variables in output SAS data
sets and you can give 8 charecters only.
Label specifies new description upto 256 charecters and it
will appear in dataset not in output.
| Is This Answer Correct ? | 8 Yes | 4 No |
Answer / 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 |
Answer / subhashish nanda
Rename is used to change the variable name, while label
option is used to change the dataset name.
For Ex:
data ds1 (rename=(sex=gender sal=income));
infile datalines;
input id name$ sex$ age salary;
datalines;
001 abc m 23 45000
002 def f 34 67000
003 mno m 21 36000
;
run;
data ds2(label=sample);
infile datalines;
input id name$ sex$ age salary;
datalines;
001 abc m 23 45000
002 def f 34 67000
003 mno m 21 36000
;
run;
Here label option changes the dataset name as sample. So
dataset will be as per label i.e. sample, but when we will
open it we will view as ds2.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / kumarravi111
Rename changes the variables name in data set , where as
lable gives descriptive explaining of variable
| Is This Answer Correct ? | 1 Yes | 1 No |
is there any difference between proc summary and proc means?
what are all the default values getting in PROC MEANS...???
How could you generate test data with no input data?
If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
Code the MEANS to produce output to be used later.
Suppose there is a SAS dataset with following values - Parent Child A B B C D E F G G H H I and so on….. This goes onto 1000s of observations/rows. Now how do we identify from this dataset Grandparents and Grandchildrens ?
5 Answers American Express, Barclays,
what is the difference between nodup and nodupkey options? : Sas programming
What is difference between sas rename and lable?
Do you need to rearrange the order of the data for the report?
my problem is to export my report to xsl.i can do that.but the problem is my report has 3 headings first heading should be printed with the merging of (1-5)cells and heading 2 should be of merge(2-4)cells?how to do this condition?
what is the use of sas management console? : Sas-di