## DDE Problem|| output overflow

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 435343 435343 435343 435343 435343 435343 435343 435343 435343 435343 435343 435343 4.35E+08 434534534 4.35E+08 4.35E+08 4.35E+08 4.35E+08 4.35E+08 4.35E+08 4.35E+08 4.35E+08 4.35E+08 4.35E+08 8.69E+08 868633725 8.69E+08 8.69E+08 8.69E+08 8.69E+08 8.69E+08 8.69E+08 8.69E+08 8.69E+08 8.69E+08 8.69E+08 1.3E+09 1.303E+09 1.3E+09 1.3E+09 1.3E+09 1.3E+09 1.3E+09 1.3E+09 1.3E+09 1.3E+09 1.3E+09 1.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 435343 435343 435343 435343 435343 435343 435343 435343 435343 435343 435343 435343 4.35E+08 434534534 4.35E+08 4.35E+08 4.35E+08 4.35E+08 4.35E+08 4.35E+08 4.35E+08 4.35E+08 4.35E+08 4.35E+08 8.69E+08 868633725 8.69E+08 8.69E+08 8.69E+08 8.69E+08 8.69E+08 8.69E+08 8.69E+08 8.69E+08 8.69E+08 868633725 1.3E+09 1.303E+09 1.3E+09 1.3E+09 1.3E+09 1.3E+09 1.3E+09 1.3E+09 1.3E+09 1.3E+09 1.3E+09 1.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???

Discussion stats
• 0 replies
• 283 views
• 0 likes
• 1 in conversation