LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (October 2011, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 18 Oct 2011 20:26:43 -0400
Reply-To:     Richard <r.hockey@SPH.UQ.EDU.AU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Richard <r.hockey@SPH.UQ.EDU.AU>
Subject:      Re: SAS PC Files Server... On my last nerve

Welcome to SAS PC files server hell! I eventually got mine to work but its not that easy and SI are no help. Couple of points to check. Does the bitness of your Office and pc files server match? You need to specify full paths for files. You don't need to start the server (or specify the port or server)if you are accessing files on the same machine it starts automatically. Cheers R

On Tue, 18 Oct 2011 11:53:31 -0700, Jordan, Lewis <Lewis.Jordan@WEYERHAEUSER.COM> wrote:

>Thanks for the response Avi. Yes, I did try that as well. However, to no avail. I also tried changing the default PORT b/c there appeared to be some problems with SAS using the default 8621. Nothing worked. So... finally I did a complete reinstall of SAS and it solved my problem! > >Thanks, > >Lewis > >***************************** >Lewis Jordan >Weyerhaeuser: >Southern Timberlands R&D >Cell (Primary): 662-889-4514 >Office: 662-245-5227 >lewis.jordan@weyerhaeuser.com >***************************** > >-----Original Message----- >From: Chaitovsky, Avi-Gil [mailto:Avi-Gil.Chaitovsky@anthem.com] >Sent: Tuesday, October 18, 2011 1:04 PM >To: Jordan, Lewis >Cc: SAS-L@LISTSERV.UGA.EDU >Subject: RE: SAS PC Files Server... On my last nerve > >Jordan, >You might want to try going to the Control Panel->Administrative >Tools->Services and looking for SAS PC Files Server there. Make sure >that the service has been started (there is a way to have it start >automatically when you start up your computer, though I can't recall >offhand where that option is), and try going into properties and playing >with the options on the "log on" tab. > >Avi > >Avi-Gil Chaitovsky >WellPoint, Inc. >Empire BlueCross BlueShield >HealthCare Analytics >Provider Contracting/Cost of Care Analyst Sr >165 Broadway, 14th Floor >New York, NY 10006 >Avi-Gil.Chaitovsky@anthem.com >(212) 476-1483 > >-----Original Message----- >From: Jordan, Lewis [mailto:Lewis.Jordan@WEYERHAEUSER.COM] >Sent: Tuesday, October 18, 2011 9:58 AM >Subject: SAS PC Files Server... On my last nerve > >I've been having problems with SAS PC Files Server. The only thing >keeping me from smashing my machine with a 10-lb sledge is that it's a >company computer! > >Details: > >Windows: Windows 7 Pro >System: 64-bit >SAS: 9.2 (TSM2M3) - X64 (64-bit SAS) > >There are a couple of threads along this line on the SAS-L, but they've >not helped. I've reinstalled SAS PC FILES Server and the ODBC drivers >used for MS Excel and MS Access. I'm running PC Files Server on the same >machine SAS is located on, so upon reinstall I tried: > >15 PROC IMPORT OUT=yoursasdata >DATAFILE='C:\Users\jordanle\Desktop\book1.xlsx' >16 DBMS=excelcs REPLACE; >17 SHEET='Sheet1$'; >18 run; > >ERROR: Failed to connect to the Server: . >NOTE: The SAS System stopped processing this step because of errors. >NOTE: PROCEDURE IMPORT used (Total process time): > real time 0.33 seconds > cpu time 0.15 seconds > > > >Ok, I then tried: > > >20 PROC IMPORT OUT=yoursasdata >DATAFILE='C:\Users\jordanle\Desktop\book1.xls' >21 DBMS=excelcs REPLACE; >22 SHEET='Sheet1$'; >23 port=9621; >24 run; > >ERROR: Failed to connect to the Server: . >NOTE: The SAS System stopped processing this step because of errors. >NOTE: PROCEDURE IMPORT used (Total process time): > real time 0.34 seconds > cpu time 0.14 seconds > > >Finally, I tried: > >59 PROC IMPORT OUT=yoursasdata >DATAFILE='C:\Users\jordanle\Desktop\book1.xlsx' >60 DBMS=excelcs REPLACE; >61 SHEET='Sheet1$'; >62 port=9621; >63 server="localhost"; >64 run; > >Connection Failed. See log for details. >NOTE: The SAS System stopped processing this step because of errors. >NOTE: PROCEDURE IMPORT used (Total process time): > real time 0.29 seconds > cpu time 0.17 seconds > > > >I then opened SAS PC Files Server and am hit immediately with a pop-up >box which states: > >"Unable to connect to service/port 9621, Code = 3" > > >AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAhhhhhhhhhhh. > >Any help out there? > > > > >***************************** >Lewis Jordan >Weyerhaeuser: >Southern Timberlands R&D >Cell (Primary): 662-889-4514 >Office: 662-245-5227 >lewis.jordan@weyerhaeuser.com >***************************** > > >CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information or otherwise protected by law. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.


Back to: Top of message | Previous page | Main SAS-L page