can any one explain How to remove tab space when I paste or import data in a excel file
Please refer to this community post and let us know if it is helpful to you. You can also refer to documentation here.
@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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Submit your idea!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.