topic Re: How to convert large amount of numeric variables to character variables? in SAS Programming

How to convert large amount of numeric variables to character variables?

Noleen — Sun, 14 Jun 2015 05:47:24 GMT

Hello,

I have around 800 numeric variables and want to convert them into character variables. If using PUT function, I have to convert them one by one.

Is there any other way to do it? As using PUT 800 times is not very doable

Many thanks!

Re: How to convert large amount of numeric variables to character variables?

Jagadishkatam — Sun, 14 Jun 2015 06:19:27 GMT

Since you have not provided dummy data, here is what i am expecting which you can try . I used arrays

data want;

set have;

array nums(*) num1-num800;

array chars(*) $ char1-char800;

do i = 1 to dim(nums);

chars(i)=put(nums(i),best.);

end;

run;

Thanks,

Jag

Re: How to convert large amount of numeric variables to character variables?

Jagadishkatam — Sun, 14 Jun 2015 06:27:01 GMT

Alternatively also try the do over with arrays

data want;

set have;

array nums num1-num800;

array chars $ char1-char800;

do over nums;

chars=put(nums,best.);

end;

run;

Re: How to convert large amount of numeric variables to character variables?

Noleen — Sun, 14 Jun 2015 10:17:05 GMT

Thanks Jag,

The code works, however, for the numbers less than 1 or including minus, it only gives me '0' or '-'

Is it possible to solve this problem?

Thanks

Noleen

Re: How to convert large amount of numeric variables to character variables?

Jagadishkatam — Sun, 14 Jun 2015 13:09:05 GMT

Please use the put function with best32. format

Re: How to convert large amount of numeric variables to character variables?

Noleen — Mon, 15 Jun 2015 12:26:32 GMT

Hi Jag,

It doesn't work with best32. format.

Char1-char800 is empty after apply best32. format in put function.

I don't know how to attach file in reply. I can send the sample data to your email if you don't mind.

Thanks a lot.

Re: How to convert large amount of numeric variables to character variables?

data_null__ — Mon, 15 Jun 2015 12:44:01 GMT

You need to show your work. AND show some sample data.

Re: How to convert large amount of numeric variables to character variables?

Noleen — Mon, 15 Jun 2015 13:23:08 GMT

Please see the attachment for the sample data.

I used Jag's code.

data want;

set try;

array nums(*) num1-num800;

array chars(*) $ char1-char800;

do i = 1 to dim(nums);

chars(i)=put(nums(i),best.);

end;

run;

It convert the numbers less than 1 or 0 to '0' or missing.

After I change the format to best32.

data want;

set try;

array nums(*) num1-num800;

array chars(*) $ char1-char800;

do i = 1 to dim(nums);

chars(i)=put(nums(i),best32.);

end;

run;

char1-char800 return blank.

There is no error or warning.

Thanks a lot!

Re: How to convert large amount of numeric variables to character variables?

Astounding — Mon, 15 Jun 2015 14:00:48 GMT

Try forcing the lengths of your variables to match the length of your format. For example, to create new variables that are 16 characters long:

array chars (800) $ 16 char1-char800;

Then convert numerics to a 16-character format:

chars(i) = put(nums(i), best16.);

You don't have to pick 16 characters, but you should match the lengths and the formats.

Good luck.

Re: How to convert large amount of numeric variables to character variables?

Noleen — Wed, 17 Jun 2015 07:49:01 GMT

It works!!

Thanks a lot!