SAS-L archives -- May 2002, week 3 (#372)

Date:         Fri, 17 May 2002 20:56:05 +0000
Reply-To:     mohandas sundareswaran <macmohan_das@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         mohandas sundareswaran <macmohan_das@HOTMAIL.COM>
Subject:      DDE
Content-Type: text/html
<html><div style='background-color:'><DIV></DIV>
<DIV></DIV><FONT face="Courier New" color=#0000ff size=2>
<P>Hi ,</P>
<P>&nbsp;I was trying to output data onto excel as below but the column 8 and 9 was coimng balnk .can any one through some light on it </P>
<P>filename</FONT><FONT face="Courier New" color=#000000 size=2> fld1 </FONT><FONT face="Courier New" color=#0000ff size=2>DDE</P></FONT><FONT face="Courier New" color=#000000 size=2>
<P></FONT><FONT face="Courier New" color=#800080 size=2>'EXCEL|D:\Sas\intrnet\pgms\Data_Warehouse\Jdfr_sas\JDFRWKValue.xls!R2C1:R60000C1'</FONT><FONT face="Courier New" color=#000000 size=2> </FONT><FONT face="Courier New" color=#0000ff size=2>notab</FONT><FONT face="Courier New" color=#000000 size=2>;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>filename</FONT><FONT face="Courier New" color=#000000 size=2> fld2 </FONT><FONT face="Courier New" color=#0000ff size=2>DDE</P></FONT><FONT face="Courier New" color=#000000 size=2>
<P></FONT><FONT face="Courier New" color=#800080 size=2>'EXCEL|D:\Sas\JDFRWKValue.xls!R2C2:R60000C2'</FONT><FONT face="Courier New" color=#000000 size=2> </FONT><FONT face="Courier New" color=#0000ff size=2>notab</FONT><FONT face="Courier New" color=#000000 size=2>;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>filename</FONT><FONT face="Courier New" color=#000000 size=2> fld3 </FONT><FONT face="Courier New" color=#0000ff size=2>DDE</P></FONT><FONT face="Courier New" color=#000000 size=2>
<P></FONT><FONT face="Courier New" color=#800080 size=2>'EXCEL|D:\Sas\JDFRWKValue.xls!R2C3:R60000C3'</FONT><FONT face="Courier New" color=#000000 size=2> </FONT><FONT face="Courier New" color=#0000ff size=2>notab</FONT><FONT face="Courier New" color=#000000 size=2>;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>filename</FONT><FONT face="Courier New" color=#000000 size=2> fld4 </FONT><FONT face="Courier New" color=#0000ff size=2>DDE</P></FONT><FONT face="Courier New" color=#000000 size=2>
<P></FONT><FONT face="Courier New" color=#800080 size=2>'EXCEL|D:\Sas\JDFRWKValue.xls!R2C4:R60000C4'</FONT><FONT face="Courier New" color=#000000 size=2> </FONT><FONT face="Courier New" color=#0000ff size=2>notab</FONT><FONT face="Courier New" color=#000000 size=2>;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>filename</FONT><FONT face="Courier New" color=#000000 size=2> fld5 </FONT><FONT face="Courier New" color=#0000ff size=2>DDE</FONT><FONT face="Courier New" color=#000000 size=2> </P>
<P></FONT><FONT face="Courier New" color=#800080 size=2>'EXCEL|D:\Sas\JDFRWKValue.xls!R2C5:R60000C5'</FONT><FONT face="Courier New" color=#000000 size=2> </FONT><FONT face="Courier New" color=#0000ff size=2>notab</FONT><FONT face="Courier New" color=#000000 size=2>;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>filename</FONT><FONT face="Courier New" color=#000000 size=2> fld6 </FONT><FONT face="Courier New" color=#0000ff size=2>DDE</P></FONT><FONT face="Courier New" color=#000000 size=2>
<P></FONT><FONT face="Courier New" color=#800080 size=2>'EXCEL|D:\Sas\JDFRWKValue.xls!R2C6:R60000C6'</FONT><FONT face="Courier New" color=#000000 size=2> </FONT><FONT face="Courier New" color=#0000ff size=2>notab</FONT><FONT face="Courier New" color=#000000 size=2>;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>filename</FONT><FONT face="Courier New" color=#000000 size=2> fld7 </FONT><FONT face="Courier New" color=#0000ff size=2>DDE</P></FONT><FONT face="Courier New" color=#000000 size=2>
<P></FONT><FONT face="Courier New" color=#800080 size=2>'EXCEL|D:\Sas\JDFRWKValue.xls!R2C7:R60000C7'</FONT><FONT face="Courier New" color=#000000 size=2> </FONT><FONT face="Courier New" color=#0000ff size=2>notab</FONT><FONT face="Courier New" color=#000000 size=2>;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>filename</FONT><FONT face="Courier New" color=#000000 size=2> fld8 </FONT><FONT face="Courier New" color=#0000ff size=2>DDE</P></FONT><FONT face="Courier New" color=#000000 size=2>
<P></FONT><FONT face="Courier New" color=#800080 size=2>'EXCEL|D:\Sas\JDFRWKValue.xls!R2C8:R60000C8'</FONT><FONT face="Courier New" color=#000000 size=2> </FONT><FONT face="Courier New" color=#0000ff size=2>notab</FONT><FONT face="Courier New" color=#000000 size=2>;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>filename</FONT><FONT face="Courier New" color=#000000 size=2> fld9 </FONT><FONT face="Courier New" color=#0000ff size=2>DDE</P></FONT><FONT face="Courier New" color=#000000 size=2>
<P></FONT><FONT face="Courier New" color=#800080 size=2>'EXCEL|D:\Sas\JDFRWKValue.xls!R2C9:R60000C9'</FONT><FONT face="Courier New" color=#000000 size=2> </FONT><FONT face="Courier New" color=#0000ff size=2>notab</FONT><FONT face="Courier New" color=#000000 size=2>;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>filename</FONT><FONT face="Courier New" color=#000000 size=2> fld10 </FONT><FONT face="Courier New" color=#0000ff size=2>DDE</P></FONT><FONT face="Courier New" color=#000000 size=2>
<P></FONT><FONT face="Courier New" color=#800080 size=2>'EXCEL|D:\Sas\JDFRWKValue.xls!R2C10:R60000C10'</FONT><FONT face="Courier New" color=#000000 size=2> </FONT><FONT face="Courier New" color=#0000ff size=2>notab</FONT><FONT face="Courier New" color=#000000 size=2>;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>filename</FONT><FONT face="Courier New" color=#000000 size=2> fld11 </FONT><FONT face="Courier New" color=#0000ff size=2>DDE</FONT><FONT face="Courier New" color=#000000 size=2> </P>
<P></FONT><FONT face="Courier New" color=#800080 size=2>'EXCEL|D:\Sas\JDFRWKValue.xls!R2C11:R60000C11'</FONT><FONT face="Courier New" color=#000000 size=2> </FONT><FONT face="Courier New" color=#0000ff size=2>notab</FONT><FONT face="Courier New" color=#000000 size=2>;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>filename</FONT><FONT face="Courier New" color=#000000 size=2> fld12 </FONT><FONT face="Courier New" color=#0000ff size=2>DDE</P></FONT><FONT face="Courier New" color=#000000 size=2>
<P></FONT><FONT face="Courier New" color=#800080 size=2>'EXCEL|D:\Sas\JDFRWKValue.xls!R2C12:R60000C12'</FONT><FONT face="Courier New" color=#000000 size=2> </FONT><FONT face="Courier New" color=#0000ff size=2>notab</FONT><FONT face="Courier New" color=#000000 size=2>;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>filename</FONT><FONT face="Courier New" color=#000000 size=2> fld13 </FONT><FONT face="Courier New" color=#0000ff size=2>DDE</FONT><FONT face="Courier New" color=#000000 size=2> </P>
<P></FONT><FONT face="Courier New" color=#800080 size=2>'EXCEL|D:\Sas\JDFRWKValue.xls!R2C13:R60000C13'</FONT><FONT face="Courier New" color=#000000 size=2> </FONT><FONT face="Courier New" color=#0000ff size=2>notab</FONT><FONT face="Courier New" color=#000000 size=2>;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>filename</FONT><FONT face="Courier New" color=#000000 size=2> fld14 </FONT><FONT face="Courier New" color=#0000ff size=2>DDE</P></FONT><FONT face="Courier New" color=#000000 size=2>
<P></FONT><FONT face="Courier New" color=#800080 size=2>'EXCEL|D:\Sas\JDFRWKValue.xls!R2C14:R60000C14'</FONT><FONT face="Courier New" color=#000000 size=2> </FONT><FONT face="Courier New" color=#0000ff size=2>notab</FONT><FONT face="Courier New" color=#000000 size=2>;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>filename</FONT><FONT face="Courier New" color=#000000 size=2> fld15 </FONT><FONT face="Courier New" color=#0000ff size=2>DDE</P></FONT><FONT face="Courier New" color=#000000 size=2>
<P></FONT><FONT face="Courier New" color=#800080 size=2>'EXCEL|D:\Sas\JDFRWKValue.xls!R2C15:R60000C15'</FONT><FONT face="Courier New" color=#000000 size=2> </FONT><FONT face="Courier New" color=#0000ff size=2>notab</FONT><FONT face="Courier New" color=#000000 size=2>;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>filename</FONT><FONT face="Courier New" color=#000000 size=2> fld16 </FONT><FONT face="Courier New" color=#0000ff size=2>DDE</P></FONT><FONT face="Courier New" color=#000000 size=2>
<P></FONT><FONT face="Courier New" color=#800080 size=2>'EXCEL|D:\Sas\Jdfr_sas\JDFRWKValue.xls!R2C16:R60000C16'</FONT><FONT face="Courier New" color=#000000 size=2> </FONT><FONT face="Courier New" color=#0000ff size=2>notab</FONT><FONT face="Courier New" color=#000000 size=2>;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>filename</FONT><FONT face="Courier New" color=#000000 size=2> fld17 </FONT><FONT face="Courier New" color=#0000ff size=2>DDE</P></FONT><FONT face="Courier New" color=#000000 size=2>
<P></FONT><FONT face="Courier New" color=#800080 size=2>'EXCEL|D:\Sas\JDFRWKValue.xls!R2C17:R60000C17'</FONT><FONT face="Courier New" color=#000000 size=2> </FONT><FONT face="Courier New" color=#0000ff size=2>notab</FONT><FONT face="Courier New" color=#000000 size=2>;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>filename</FONT><FONT face="Courier New" color=#000000 size=2> fld18 </FONT><FONT face="Courier New" color=#0000ff size=2>DDE</P></FONT><FONT face="Courier New" color=#000000 size=2>
<P></FONT><FONT face="Courier New" color=#800080 size=2>'EXCEL|D:\Sas\JDFRWKValue.xls!R2C18:R60000C18'</FONT><FONT face="Courier New" color=#000000 size=2> </FONT><FONT face="Courier New" color=#0000ff size=2>notab</FONT><FONT face="Courier New" color=#000000 size=2>;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>filename</FONT><FONT face="Courier New" color=#000000 size=2> fld19 </FONT><FONT face="Courier New" color=#0000ff size=2>DDE</P></FONT><FONT face="Courier New" color=#000000 size=2>
<P></FONT><FONT face="Courier New" color=#800080 size=2>'EXCEL|D:\Sas\JDFRWKValue.xls!R2C19:R60000C19'</FONT><FONT face="Courier New" color=#000000 size=2> </FONT><FONT face="Courier New" color=#0000ff size=2>notab</FONT><FONT face="Courier New" color=#000000 size=2>;</P>
<P>&nbsp;</P></FONT><B><FONT face="Courier New" color=#000080 size=2>
<P>data</B></FONT><FONT face="Courier New" color=#000000 size=2> </FONT><FONT face="Courier New" color=#0000ff size=2>_NULL_</FONT><FONT face="Courier New" color=#000000 size=2>; </FONT><FONT face="Courier New" color=#0000ff size=2>set</FONT><FONT face="Courier New" color=#000000 size=2> Quantity;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>file</FONT><FONT face="Courier New" color=#000000 size=2> fld1 ; </FONT><FONT face="Courier New" color=#0000ff size=2>put</FONT><FONT face="Courier New" color=#000000 size=2> Run_Date ;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>file</FONT><FONT face="Courier New" color=#000000 size=2> fld2 ; </FONT><FONT face="Courier New" color=#0000ff size=2>put</FONT><FONT face="Courier New" color=#000000 size=2> Cust_Group1;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>file</FONT><FONT face="Courier New" color=#000000 size=2> fld3 ; </FONT><FONT face="Courier New" color=#0000ff size=2>put</FONT><FONT face="Courier New" color=#000000 size=2> SalesDist_CustGrp ; </P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>file</FONT><FONT face="Courier New" color=#000000 size=2> fld4 ; </FONT><FONT face="Courier New" color=#0000ff size=2>put</FONT><FONT face="Courier New" color=#000000 size=2> TechXZ_Code ; </P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>file</FONT><FONT face="Courier New" color=#000000 size=2> fld5 ; </FONT><FONT face="Courier New" color=#0000ff size=2>put</FONT><FONT face="Courier New" color=#000000 size=2> PH1_Group_XD_Activite; </P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>file</FONT><FONT face="Courier New" color=#000000 size=2> fld6 ; </FONT><FONT face="Courier New" color=#0000ff size=2>put</FONT><FONT face="Courier New" color=#000000 size=2> PH2_XD_Segment; </P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>file</FONT><FONT face="Courier New" color=#000000 size=2> fld7 ; </FONT><FONT face="Courier New" color=#0000ff size=2>put</FONT><FONT face="Courier New" color=#000000 size=2> PH3_XD_Collection; </P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>file</FONT><FONT face="Courier New" color=#000000 size=2> fld8 ; </FONT><FONT face="Courier New" color=#0000ff size=2>put</FONT><FONT face="Courier New" color=#000000 size=2> ORDERS_Actual_MTD_XPYXD1XQ_FRF ;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>file</FONT><FONT face="Courier New" color=#000000 size=2> fld9 ; </FONT><FONT face="Courier New" color=#0000ff size=2>put</FONT><FONT face="Courier New" color=#000000 size=2> ORDERS_Actual_MTD_FRF ; </P>
<P></FONT><FONT face="Courier New" color=#008000 size=2>**file fld10 ;** put ORDERS_Actual_YTD_XPYXD1XQ;</FONT><FONT face="Courier New" color=#000000 size=2> </P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>file</FONT><FONT face="Courier New" color=#000000 size=2> fld11 ; </FONT><FONT face="Courier New" color=#0000ff size=2>put</FONT><FONT face="Courier New" color=#000000 size=2> ORDERS_Actual_YTD;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>file</FONT><FONT face="Courier New" color=#000000 size=2> fld12 ; </FONT><FONT face="Courier New" color=#0000ff size=2>put</FONT><FONT face="Courier New" color=#000000 size=2> INVOICES_Actual_MTD_XPYXD1XQ_FRF; </P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>file</FONT><FONT face="Courier New" color=#000000 size=2> fld13 ; </FONT><FONT face="Courier New" color=#0000ff size=2>put</FONT><FONT face="Courier New" color=#000000 size=2> INVOICES_Actual_MTD_FRF; </P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>file</FONT><FONT face="Courier New" color=#000000 size=2> fld14 ; </FONT><FONT face="Courier New" color=#0000ff size=2>put</FONT><FONT face="Courier New" color=#000000 size=2> INVOICES_Actual_YTD_XPYXD1XQ; </P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>file</FONT><FONT face="Courier New" color=#000000 size=2> fld15 ; </FONT><FONT face="Courier New" color=#0000ff size=2>put</FONT><FONT face="Courier New" color=#000000 size=2> INVOICES_Actual_YTD; </P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>file</FONT><FONT face="Courier New" color=#000000 size=2> fld16 ; </FONT><FONT face="Courier New" color=#0000ff size=2>put</FONT><FONT face="Courier New" color=#000000 size=2> BACKLOG_Late_FRF;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>file</FONT><FONT face="Courier New" color=#000000 size=2> fld17 ; </FONT><FONT face="Courier New" color=#0000ff size=2>put</FONT><FONT face="Courier New" color=#000000 size=2> BACKLOG_Normal_FRF;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>file</FONT><FONT face="Courier New" color=#000000 size=2> fld18 ; </FONT><FONT face="Courier New" color=#0000ff size=2>put</FONT><FONT face="Courier New" color=#000000 size=2> BACKLOG_Future_FRF;</P>
<P></FONT><FONT face="Courier New" color=#0000ff size=2>file</FONT><FONT face="Courier New" color=#000000 size=2> fld19 ; </FONT><FONT face="Courier New" color=#0000ff size=2>put</FONT><FONT face="Courier New" color=#000000 size=2> Countit ;</P>
<P></FONT><B><FONT face="Courier New" color=#000080 size=2>run</B></FONT><FONT face="Courier New" color=#000000 size=2>;</P></FONT><FONT face="Courier New" color=#0000ff size=2>
<P>quit</FONT><FONT face="Courier New" color=#000000 size=2>;</P></FONT><BR><BR>Regards<BR>Mohan
<DIV></DIV>
<DIV></DIV>
<DIV></DIV></div><br clear=all><hr>MSN Photos is the easiest way to share and print your photos: <a href='http://g.msn.com/1HM303401/39'>Click Here</a><br></html>
Back to: Top of message | Previous page | Main SAS-L page
listserv.uga.edu
Enterprise Information Technology Services
The University of Georgia
listhelp@uga.edu