topic Re: i want data as it is in SAS Programming

Display Data with PROC REPORT and keep leading spaces

thanikondharish — Wed, 15 Aug 2018 15:09:01 GMT

data have ;
length type $ 30 ;
type='benze';
cost=3455454 ;output ;
type=' group1' ;
cost=2542345 ;output ;
type=' group2' ;
cost=452344 ;output ;
run;

ods rtf file='D:\ss\ss.rtf' ;
proc report data=have nowd ;
run;
ods rtf close ;

i create one dataset like above if i proc report like above it give rtf file like see below

type	cost
benze	3455454
group1	2542345
group2	452344

but i want to data has some leading spaces like below

type	cost
benze	3455454
group1	2542345
group2	452344

Re: i want data as it is

ballardw — Wed, 15 Aug 2018 14:17:47 GMT

@thanikondharish wrote:

data have ;
length type $ 30 ;
type='benze';
cost=3455454 ;output ;
type=' group1' ;
cost=2542345 ;output ;
type=' group2' ;
cost=452344 ;output ;
run;

ods rtf file='D:\ss\ss.rtf' ;
proc report data=have nowd ;
run;
ods rtf close ;

i create one dataset like above if i proc report like above it give rtf file like see below

type

cost

benze

3455454

group1

2542345

group2

452344

but i want to data has some leading spaces like below

type

cost

benze

3455454

group1

2542345

group2

452344

You want to add style control as follows:

proc report data=have nowd ;
    define type/ display style=[asis=on];
run;

ASIS=on tells the ODS display to maintain leading spaces.

Re: i want data as it is

thanikondharish — Wed, 15 Aug 2018 14:30:22 GMT

thanq

Re: i want data as it is

Reeza — Wed, 15 Aug 2018 14:39:59 GMT

@thanikondharish please mark the correct solution with the solved button. Thanks!

Re: i want data as it is

Reeza — Wed, 15 Aug 2018 15:08:39 GMT

@thanikondharish please mark the appropriate solution so that any future users who search will see what the correct answer was.