topic Convert variable from character to numeric in New SAS User

Convert variable from character to numeric

sihlek — Fri, 15 Mar 2019 08:50:46 GMT

Hi,

I am trying to convert a variable (External_nbr, this is a column variable with unique numbers of customers) from numeric to text, sas gives me this message:

put(External_nbr, 32);
___
180

ERROR 180-322: Statement is not valid or it is used out of proper order.

Re: Convert variable from character to numeric

KachiM — Fri, 15 Mar 2019 09:11:39 GMT

Perhaps a simple dot after 32 may do the magic. But you have to assign it to a new character variable suitably sized.

Re: Convert variable from character to numeric

Kurt_Bremser — Fri, 15 Mar 2019 11:54:18 GMT

When steps fail, please post the whole log of such a step by using the {i} button (to preserve content, formatting, and positioning).

What you most likely want to do

External_nbr_new = put(External_nbr,32.);

You have to create a new variable, as you can't change the type of an existing variable.

Re: Convert variable from character to numeric

sihlek — Wed, 20 Mar 2019 07:55:51 GMT

Thank you for the help:)

Re: Convert variable from character to numeric

sihlek — Wed, 20 Mar 2019 07:56:21 GMT

Thank you:)