topic Re: Insert a "-" after 2 numbers in SAS Enterprise Guide

Insert a "-" after 2 numbers

Nikster — Tue, 30 Jul 2019 00:03:14 GMT

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

Re: Insert a "-" after 2 numbers

PaigeMiller — Tue, 30 Jul 2019 00:38:02 GMT

Is your 1234567 a numeric or a character variable?

Re: Insert a "-" after 2 numbers

Nikster — Tue, 30 Jul 2019 00:43:28 GMT

Numeric

Re: Insert a "-" after 2 numbers

Astounding — Tue, 30 Jul 2019 01:36:22 GMT

Use a picture format:

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

Then print the variable using the format:

format varname dash. ;

Re: Insert a "-" after 2 numbers

Nikster — Tue, 30 Jul 2019 02:14:55 GMT

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

Re: Insert a "-" after 2 numbers

PGStats — Tue, 30 Jul 2019 03:03:03 GMT

Use the compress() function.