In this question, I rename the numeric variable phone to
numphone and then try use phone=put(numphone,comma16.) to
store the numeric value numphone as a string value in phone.
But I get a warning tha numphone already exists and in the
data sat phone doesnt exist and numphone is set to missing. Why?
data names_and_more;
input Name $20.
Phone : comma16.
Height & $10.
Mixed & $8.;
Name = tranwrd(Name,' ',' ');
rename phone = numphone;
phone = put(numphone,comma16.);
datalines;
Roger Cody 9,087,821,234 5ft. 10in. 50 1/8
Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2
Marco Polo 8,001,234,567 5Ft. 6in. 40
Brian Watson 5,183,551,766 5ft. 10in 89 3/4
Michael DeMarco 4,452,322,233 6ft. 76 1/3
;
- 1 Answers
- 4422 Views
- I also Faced
- E-Mail Answers
Answer Posted / kumaraswamy maduri
Yes you are right.
The way you coded tells the compiler to do two actions
simultaneosly on the PDV. The renaming will be done once
the data step is closed.
data t;
set names_and_more(rename=(phone=numphone));
phone = put(numphone,comma16.);
run;
In the above example which uses the same data that you
gave, this works the way you wanted. Dataset options work
on the dataset not on the PDV.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
it will become easy if uuu provide website linkssss and list of consultanciessssss
explain the use of % includes a statement in sas? : Sas-administrator
Explain what is data step?
why is sas considered self-documenting? : Sas programming
Difference between sum function and using “+” operator?
I have a dataset concat having variable a b & c. How to rename a b to e & f?
what are sas/access and sas/connect? : Sas programming
what has been your most common programming mistake? : Sas programming
what is the primary data source for the wrs? : Sas-bi
what is sas olap server? : Sas-di
How to test the debugging in sas?
Define run-group processing?
explain the concepts and capabilities of business object? : Sas-bi
What are the parameters of scan function?
how do you want missing values handled? : Sas programming
