topic Re: change format form char $28 to numeric in SAS Programming

change format form char $28 to numeric

sasphd — Thu, 15 Oct 2020 14:26:22 GMT

Hello,

I want to change the format of a variable to numeric

the actual format and informat is $28.

change format

sasphd — Thu, 15 Oct 2020 14:28:42 GMT

Hello,

I want to change the format of a variable to numeric

the actual format and informat is $28.

Re: change format form char $28 to numeric

Kurt_Bremser — Thu, 15 Oct 2020 14:32:20 GMT

To change the type of a variable, you have to create a new one, convert the value with the INPUT function, drop the old variable, and rename the new one to the name of the old.

Re: change format form char $28 to numeric

sasphd — Thu, 15 Oct 2020 14:39:27 GMT

can you please give an example of numeric format

I know that I should write

data want;

set have;

format var ;

informat var;

run;

Re: change format form char $28 to numeric

ballardw — Thu, 15 Oct 2020 14:54:50 GMT

@sasphd wrote:

Hello,

I want to change the format of a variable to numeric

the actual format and informat is $28.

Please provide example values.

If a character variable holds 28 digits it can very well run into issues with computer precision when stored as numeric.

The largest integer values that can be stored reliably in SAS are below, first for Z/OS and second for Windows/UNIX flavors. Note that neither of these comes anywhere near 28 characters even with the commas, which are not part of the value.

72,057,594,037,927,936

9,007,199,254,740,992

Are you going to do arithmetic with the values? If not then they should remain character. If you will then you may have significant issues with computation and precision.

Re: change format form char $28 to numeric

Kurt_Bremser — Thu, 15 Oct 2020 15:07:13 GMT

After 160+ posts here, it should be a breeze for you to write the code from my description.

Do that, and if you run into problems, post example data in usable form, and the complete log you got from the code you tried.

Re: change format form char $28 to numeric

sasphd — Thu, 15 Oct 2020 15:22:00 GMT

data IPO_list0;
set IPO_list0;
Asset_alloc_equity_net1 = input(Asset_alloc_equity_net, 8.);
run;

Re: change format form char $28 to numeric

Kurt_Bremser — Thu, 15 Oct 2020 15:26:02 GMT

And now you add a little code:

data IPO_list0 (
  drop=Asset_alloc_equity_net
  rename=(Asset_alloc_equity_net1=Asset_alloc_equity_net)
);
set IPO_list0;
Asset_alloc_equity_net1 = input(Asset_alloc_equity_net, 8.);
run;

and you have effectively changed the type of the variable.