An Idea Exchange for SAS software and services

by New Contributor TimBrowning
on ‎02-01-2013 12:50 PM
Me too...every day.
by Respected Advisor
on ‎05-16-2014 09:08 AM

Could you use the output data set?

proc report nowd out=test;
   columns region product stores;
   define region / group;
define product / group;
by New Contributor Torben_Pedersen
on ‎08-13-2016 06:30 AM

we miss this too every day.

our users outputs reports to excel all the time and asks for repeated values.

output dataset is useless when you have a acrossvariable.

columns is named _cxx_ 

by Super User
on ‎08-13-2016 08:00 PM

Thanks for the support @Torben_Pedersen. I think a lot of other users would find this useful too.

by Learner JensNielsen
on ‎09-06-2016 03:09 AM

Since our users regularly asks for this option, especially in connection with the transfer of data from SAS to Microsoft Excel, I have just coded some very complex macros to address this problem, but it would be much simpler if it could be done by an option to Proc Report.


The complexity of the macro occurs because you have to take into account the hierarchies inherent in data, so you can not just indiscriminately can transfer values to the current observation from the previous one.

Idea Statuses
Top Liked Authors