topic Re: sas dataset to excel display in SAS Programming

sas dataset to excel display

SASuserlot — Wed, 07 Oct 2020 00:44:35 GMT

I have the variable value as this in my dataset

Randomized,^nControl ,^nCrossr^n safety/efficacy/clinical trial

^n used to in the proc report to read every word after this will display in next line (excapechar=^)

like this need to be displayed in my excel ods shell

Randomized,

control placebo,

cross,

safety/efficacy/clinical trial

But it displaying as

Randomized,

control placebo,

cross,

safety/efficacy/clinical

trial

by the way this is the longest string in the Variable, I have small one before and after it, so assigned the length . any suggestions greatly appreciated

Re: sas dataset to excel display

jimbarbour — Wed, 07 Oct 2020 01:19:28 GMT

Well, an imperfect solution at best, but you could try replacing the space with an underscore. Like this:

safety/efficacy/clinical_trial. You could also try a non display character like '1A'x or '1F'x, but test thoroughly.

Jim

Re: sas dataset to excel display

Reeza — Wed, 07 Oct 2020 04:09:05 GMT

Have you ensured the width of the cell is large enough?

Re: sas dataset to excel display

SASuserlot — Wed, 07 Oct 2020 11:30:25 GMT

I tried increasing the cell width, but no use for some reason.

Re: sas dataset to excel display

SASuserlot — Wed, 07 Oct 2020 16:09:13 GMT

Thanks, for some reason I increased width a lot then it worked now. Did not expected the width is that big compare to other