Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4840 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
Explain the difference between informat and format with an example.
what is business intelligence? : Sas-bi
Describe a time when you were really stuck on a problem and how you solved it?
how to display duplicated observations in a data using base sas.
13 Answers HCL, TCS,
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
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
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
what is sas metadata server? : Sas-di
who is the best SAS clinical Trainer in Hyderabad?
how do you validate tables abd reports?
2 Answers Accenture, Quintiles,
what does the run statement do? : Sas programming
How can you put a "trace" in your program?
Teradata 
