topic Re: Convert characters to numeric and back to characte in SAS Programming

Convert characters to numeric and back to characte

malangba — Wed, 20 Aug 2025 23:33:32 GMT

I have numerical lab results that come in as character values (eg 0.1, 1.5 etc). I wanted to multiply this values by 1000 and keep them as character values.

Re: Convert characters to numeric and back to characte

Tom — Thu, 21 Aug 2025 03:16:05 GMT

Informats convert text to values. Formats convert values to text.

data want;
  set have;
  string = put(1000*input(string,32.),best32.-L);
run;

Change HAVE , STRING and WANT to match the names of the datasets and variable you have.

If STRING is shorter than 32 bytes long then adjust the format specification used with the PUT() function accordingly. You don't need to adjust the informat since the INPUT() function dose not care if the width used in the informat specification is larger than the length of the string being read.

Re: Convert characters to numeric and back to characte

Kurt_Bremser — Thu, 21 Aug 2025 08:44:39 GMT

Why do you want to store numbers in character variables, which makes it harder to use them?

Use numeric variables with a suitable format for display.