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
- 4823 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
how do you test for missing values? : Sas programming
what is change analysis in sas di ? : Sas-di
Difference between nodup and nodupkey options?
How is character variable converted into numeric variable and vice versa?
What is Linear Regression?
What are the ways in which macro variables can be created in sas programming?
What is the good sas programming practices for processing large data sets?
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming
What are the implications?
do you need to know if there are any missing values? : Sas programming
What is the difference between SAS functions and procedures?
how many types prompting framework can be broken down to? : Sas-bi
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
for report generation which one you used proc report or data_null_?
