Programming Resources

Using character variables as ACROSS in REPORT procedure

How to use a character variable as an ACROSS variable while using PROC REPORT.

It is possible to use character variables (rather than numeric) when specifying an ACROSS variable in PROC REPORT.

You just need to include a dummy analysis variable as in the example below:

data ReportData;
Dummy=1;
Groupvar='Group 1'; SummaryVar='A'; CharVar='20%'; output;
Groupvar='Group 1'; SummaryVar='B'; CharVar='80%'; output;
Groupvar='Group 2'; SummaryVar='A'; CharVar='30%'; output;
Groupvar='Group 2'; SummaryVar='B'; CharVar='70%'; output;
run;

proc report data=ReportData nowindows;
column Groupvar SummaryVar, (CharVar) Dummy;
define GroupVar / 'Group' group;
define SummaryVar / '--Summary--' across;
define CharVar / '' display width=10;
define Dummy / noprint;
run;

Recommended SAS log analyser for SAS users:

Take a look at Elvis SAS log analyser. It takes a SAS log, either from the clipboard or from a saved file, and allows you to view it, navigate around it, search it and more. This makes working with large SAS logs much, much easier and faster than simply looking at the log in a non-specialised viewer such as a plain text editor, Internet Explorer or Notepad.

If you are looking for property in Piemonte Italy then we recommend alba property and piedmont property. Italian real estate.