Chris;
Thanks for looking at this. I am now getting an "ERROR: Undetermined I/O failure". I tried putting this same code into a program, so I could test my code. I definately have write access to this drive. And the "Program" version works were the "Stored Process" does not. So I put the Stored Process in a different project and that did not have any affect.
Here's the log:
1 The SAS System 17:40 Monday, November 8, 2010
NOTE: Copyright (c) 2002-2008 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.2 (TS2M3)
Licensed to SOCIAL SERVICES COORDINATORS/MAINLINE INFO, Site 70067395.
NOTE: This session is executing on the X64_SRV08 platform.
NOTE: SAS Initialization used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The autoexec file, C:\SAS\SASEBI\Lev1\SASMain\StoredProcessServer\autoexec.sas, was executed at server initialization. No server log was specified. Add the log option to the server startup command to see details of the autoexec execution (refer to
"Specifying Logging Options" under "Server Startup Command" in the Server Administrator's Guide).
>>> SAS Macro Variables:
PARENT=Arcadian
RPT_YEAR=2010
SYSDBMSG=
SYSDBRC=0
_APSLIST=RPT_YEAR,PARENT,_RESULT,_ODSSTYLE,_ENCODING,_CLIENTNAME,_ODSDEST,_ODSSTYLESHEET,_GOPT_DEVICE,_METAPERSON,_ODSOPTIONS,_METAFOLDER,_METAUSER,_PROGRAM,_CLIENT,_USERNAME,_SECUREUSERNAME
_CLIENT=SAS Enterprise Guide; CLR 2.0.50727.3615; Microsoft Windows NT 5.1.2600 Service Pack 3
_CLIENTNAME=SAS Enterprise Guide
_ENCODING=utf-8
_GOPT_DEVICE=ACTIVEX
_METAFOLDER=/SSC Analytics/Lost_LIS/
_METAPERSON=James Baillie
_METAUSER=jbaillie@SSC
_ODSDEST=HTML
_ODSOPTIONS=ATTRIBUTES=("CODEBASE"="http://www2.sas.com/codebase/graph/v92/sasgraph.exe#version=9,2")
_ODSSTYLE=sasweb
_ODSSTYLESHEET=(URL="file:///C:/Program%20Files/SAS/SharedFiles/BIClientStyles/4.2/sasweb.css")
_PROGRAM=/SSC Analytics/Lost_LIS/Export_Lost_LIS_Detail_sp
_REPLAY="&_URL?_sessionid=4F6978CD-9395-48FC-89FA-654678FF6D58&_program=replay&_entry=&_TMPCAT.."
_RESULT=STREAM
_SECUREUSERNAME=jbaillie
_TMPCAT=APSWORK.TCAT003A
_USERNAME=jbaillie
1 options nosource source2 center notes nodate nonumber ls=195 formchar='|----|+|---+=|-/\<>*' pagesize=40 noovp nomprint nomlogic nosymbolgen; title; footnote;
The SAS System
NOTE: %INCLUDE (level 1) file D:\SSC\SAS Source Code\SSC_Op_Analysis_Dev\Export_Lost_LIS_Detail_sp.sas is file D:\SSC\SAS Source Code\SSC_Op_Analysis_Dev\Export_Lost_LIS_Detail_sp.sas.
3 +* Begin EG generated code (do not edit this line);
4 +*
5 +* Stored process registered by
6 +* Enterprise Guide Stored Process Manager V4.2
7 +*
8 +* ====================================================================
9 +* Stored process name: Export_Lost_LIS_Detail_sp
10 +*
11 +* Keywords: Lost LIS, Export
12 +* ====================================================================
13 +*
14 +* Stored process prompt dictionary:
15 +* ____________________________________
16 +* PARENT
17 +* Type: Text
18 +* Label: Parent
19 +* Attr: Visible
20 +* ____________________________________
21 +* RPT_YEAR
22 +* Type: Numeric
23 +* Label: Rpt_Year
24 +* Attr: Visible, Required
25 +* Default: 2010
26 +* ____________________________________
27 +*;
28 +
29 +
30 +*ProcessBody;
31 +
32 +%global PARENT
33 + RPT_YEAR;
34 +
35 +OPTIONS VALIDVARNAME=ANY;
36 +* End EG generated code (do not edit this line);
37 +
38 +%STPBEGIN;
39 +
The SAS System
40 +%global Parent Path Rpt_Year Run_Dt;
41 +
42 +
43 +Data _NULL_;
44 + Run_Dt=compress(put(DateTime(),IS8601DT.),'-:');
45 + call symput('Run_Dt',trim(Run_Dt));
46 +run;
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
47 +%put NOTE: Runt_Dt ===>&Run_Dt.<===;
NOTE: Runt_Dt ===>20101108T174033<===
48 +
49 +libname mmsdmart meta library="mmsdmart";
NOTE: Libref MMSDMART was successfully assigned as follows:
Engine: META
Physical Name: D:\MMSDMART
50 +
51 +%Let Path=\\nas-fl\IT\Data Services\LostLISReports\LostLIS_2010_2011;
52 +
53 +proc export
54 + data=mmsdmart.LostLIS&Rpt_Year._DETAIL (where=(parentname="&Parent"))
55 + outfile="&Path.\&Parent._LOSTLIS_DETAIL_&Run_Dt..tab"
56 + dbms=TAB
57 +;
58 +run;
NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST.
ERROR: Undetermined I/O failure.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 1 observations read from the data set MMSDMART.LOSTLIS2010_DETAIL.
WHERE parentname='Arcadian';
NOTE: DATA statement used (Total process time):
real time 0.24 seconds
The SAS System
cpu time 0.01 seconds
0 records created in \\nas-fl\IT\Data Services\LostLISReports\LostLIS_2010_2011\Arcadian_LOSTLIS_DETAIL_20101108T174033.tab from MMSDMART.LOSTLIS2010_DETAIL.
NOTE: "\\nas-fl\IT\Data Services\LostLISReports\LostLIS_2010_2011\Arcadian_LOSTLIS_DETAIL_20101108T174033.tab" file was successfully created.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.72 seconds
cpu time 0.07 seconds
219 +quit;
220 +
221 +%STPEND;
222 +
223 +* Begin EG generated code (do not edit this line);
224 +;*';*";*/;quit;
225 +
226 +* End EG generated code (do not edit this line);
NOTE: %INCLUDE (level 1) ending.