Hi,
I want to write a code for the following listing using RWI:
Group Name Age Sex
grp1 n1 a1 s1
n2 a2 s2
n3 a3 s3
grp2 n4 a4 s4
n5 a5 s5
I am getting the output, however, the grp variable is repeating for all observations, whereas I want it only for the first observation in the group.
Hi,
Have you tried BY group processing... so that your row for every obs would be something like this:
** row for every obs;
obj.row_start();
if first.byvar then obj.format_cell(data: byvar );
else obj.format_cell(text: " ");
obj.format_cell(data: var2);
obj.format_cell(data: var3);
. . . more code for more variables . . .
obj.format_cell(data: var??);
obj.row_end();
You would need to make sure that the data was in order and you had a BY statement in your DATA step program.
cynthia
Hi,
Have you tried BY group processing... so that your row for every obs would be something like this:
** row for every obs;
obj.row_start();
if first.byvar then obj.format_cell(data: byvar );
else obj.format_cell(text: " ");
obj.format_cell(data: var2);
obj.format_cell(data: var3);
. . . more code for more variables . . .
obj.format_cell(data: var??);
obj.row_end();
You would need to make sure that the data was in order and you had a BY statement in your DATA step program.
cynthia
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.