Date: Wed, 29 Jan 2003 11:38:23 -0800
Reply-To: "William W. Viergever" <wwvierg@ATTGLOBAL.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "William W. Viergever" <wwvierg@ATTGLOBAL.NET>
Subject: Re: Add'l infor on problem with EXCEL-SAS (fwd)
In-Reply-To: <Pine.WNT.4.20.0301291020160.-294453@adspc24.auburn.edu>
Content-Type: text/plain; charset="us-ascii"; format=flowed
Hi Lisa:
Have a bad cold so forgive the short, and perhaps mistaken, response, but
it looks like you forgot the name of the Excel file in your FILENAME
statements:
Here's an example from some code of mine:
filename tab1 dde "excel|[FY01.PROVNO.List.as.of.01-13-2003.xls]January
2003 Data Pull!r1c1:r58c7" notab lrecl = 1024 ;
Notice the name of the Excel file in the square brackets, followed by TAB
name & range.
Hope this helps
At 10:22 AM 1/29/2003 -0600, Lisa Kriese-Anderson wrote:
> SAS-L
>
>Attached is the LOG file from my SAS program trying to read multiple
>datasets. Perhaps I do need to "flush" the DDE statement ..... how is
>that accomplished?
>
>Thanks for the help.
>
>
>I "know" I did this is version 6.2
>
>Maybe this is a version 8. difference
>
>
>NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA.
>NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0)
> Licensed to AUBURN UNIVERSITY OFFICE OF INFORMATION TECHNOLOGY, Site
>0001972001.
>NOTE: This session is executing on the WIN_98 platform.
>
>
>
>NOTE: SAS initialization used:
> real time 1.31 seconds
>
>1 /* This program is written to analyze 2001 P2R data where EXCEL
>worksheets are used */
>
>2 /* It is imperative that EXCEL be opened with the appropriate
>spreadsheet. Otherwise */
>
>3 /* you will see a physical file not found message in the SAS
>log. */
>
>4
>5 options pagesize=50;
>6
>7 filename dderead1 dde 'excel|August 2001!r4c1:r189c77';
>8 filename dderead2 dde 'excel|Septmeber 01!r4c1:r65c73';
>9 /*
>10 filename dderead3 dde 'excel|Survey01!r3c74:r63c74';
>11 filename dderead4 dde 'excel|Survey02!r2c1:r63c92';
>12 filename dderead5 dde 'excel|Survey02!r2c93:r63c93';
>13 filename dderead6 dde 'excel|Survey02!r2c94:r63c94'; */
>14
>15
>16 data august01;
>17 format owner $char40.;
>18 infile dderead1 dlm='09'X dsd notab missover lrecl=512;
>19
>20 input
>21 altag $
>22 farmtag $
>23 owner $
>24 ownercode $
>25 bdate $
>26 csex $
>27 sbreed $
>28 sireid $
>29 dbreed $
>30 damid $
>31 shipwt
>32 muscle $
>33 begprice
>34 alvalue
>35 lot
>36 vid
>37 eid
>38 ontestbf
>39 ontestwt
>40 frame
>41 middate $
>42 midwt
>43 midbf
>44 midadg
>45 sdate $
>46 dof
>47 offwt
>48 stunwt
>49 offwt2
>50 offadg
>51 totgain
>52 dmfe
>53 dmfeedlbs
>54 affe
>55 affeedlbs
>56 feed
>57 hospital
>58 alliance
>59 processing
>60 yardage
>61 insurance
>62 interest
>63 checkoff
>64 subtot
>65 trucking
>66 total
>67 cognt
>68 costgain
>69 hcw
>70 trimhcw
>71 ohcw
>72 dressing
>73 orea
>74 marbsc $
>75 bf
>76 rea
>77 yg
>78 qg $
>79 kph
>80 harvest $
>81 topksprice
>82 oliveprice
>83 livewrth
>84 sbase
>85 sincent
>86 sprice
>87 stotal
>88 junk
>89 gbase
>90 gincent
>91 gprice
>92 gtotal
>93 carcval
>94 lprofit
>95 sprofit
>96 gprofit
>97 diff;
>98
>99 if hospital = . then hospital = 0.00;
>100
>101 if csex = 'heifer' then sex = 2;
>102 if csex = 'steer' then sex = 1;
>103
>104 month = 'aug';
>105 year = 2001;
>106
>
>NOTE: The infile DDEREAD1 is:
> DDE Session,
> SESSION=excel|August 2001!r4c1:r189c77,RECFM=V,
> LRECL=512
>
>NOTE: 186 records were read from the infile DDEREAD1.
> The minimum record length was 240.
> The maximum record length was 465.
>NOTE: The data set WORK.AUGUST01 has 186 observations and 80 variables.
>NOTE: DATA statement used:
> real time 0.15 seconds
>
>
>107 proc means;
>108
>
>NOTE: There were 186 observations read from the data set WORK.AUGUST01.
>NOTE: PROCEDURE MEANS used:
> real time 0.11 seconds
>
>
>109 data september01;
>110 format owner $char40.;
>111 infile dderead2 dlm='09'X dsd notab missover lrecl=450;
>112
>113 input
>114 altag $
>115 farmtag $
>116 owner $
>117 ownercode $
>118 bdate $
>119 csex $
>120 sbreed $
>121 sireid $
>122 dbreed $ /* September 2001 calves */
>123 damid $
>124 shipwt
>125 muscle $
>126 begprice
>127 alvalue
>128 lot
>129 vid
>130 eid
>131 ontestbf
>132 ontestwt
>133 frame
>134 middate $
>135 midwt
>136 midbf
>137 midadg
>138 sdate $
>139 dof
>140 offwt
>141 stunwt
>142 offadg
>143 totgain
>144 dmfe
>145 dmfeedlbs
>146 affe
>147 affeedlbs
>148 feed
>149 hospital
>150 alliance
>151 processing
>152 yardage
>153 insurance
>154 interest
>155 checkoff
>156 subtot
>157 trucking
>158 total
>159 cognt
>160 costgain
>161 hcw
>162 trimhcw
>163 dressing
>164 bf
>165 orea
>166 rea
>167 yg
>168 qg $
>169 kph
>170 harvest $
>171 topksprice
>172 livewrth
>173 sbase
>174 sincent
>175 sprice
>176 stotal
>177 junk
>178 gbase
>179 gincent
>180 gprice
>181 gtotal
>182 carcval
>183 lprofit
>184 sprofit
>185 gprofit
>186 diff;
>187
>188 if hospital = . then hospital = 0.00;
>189
>190 if csex = 'heifer' then sex = 2;
>191 if csex = 'steer' then sex = 1;
>192
>193 month = 'sep';
>194
>195 year = 2001;
>196
>
>ERROR: Read Access Violation In Task ( DATASTEP ]
>Exception occurred at (67E6883B)
>Task Traceback
>
>NOTE: The SAS System stopped processing this step because of errors.
>WARNING: The data set WORK.SEPTEMBER01 may be incomplete. When this step
>was stopped there
> were 0 observations and 76 variables.
>NOTE: DATA statement used:
> real time 0.04 seconds
>
>
>
>197 proc means;
>198 run;
>
>NOTE: No observations in data set WORK.SEPTEMBER01.
>NOTE: PROCEDURE MEANS used:
> real time 0.06 seconds
>
>
>199
>ERROR: Read Access Violation In Task ( DATASTEP ]
>Exception occurred at (67E6883B)
>Task Traceback
>
>NOTE: DATA statement used:
> real time 0.00 seconds
>
>200 data all11; set august01 september01;
>
>NOTE: SCL source line.
>201 parrea = 11 + ((hcw -600)/100)*1.2;
> ------
> 180
>
>ERROR 180-322: Statement is not valid or it is used out of proper order.
>
>202
>ERROR: Read Access Violation In Task ( PRINT ]
>Exception occurred at (67E6883B)
>Task Traceback
>
>NOTE: PROCEDURE PRINT used:
> real time 0.00 seconds
>
>NOTE: SCL source line.
>203 proc print data =all1; var rea parrea owner ownercode;
> ---
> 180
>
>
>ERROR 180-322: Statement is not valid or it is used out of proper order.
>
>204 run;
------------------------------------------------------------
William W. Viergever Voice : (916) 483-8398
Viergever & Associates Fax : (916) 486-1488
Sacramento, CA 95825 E-mail : wwvierg@attglobal.net
------------------------------------------------------------
| 
