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.

Which are the statements whose placement in the data step is critical?

1267

---

data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.

2207

---

what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi

1022

---

What is program data vector (pdv)?

1299

---

What is slibref?

1285

---

How is character variable converted into numeric variable and vice versa?

1182

---

what is sas data set?

1109

---

what is the one statement to set the criteria of data that can be coded in any step? : Sas programming

1158

---

What do the mod and int function do? : Sas programming

1234

---

How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

2129

---

hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana

5453

---

Explain why double trailing @@ is used in input statement?

1069

---

what is enterprise guide? What is the use of it? : Sas programming

1022

---

Difference between informat and format?

1098

---

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2256

---