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
;
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 |
Mention sas system options to debug sas macros.
Explain the difference between nodup and nodupkey options?
Describe how you would pass data to macro.
How would you include common or reuse to be processed along with your statements?
what is cummaltive frequency,and varience in proc unviarte
How would you invoke a macro? : sas-macro
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
What function CATX syntax does?
What is the purpose of the trailing and How would you use them?
What are types of transport files?
2 Answers PRA Health Sciences, Quintiles,
How do you debug and test your SAS programs?
IS SAS COMPILER OR INTERPRETER? EXPLAIN?
3 Answers Aon Hewitt, HSBC, SCL, TCS,