topic Format issue in SAS Enterprise Guide

Format issue

radha1 — Fri, 31 Aug 2018 13:15:57 GMT

Hi,

Can anyone help me converting from 125,804 to 125804.

2.53.476
253476

Thanks in advance

Re: Format issue

Tom — Fri, 31 Aug 2018 13:23:22 GMT

How is that a FORMAT issue?

Where are the existing values? Where do you want the converted values?

Do they have commas or periods in them? Or both?

If you have character variables why not just use COMPRESS()?

data have ;
  input str $20. ;
cards;
125,804 
2.53.476
253476
;

data want ;
 set have ;
 new = compress(str,',.');
run;

Obs      str        new

 1     125,804     125804
 2     2.53.476    253476
 3     253476      253476

Re: Format issue

ballardw — Fri, 31 Aug 2018 15:42:29 GMT

At least provide the current format the variable has and the variable name.

You can get that information from Proc Contents or table properties.

The example values you show indicate that the variable must be character as none of the SAS supplied formats would treat both comma and period as the thousands separator your example implies. So do you want an actual numeric value or a character value without the comma and period?