Hi everyone; I'm a SAS rookie. I am using BASE SAS 9.2 and I've run into a problem. I have two mainframe data sets that I am trying read in and manipulate the data via columns. Would anyone know a simple way to use PROC REPORT or another method to manipulate the below data so that it shows the below
First of all, PROC REPORT will not append your two data sets together. For PROC REPORT, it's one data set in and a report comes out. PROC REPORT will not do any "reading in" of multiple data sets. You'll have to do that with a DATA STEP program, PROC APPEND or PROC SQL.
However, what you want after the data sets are together, you could do with either PROC REPORT or PROC TABULATE. If you use PROC REPORT, then your DATE would be an ACROSS usage nested with ALLOC (DATE,ALLOC) and if you use PROC TABULATE, then DATE would be crossed with ALLOC (DATE*ALLOC) in the COLUMN dimension. Whether you use REPORT or TABULATE really depends on what other processing, if any, you need to do on your report. Grand Totals?? Sub Totals??? Calculated items??
A good place to start would be to look at some examples of PROC REPORT and PROC TABULATE in the documentation. There are a lot of examples to learn from. In addition, there have been many, many user group papers and forum postings on the topic of PROC REPORT and PROC TABULATE. Using all of those resources should give you some good code samples and some ideas of whether REPORT or TABULATE is the right choice.