topic can any one explain How to remove tab space when I paste or import data in a excel file in New SAS User

can any one explain How to remove tab space when I paste or import data in a excel file

Ruwan — Tue, 18 Apr 2023 10:02:17 GMT

can any one explain How to remove tab space when I paste or import data in a excel file

Re: can any one explain How to remove tab space when I paste or import data in a excel file

SAS_Cares — Tue, 18 Apr 2023 12:57:17 GMT

Please refer to this community post and let us know if it is helpful to you. You can also refer to documentation here.

Re: can any one explain How to remove tab space when I paste or import data in a excel file

Tom — Tue, 18 Apr 2023 12:56:02 GMT

@Ruwan wrote:

can any one explain How to remove tab space when I paste or import data in a excel file

What editor are you using? With Display Manager I just use the CHANGE command.

If I need something to separate the values I usually use | character.

ch '09'x '|' all

If I just want to treat the text as one long field then I change them to a space instead.

Re: can any one explain How to remove tab space when I paste or import data in a excel file

ballardw — Tue, 18 Apr 2023 14:49:47 GMT

One might ask why you are pasting data into Excel at all and from what source?

Are you copying SAS Results or Output window text? That might be better off sending output directly to Excel files using the ODS Excel when creating the output.