BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Mathassens
Fluorite | Level 6

Hello,

 

I 'm trying to go to line when i wish with a simple proc report (to display some text at the end of a page in a pdf report).

Could you help me please ?

 

This is my code: what i havewhat i have

what_i_want.png

data notes;
order_row=1;
text="Le graphique ci-dessus met en relation le poids des prestations ( taille des bulles) , le coût moyen par effectif en abscisse et la fréquence en ordonnée pour chaque poste de soins.* Plus la bulle est grande, plus le poids des prestations est élevé.*Plus le coût moyen est élevé, moins la fréquence est élevée (exemple: dentaire).";
output;
run;

 

proc report data=notes noheader nowd split="*"
style(REPORT)={frame=void vjust=middle }
style(COLUMN)={font=(Helvetica) cellwidth=1500 just=center vjust=center foreground=black background=white font_size=10 pt
font_weight=bold just=left bordertopcolor=&couleur_1 borderbottomcolor=&couleur_1 borderrightcolor=&couleur_1 borderleftcolor=&couleur_1};
column order_row text ;
DEFINE order_row / noprint ;
DEFINE text / left ;

run;

1 ACCEPTED SOLUTION

Accepted Solutions
Ksharp
Super User

You can't have circle corner I guess. But you can use ~n to break a line.

data notes;
order_row=1;
text="Le graphique ci-dessus met en relation le poids des prestations ( taille des bulles) , le coût moyen par effectif en abscisse et la fréquence en ordonnée pour chaque poste de soins. ~n  * Plus la bulle est grande, plus le poids des prestations est élevé. ~n *Plus le coût moyen est élevé, moins la fréquence est élevée (exemple: dentaire).";
output;
run;

ods escapechar='~';
ods pdf file='c:\temp\temp.pdf';

proc report data=notes noheader nowd split="*"
style(REPORT)={frame=void vjust=middle }
style(COLUMN)={font=(Helvetica) cellwidth=1500 just=center vjust=center foreground=black background=white font_size=10 pt
font_weight=bold just=left bordertopcolor=&couleur_1 borderbottomcolor=&couleur_1 borderrightcolor=&couleur_1 borderleftcolor=&couleur_1};
column order_row text ;
DEFINE order_row / noprint ;
DEFINE text / left ;

run;
ods pdf close;

Ksharp_0-1708854958025.png

 

View solution in original post

5 REPLIES 5
Mathassens
Fluorite | Level 6

Sorry, i make a mistake when i post my post 😞

In fact, i want to go line after each . in the text

I try to do it whith a split but it's not OK 😞 

sbxkoenk
SAS Super FREQ

As PROC REPORT is not a statistical procedure ... I moved this to "SAS Procedures" - board under Programming header.

sbxkoenk
SAS Super FREQ

Use the data step to do the split.
Then use PROC REPORT (the splitting character in PROC REPORT is for headers).

 

Make dataset notes1 and character text1 and report on these.

data notes1(drop=i cp);
 LENGTH text1 $330;
 set notes;
 cp = countc(text, '.');
 put cp=;
 do i = 1 to cp;
  text1 = scan(text, i, '.');
  output;
 end;
run;

Koen

Ksharp
Super User

You can't have circle corner I guess. But you can use ~n to break a line.

data notes;
order_row=1;
text="Le graphique ci-dessus met en relation le poids des prestations ( taille des bulles) , le coût moyen par effectif en abscisse et la fréquence en ordonnée pour chaque poste de soins. ~n  * Plus la bulle est grande, plus le poids des prestations est élevé. ~n *Plus le coût moyen est élevé, moins la fréquence est élevée (exemple: dentaire).";
output;
run;

ods escapechar='~';
ods pdf file='c:\temp\temp.pdf';

proc report data=notes noheader nowd split="*"
style(REPORT)={frame=void vjust=middle }
style(COLUMN)={font=(Helvetica) cellwidth=1500 just=center vjust=center foreground=black background=white font_size=10 pt
font_weight=bold just=left bordertopcolor=&couleur_1 borderbottomcolor=&couleur_1 borderrightcolor=&couleur_1 borderleftcolor=&couleur_1};
column order_row text ;
DEFINE order_row / noprint ;
DEFINE text / left ;

run;
ods pdf close;

Ksharp_0-1708854958025.png

 

Mathassens
Fluorite | Level 6
Thanks you for yours answers.

SAS Innovate 2025: Call for Content

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!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 892 views
  • 0 likes
  • 3 in conversation