BookmarkSubscribeRSS Feed
deleted_user
Not applicable
I have a stored process that runs OK in EG, but causes errors in WRS. I've contacted Tech Support, who advise to remove the NOBYLINES statment from my OPTIONS line..... however, if I remove that command, how might I then print reports for variious groups? I've got the #byVAL(mygroup names) in my report header, as well as the BY commands needed.

Is there anohther way to have my report break on each group, with the group name in the report header?

Thanks so much to all who reply!
1 REPLY 1
Cynthia_sas
SAS Super FREQ
Hi,
I'm not sure that the problem is NOBYLINE. I had this sample stored process that works in both Web Report Studio and EG and other client applications:
[pre]
*ProcessBody;
%stpbegin;
options nobyline nodate nonumber;

proc report data=sashelp.shoes nowd;
where region in ('Asia', 'Canada', 'Pacific');
by region;
title 'Report for Region: #byval(region)';
column product sales;
define product /group;
define sales/sum;
rbreak after/ summarize;
compute after;
product = 'Total';
endcomp;
run;
%stpend;

[/pre]

Does your stored process also use PROC REPORT with LINE statements??? It might have been the LINE statement that was causing problems. The SASReport XML that is used by Web Report Studio has issues with PROC REPORT and the LINE statement.

I still think it's an issue for you to work on with Tech Support; however, I also think that you should look for some other code that's breaking in Web Report Studio.

cynthia

SAS INNOVATE 2024

innovate-wordmarks-white-horiz.png

SAS is headed back to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team.

Interested in speaking? Content from our attendees is one of the reasons that makes SAS Innovate such a special event!

Submit your idea!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

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

View all other training opportunities.

Discussion stats
  • 1 reply
  • 616 views
  • 0 likes
  • 2 in conversation