topic Re: Convert all character variables to numeric with macro CtoN in New SAS User

Convert all character variables to numeric with macro CtoN

Ramy — Wed, 26 Sep 2018 15:07:12 GMT

I am trying to use the macro

"Convert all character variables to numeric with macro CtoN". from the below link:

http://support.sas.com/kb/60/678.html

However, It is throwing me some error, as following:

WARNING: Apparent symbolic reference NLEV not resolved.
ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand
is required. The condition was: &nlev
ERROR: The %TO value of the %DO I loop is invalid.
ERROR: The macro CTON will stop executing.

Any idea, how could I resolve this problem?

Convert all character variables to numeric with macro CtoN

Ramy — Wed, 26 Sep 2018 15:11:11 GMT

I am trying to use the macro

"Convert all character variables to numeric with macro CtoN". from the below link:

http://support.sas.com/kb/60/678.html

However, It is throwing me some error, as following:

Any idea, how could I resolve this problem?

Re: Convert all character variables to numeric with macro CtoN

ballardw — Wed, 26 Sep 2018 15:29:37 GMT

Please do not post identical questions in different sections of this forum. If the topic needs to be in a different area we will often move it.

Multiple threads mean that you may need to answer the same questions about your data, code and log multiple times. Plus other users searching for a similar topic may not find the thread with the final solution as easily.

Re: Convert all character variables to numeric with macro CtoN

ballardw — Wed, 26 Sep 2018 15:34:23 GMT

Provide example of the data attempted to convert.

When having issues with macros generally you should set the options to display more details in the log.

Before running the macro add this line:

options mprint symbolgen;

which will show the resolved code generated by the macro (which all that macros actually do, create code) and the building of the macro variables used.

The error messages will appear in context better.

Use: options nomprint nosymbolgen; to turn of the added macro resolution.

The cause is almost certainly related to either your data or the options you provided when calling the macro.

You should provide the actual macro call you used as well.

Re: Convert all character variables to numeric with macro CtoN

Kurt_Bremser — Wed, 26 Sep 2018 15:56:22 GMT

I took care of the double-post. Some day @ChrisHemedinger will create the badge "Master Gardener" for me 🙂