As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Dump wide table to HTML report

From sasCommunity
Jump to: navigation, search

This SAS macro dumps a data set to an HTML report in a single line of SAS code. It's useful for data sets with many variables, with long character values, or where the reader needs to focus on individual observations. It’s similar to PROC PRINT, but transposed: each variable has its own row (columns become rows).

The macro is interesting for those learning SAS macro programming. It demonstrates how to

  • pull the variable names out of a data set
  • create a macro variable array using PROC SQL
  • iterate the macro variable array
  • create an HTML (or text) file out of a DATA step (without any ODS)

To use the macro, you don't need to know any macro programming: just execute it with a single line of code.

Read more: Dump wide table to HTML report (SAS)