As an alternative to creating
the recipient list in SAS Web Report Studio, you can create a table
manually in Base SAS. This example illustrates one way to create
a table manually using PROC SQL. After you create the table, you must
import the table into your metadata repository by using the Data Library
Manager in SAS Management Console or other SAS code.
The following example
uses a SAS library named
wrsdist
, a
SAS table named
Burst
, and a group
break variable named
Year
.
libname wrsdist
“\\server\c$\DataSources\SAS\wrsdist”;proc
sql;create table wrsdist.Burst (Year num, EMAIL char(256),
CHANNEL char(256));insert into
wrsdist.Burstvalues (2008,
'email1@orionstarsports.com', 'channelname')values (2009,
'email2@orionstarsports.com', 'channelname')values (2010,
'email3@orionstarsports.com', 'channelname');
quit;
If you create a recipient
list without the column for the group break, then you will distribute
the entire report to all recipients who are specified in the EMAIL
or CHANNEL columns.
You can leave the EMAIL
or CHANNEL cells empty for some or all of the group breaks. When a
row has empty cells, the corresponding group break report is not generated.