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
- 4896 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 |
Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya
AE datasets names? how many types?
How to convert .xls file into CSV format?
Do you prefer Proc Report or Proc Tabulate? Why?
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
What is SAS? What are the functions does it performs?
What is the difference between one to one merge and match merge? Give an example.
Code the MEANS to produce output to be used later.
how can u import .csv file in to SAS?tell Syntax?
7 Answers CitiGroup, Franklin Templeton,
what do the pad and dim functions do? : Sas programming
what are scrubing procedures in SAS?
What are the table names in oracle database...?
Teradata 
