SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

DDE Problem|| output overflow

Reply
Occasional Contributor
Posts: 8

DDE Problem|| output overflow

My data is look like this

  _201101_201102_201103_201104_201105_201106_201107_201108_201109_201110_201111_201112
435343435343435343435343435343435343435343435343435343435343435343435343
4.35E+084345345344.35E+084.35E+084.35E+084.35E+084.35E+084.35E+084.35E+084.35E+084.35E+084.35E+08
8.69E+088686337258.69E+088.69E+088.69E+088.69E+088.69E+088.69E+088.69E+088.69E+088.69E+088.69E+08
1.3E+091.303E+091.3E+091.3E+091.3E+091.3E+091.3E+091.3E+091.3E+091.3E+091.3E+091.3E+09

when i extracted into excel with dde... output going overflow cell. and look like this on the output excel :

   _201101   _201102   _201103_201104_201105_201106_201107_201108_201109_201110_201111_201112
435343435343435343435343435343435343435343435343435343435343435343435343
4.35E+084345345344.35E+084.35E+084.35E+084.35E+084.35E+084.35E+084.35E+084.35E+084.35E+084.35E+08
8.69E+088686337258.69E+088.69E+088.69E+088.69E+088.69E+088.69E+088.69E+088.69E+08
8.69E+08868633725
1.3E+091.303E+091.3E+091.3E+091.3E+091.3E+091.3E+091.3E+091.3E+091.3E+091.3E+091.3E+09

I'm using simple DDE code:

filename summary dde 'excel|[file.xls]sheet1!r1c1:r4c12;

data _null_;

set dataset;

file somedataset;

put _&macroextractheader;

run;

whats going on, on it???

Ask a Question
Discussion stats
  • 0 replies
  • 275 views
  • 0 likes
  • 1 in conversation