DATA Step, Macro, Functions and more

Char to Numeric conversion:

Reply
Super Contributor
Posts: 647

Char to Numeric conversion:

data jan2009_v1;
set jan2009(where=(drug_name like 'TRIATE%' or drug_name like 'SEIL%'));
drug_name=upcase(drug_name);
length str $ 7;
if _N_ = 1 then RE = PRXPARSE("/ \d{1,5}\.?\d{0,4}/");
retain RE;
call PRXSUBSTR(RE,drug_name,START,LENGTH);
if START GT 0 then do;
str = SUBSTRN(drug_name,START + 1,LENGTH - 1);
output;
end;
strength=input(str,??best12.); ------------Problem area!!
run;

When I convert the str to numeric, I get missing values.
But i do it in additional data step, i get the right values.
Can we not do in single step?
Trusted Advisor
Posts: 2,113

Re: Char to Numeric conversion:

Read about using the OUTPUT statement. If you include an OUTPUT statement in a DATA step, then the default output at the end of the DATA step is not done.
Super Contributor
Super Contributor
Posts: 3,174

Re: Char to Numeric conversion:

Also, I believe that your SAS log will reveal the variable value for "str" when your DO / END code is *NOT* executed. And you are masking the condition by coding the "??" by the way which hinders your ability to debug your program when executed - not a good idea in my experience.

And so I suggest you use the following SAS "debugging technique" statement in your program at the "end" of the DATA step and possibly adding it in other places (set the "nnn" value to identify your location in the program when invoked):

PUTLOG ">TAGnnn> I am here!" / _all_;

And be sure that you have the maximum amount of SAS Log output generated by your program by coding:

OPTIONS SOURCE SOURCE2;
* OPTIONS MACROGEN SYMBOLGEN MPRINT; /* uncomment as needed */


Scott Barry
SBBWorks, Inc.
Ask a Question
Discussion stats
  • 2 replies
  • 102 views
  • 0 likes
  • 3 in conversation