Insert a "-" after 2 numbers

[Nikster]

Hi,

I want to enter a "-" after 2 numbers in a column for all numbers.

Examples: All numbers in the column are like 1234567, and I want to add "-" after 2 numbers to look like 12-34567

Please help.

Thanks

[PaigeMiller]

Is your 1234567 a numeric or a character variable? 

[Nikster]

Numeric

[Astounding]

Use a picture format:

proc format;
picture dash 1000000 - 9999999 = '12-34567';
run;

Then print the variable using the format:

format varname dash. ;

[Nikster]

I have a column with multiple numbers like -

12-34567

78-465697

102-589865

78-56546

I just to remove the dash ('-") between the numbers, so it another column (calculated) looks like -

1234567

78465697

102589865

7856546

Cheers

[PGStats]

Use the compress() function.