Install issues
in [SAS]
|
From: Michael Raithel on 5 Nov 2009 08:50 Dear SAS-L-ers, Nat Wooding posted the following: > > The Setinit says that you have paid for the access software but this > does not mean that it was installed. > > Have you tried reading an Excel file using the libname engine or just > issue the libname statement for a workbook and see if you can look at > the workbook using the SAS explorer window. > > My guess is that the access to pc files part was not installed. > Craig, following on Nat's posit, above, a quick way to double-check this is to see if you have the SAS/Connect directories available in your SAS software directory. It should be something along the lines of: C:\Applications\SAS_92\products\sasinstall__92210__win__en__sp0__1\sas\access Check it out! Craig, best of luck in all of your SAS endeavors! I hope that this suggestion proves helpful now, and in the future! Of course, all of these opinions and insights are my own, and do not reflect those of my organization or my associates. All SAS code and/or methodologies specified in this posting are for illustrative purposes only and no warranty is stated or implied as to their accuracy or applicability. People deciding to use information in this posting do so at their own risk. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Michael A. Raithel "The man who wrote the book on performance" E-mail: MichaelRaithel(a)westat.com Author: Tuning SAS Applications in the MVS Environment Author: Tuning SAS Applications in the OS/390 and z/OS Environments, Second Edition http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=58172 Author: The Complete Guide to SAS Indexes http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=60409 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Pleasure is Nature's test, her sign of approval. When man is happy, he is in harmony with himself and his environment. - Oscar Wilde +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
From: Gerhard Hellriegel on 5 Nov 2009 09:08 Hi Mikeee, small typo: you mean SAS/ACCESS, not SAS/connect. In elder versions there were test-routines for the test of any installed module. Don't remember exactly, in the SAMPLES or MISC? I'm also quite sure for the mainframe installation, but not on win (?), but I think they should exist also on other platforms. Also there should be a installation log. Another idea: in the config library (normally in the SAS root directory) there are some pathes to the modules subdirectories. There should be something with "access" to PC files (?). If not and the subdirectory is there, maybe the config file is wrong, or the wrong one is used. Gerhard On Thu, 5 Nov 2009 08:50:28 -0500, Michael Raithel <michaelraithel(a)WESTAT.COM> wrote: >Dear SAS-L-ers, > >Nat Wooding posted the following: > >> >> The Setinit says that you have paid for the access software but this >> does not mean that it was installed. >> >> Have you tried reading an Excel file using the libname engine or just >> issue the libname statement for a workbook and see if you can look at >> the workbook using the SAS explorer window. >> >> My guess is that the access to pc files part was not installed. >> >Craig, following on Nat's posit, above, a quick way to double-check this is to see if you have the SAS/Connect directories available in your SAS software directory. It should be something along the lines of: > >C:\Applications\SAS_92\products\sasinstall__92210__win__en__sp0__1 \sas\access > >Check it out! > >Craig, best of luck in all of your SAS endeavors! > > >I hope that this suggestion proves helpful now, and in the future! > >Of course, all of these opinions and insights are my own, and do not reflect those of my organization or my associates. All SAS code and/or methodologies specified in this posting are for illustrative purposes only and no warranty is stated or implied as to their accuracy or applicability. People deciding to use information in this posting do so at their own risk. > >+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ >Michael A. Raithel >"The man who wrote the book on performance" >E-mail: MichaelRaithel(a)westat.com > >Author: Tuning SAS Applications in the MVS Environment > >Author: Tuning SAS Applications in the OS/390 and z/OS Environments, Second Edition >http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=58172 > >Author: The Complete Guide to SAS Indexes >http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=60409 > >+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ >Pleasure is Nature's test, her sign of approval. When man is >happy, he is in harmony with himself and his environment. - Oscar Wilde >+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
From: Craig Johnson on 5 Nov 2009 09:26 Installed the SAS PC Files Server option, looks promising per the description.... Description: Enables SAS/ACCESS interface to PC files, such as Excel and MS Access. Made sure SAS PC Files windows service was running and ran the libname statement again....the result.... ERROR: The ACCESS engine cannot be found. ERROR: Error in the LIBNAME statement. Path: C:\Program Files\SAS ***************** Folders ***************** deploymntreg EnterpriseGuide Gen1 InstallMisc NVWorkshop PCFilesServer ReportFontsforClients SASDeploymentManager SASDeploymentTesterClient SASFoundation SASGraphJavaApplets SASGRAPHODSGraphicsEditor SASODBC SASOnlineDoc SASSecureJava SASSQLLibraryForC SASUniversalViewer SASVersionedJarRepository SASXMLMapper SharedFiles SharedFiles(32) TSODBC uninst *Sigh* So much for an easy upgrade.
From: Michael Raithel on 5 Nov 2009 10:05 Dear SAS-L-ers, Gerhard posted the following from across the dark and stormy Atlantic,: > Hi Mikeee, > small typo: you mean SAS/ACCESS, not SAS/connect. > > In elder versions there were test-routines for the test of any > installed > module. Don't remember exactly, in the SAMPLES or MISC? I'm also quite > sure for the mainframe installation, but not on win (?), but I think > they > should exist also on other platforms. > Also there should be a installation log. > Another idea: in the config library (normally in the SAS root > directory) > there are some pathes to the modules subdirectories. There should be > something with "access" to PC files (?). If not and the subdirectory is > there, maybe the config file is wrong, or the wrong one is used. > Gerhard, ah yes; thanks for catching that; I did mean SAS/Access! I was trying to get that email out before my 9:00am meeting and--as my Mom used to say: "Haste makes waste":-( In my original reply, was also going to suggest the sample programs. They can be found in a subdirectory for each product. I this case, they would be in: C:\Applications\SAS_92\products\sasinstall__92210__win__en__sp0__1\sas\access\sample The only reason that I decided not to mention the samples is that Craig had a live program that he could test on. So, I didn't think he needed the samples. But, good point; they are there for a reason, and other 'L-ers might not have known about them. Gerhard, best of luck in all of your SAS endeavors! I hope that this suggestion proves helpful now, and in the future! Of course, all of these opinions and insights are my own, and do not reflect those of my organization or my associates. All SAS code and/or methodologies specified in this posting are for illustrative purposes only and no warranty is stated or implied as to their accuracy or applicability. People deciding to use information in this posting do so at their own risk. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Michael A. Raithel "The man who wrote the book on performance" E-mail: MichaelRaithel(a)westat.com Author: Tuning SAS Applications in the MVS Environment Author: Tuning SAS Applications in the OS/390 and z/OS Environments, Second Edition http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=58172 Author: The Complete Guide to SAS Indexes http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=60409 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ In ordinary life we hardly realize that we receive a great deal more than we give, and that it is only with gratitude that life becomes rich. - Dietrich Bonhoeffer +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
From: Michael Raithel on 5 Nov 2009 10:20 Dear SAS-L-ers, Working diligently on his vexing problem, Craig Johnson posted an update: > Installed the SAS PC Files Server option, looks promising per the > description.... > Description: Enables SAS/ACCESS interface to PC files, such as Excel > and MS > Access. > > Made sure SAS PC Files windows service was running and ran the libname > statement again....the result.... > > ERROR: The ACCESS engine cannot be found. > ERROR: Error in the LIBNAME statement. > > Path: C:\Program Files\SAS > > ***************** > Folders > ***************** > deploymntreg > EnterpriseGuide > Gen1 > InstallMisc > NVWorkshop > PCFilesServer > ReportFontsforClients > SASDeploymentManager > SASDeploymentTesterClient > SASFoundation > SASGraphJavaApplets > SASGRAPHODSGraphicsEditor > SASODBC > SASOnlineDoc > SASSecureJava > SASSQLLibraryForC > SASUniversalViewer > SASVersionedJarRepository > SASXMLMapper > SharedFiles > SharedFiles(32) > TSODBC > uninst > > *Sigh* So much for an easy upgrade. Craig; what, are you still here?!?!??!? <VBG> and my condolences! We've g= ot to get you off this problem once and for all! Ready team?!?!?!? Okay, so what if we back off a bit from your tried-and-true LIBNAME stateme= nt (under SAS 9.1.3, that is). How about simply getting into SAS Display M= anager and using the SAS Wizards to Export a SAS data set--the much used an= d abused SASHELP.CLASS--to an Excel spreadsheet? You know, <FILE><Export D= ata><etc.> Take all of the defaults and see if that works. This should div= orce the issue from any programmatic, environmental issues that you may hav= e inadvertently introduced. It should simply be SAS trying to use SAS/Acce= ss to PC Files and nothing more. If it doesn't work, then you definitely do not have SAS/Access Interface to= PC Files installed correctly. I would then dial 1 - 929 -677 - 8000 with = my SAS site number in hand and hope in my heart for a quick resolution from= the dedicated SAS Technical Support sharpies! If this _DOES_ work, then you need to get out your programmatic microscope = and dissect your LIBNAME statement. Craig, best of luck in all of your SAS endeavors! I hope that this suggestion proves helpful now, and in the future! Of course, all of these opinions and insights are my own, and do not reflec= t those of my organization or my associates. All SAS code and/or methodolog= ies specified in this posting are for illustrative purposes only and no war= ranty is stated or implied as to their accuracy or applicability. People de= ciding to use information in this posting do so at their own risk. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Michael A. Raithel "The man who wrote the book on performance" E-mail: MichaelRaithel(a)westat.com Author: Tuning SAS Applications in the MVS Environment Author: Tuning SAS Applications in the OS/390 and z/OS Environments, Second= Edition http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=3D1&pc=3D58172 Author: The Complete Guide to SAS Indexes http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=3D1&pc=3D60409 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ In most of mankind gratitude is merely a secret hope for greater favours. -= Francois de La Rochefoucauld +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
|
Next
|
Last
Pages: 1 2 Prev: Tagsets.excelxp Password protect excel worksheets Next: software engineering |