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
- 4899 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 |
How to sort in descending order?
How to create an external dataset with sas code?
Are the preferred term counts are always equal to Body system counts? If so, Why are they equal if not why they are not equal?
What is the pound sign used for in the data_null_ ?
Did you used proc test? when?
0 Answers Accenture, Quintiles,
What is proc sort?
Why do we use QUIT commmand for proc datasets and proc sql ???
What statement do you code to write the record to the file?
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
In the following DATA step, what is needed for ‘fraction’ to print to the log? data _null_; x=1/3; if x=.3333 then put ‘fraction’; run;
Did you used proc lifetest? when?
2 Answers Accenture, Parexel, Quintiles,
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
Teradata 
