BookmarkSubscribeRSS Feed
Ruwan
Calcite | Level 5

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

3 REPLIES 3
SAS_Cares
SAS Employee

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

Tom
Super User Tom
Super User

@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.

ballardw
Super User

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.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Mastering the WHERE Clause in PROC SQL

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.

Discussion stats
  • 3 replies
  • 349 views
  • 0 likes
  • 4 in conversation