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
- 4900 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 would you determine the number of missing or nonmissing values in computations?
How do you use the do loop if you don’t know how many times you should execute the do loop?
What is the use of the %include statement?
what are validation tools that are used in sas? : Sas-administrator
What are the uses of sas?
Define run-group processing?
Why double trailing @@ is used in input statement?
what is study design in while working with SAS? what are screening variables in SAS?
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
How can you create a macro variable with in data step? : sas-macro
what is the difference between infile and input? : Sas-administrator
What are the different servers in sas? : sas-grid-administration
what are informats in sas? : Sas-administrator
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
How is character variable converted into numeric variable and vice versa?
