07-24-2015 01:23 PM
With proc report, I don't know but you could do a workaround with the data. Keep one obs, set the values to missing and report that.
set sashelp.shoes (obs = 1);
call missing(region, product);
title 'Empty Shoes Table';
proc report data = shoes_dummy nowd;
col region product;
07-25-2015 09:05 AM
No . You can't . Workaround way is making variables' name as an obs.
proc transpose data=sashelp.class(obs=0) out=temp ;
proc transpose data=temp out=want(drop=_name_ _label_);
proc report data=want nowd noheader;run;
07-25-2015 01:19 PM
Here is a possible approach. You have to have at least one data row. It can be "empty", but perhaps it will work for you.
ods html file='c:\temp\strange_report.html';
options missing=' ';
proc report data=sashelp.class(obs=1) nowd missing;
title 'Model Report with only headers and 1 blank row';
column name age sex height weight;
name = ' ';
age.sum = .;
sex = ' ';
height.sum = .;
weight.sum = .;
ods html close;
07-27-2015 03:03 AM
How "nice" does your output need to be?
07-27-2015 05:24 AM
Rather than proc report can you not just do something like (not tested):
set sashelp.vcolumn (where=(libname="WORK" and memname="YOURDS"));