Date:         Wed, 21 Feb 2001 19:22:10 -0500
Reply-To:     Jacinto F Mendoza <leon_mendoza@JUNO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jacinto F Mendoza <leon_mendoza@JUNO.COM>
Subject:      PROC REPORT (or PROC SQL)
Content-Type: text/plain; charset=us-ascii

I'm having trouble grouping observations per row in PROC REPORT.  In
fact, this is exactly the report I want:

total # of months        employed 19-24        employed 7-18
employed 0-6
-----------------        ----------------        ----------------
---------------
worked 1-4 months        43                                9
           3
worked 5-8 months        35                                35
          33
worked 9-12 months      53                                21
         22

There are four variables (tot_mon, emp_1924, emp_718, and emp_06) and I
also created a count variable (created in my data step as count=1;).  I
first utilize proc sql to create the table and proc report for a more
aesthetically pleasing table.  However, I haven't utilize these procs for
the past 6 months and I forgot the syntax.  Below is what I have to
attempt to produce the tables, but it's not working:

proc sql;
        create table jackson as
        select tot_mon, count,
                emp_1924,
                emp_718,
                emp_06
        from labour5
        group by tot_mon
        order by tot_mon;
        select * from jackson;

proc report data=jackson nowd colwidth=10 spacing=5 headline headskip;
        column tot_mon count emp_1924 emp_718 emp_06;
        define tot_mon / group order;
        define count / analysis sum;
        define emp_1924 / analysis sum;
        define emp_718 / analysis sum;
        define emp_06 / analysis sum;

        break after tot_mon / ol summarize suppress skip;

I know these two procs are rudimentary, but I've also lost all my
programs that refer to these procs.  Any ideas would be appreciated
thanks!-jfm