Is it possible to concatenate two or more proc reports?        The proc reports look like these -   data have; input brand $ Freq Freq1 perchange; datalines; A 2 3 8 B 3 5 4 C 4 6 2 D 5 1 1 E 6 5 8 F 7 7 9 ; run;   proc report data=have nowd out=abs style(summary)=Header; title 'Proc Report Crosstab Report'; column brand ('Enrollment' Freq Freq1 perChange); define brand / group "Enrollment by Residency"; rbreak after / summarize; run; data have1; input cars $ Freq Freq1 perchange; datalines; A 4 1 9 B 6 0 5 C 8 1 6 D 1 6 8 E 7 4 4 F 6 5 1 ; run; proc report data=have1 nowd out=abs1 style(summary)=Header; title 'Proc Report Crosstab Report'; column cars  ('Enrollment1' Freq Freq1 perChange); define brand / group "Enrollment1 by College"; rbreak after / summarize; run;         So the two Proc reports have out "abs" and "abs1".    My report should output the two reports one after then other in the order and have two blank spaces between them. I have attached a sample report that I would need as an output.     When I use the following code my output is not like the one that I desire (attached with the post)     proc report data=have nowd out=abs style(summary)=Header; title 'Proc Report Crosstab Report'; column brand ('Enrollment' Freq Freq1 perChange); define brand / group "Enrollment by Residency"; rbreak after / ; column brand ('Enrollment1' Freq Freq1 perChange); define brand / group "Enrollment1 by college"; rbreak after /; run;             Can someone please suggest a possible solution.         ... View more

Good day all,   I have a report with me in sas format which needs to be formatted to the sample provided.  The sample report is -    data bike; input bike $ sales engine comp stock; datalines; A 1 1 23 30 B 4 3 21 27 Tot_med 5 4 44 57 C 4 3 27 21 D 5 2 31 36 Tot_sup 6 34 58 57 ;   I want the final report to look like the attached format.     Can someone please suggest and guide how it can be achieved in Proc Report.     Also, if it can be done in any other SAS procedure more easily. Please suggest.     Regards, Rishi  ... View more

Am trying to summarize data based on a condition. I would like to summarize some of the bikes together and the rest together.   The sample data is as below -    data bike; input bike $ sales; datalines; A       1 A       4 B       4 B       4 C01   5 C03   5 C04   5 ; Output desired - summation of sales of all C bikes and summation of rest of the bikes(A+B).  ie. "C" = (C01+C02+C03) and "rest" = (A+B)   bike sales C 15 rest 13   Feel that the desired output can come from a union of two tables, one for all the C bikes and other for the rest of the bikes.   Something like -    proc sql; create table Bi as select * from DATA where bike ^contains "C" union all select bike as "rest", sum(sales) as sales from (select * from DATA where bike contains "C" ) group by bike; quit;   Looking for some guidance. Thank you! ... View more

i am trying to concatenate two data frames that have repeated observations. The two data frames are have1 and have 2  as shown below   data have1; input stu $ Freq16; datalines; A          2 B          3 C         4 D         5 E         6 F          7 Grand 27 A          3 B          4 G         10 Grand 17 ; run;     data have2; input stu $ Freq17; datalines; A         1 B         5 C        7 D        3 E        2 F        1 Grand 19 A       22 B       7 G       1 Grand 30 ; run;   I am trying to merge the two data frames by the "stu" variable by using the following code -    Proc Sql; select a.stu, a.Freq16, b.Freq17 from have1 as a inner join have2 as b on a.stu=b.stu; Quit;   The output that I am getting is    stu      Freq16    Freq17   A             2         1 A              2       22 B              3        5 B              3        7 C              4        7 D             5         3 E              6         2 F              7         1 Grand      27      19 Grand      27      30 A              3         1 A              3        22 B              4         5 B              4         7 G             10       1 Grand      17      19 Grand     17        30   However , my desired output is -    stu      Freq16    Freq17   A              2         1 B              3          5 C              4         7 D              5         3 E              6         2 F              7         1   Grand      27      19 A              3         22 B              4         7 G             10       1 Grand     17        30   Can you please advice the correct Proc SQL step. Or is there a better option with the Data Step .    Thank You!    ... View more

  I have a data set and I need to group the type of member "mem" and get a grand total at the bottom.  When I am trying to limit the number of members to group, i am still getting the grand total for all the members.   data have; input mem $ frequency percent; datalines; M 240 24.0 M 320 32.0 F 120 12.0 M 80 8.0 C 68 6.8 M 42 4.2 C 130 13.0 ; run;         Proc Sql; Create table Game as select mem as Member , count(frequency) as Freq , sum(percent) as Percent from have group by mem having mem in ("C", "F") union Select "Grand tot" as mem ,count(frequency) as Freq ,sum(percent) as Percent from have; Quit;   The output that I am getting is    Obs Member  Freq Percent 1        C            2      19.8 2        F            1       12.0 3     Grand tot  7     100.0   The Grand tot is not giving the value for the selected number of "mem".    I tried by putting the having clause in the second part of the union too, however I did not achive results.    Please suggest a viable option.     Thanking you! ... View more