COMPGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### Unable to use the SAS Data provider

• Email
• Follow

Hi all,

I am writing a VB program on a pc that does not have local SAS
installed but can run SAS thru a network.  I got a "provider not
found" error when trying to access the SAS.LocalProvider.  I figure I
probably need to tell it where the provider is.  How do I do that?

W.

cn.Provider = "SAS.LocalProvider"
cn.Properties("Data Source") = "c:\mydata"
cn.Open

 0
Reply haungw1 (1) 7/3/2003 3:30:54 PM

See related articles to this posting

From Archives:

Has SAS data provider has been installed?.

Look at this info at SI web site.

http://support.sas.com/rnd/eai/oledb/gs_testing.htm

wh
<haungw1@YAHOO.COM>    To:    SAS-L@LISTSERV.UGA.EDU
Sent by: "SAS(r)       cc:
Discussion"            Subject: Unable to use the SAS Data provider
<SAS-L@LISTSERV.UGA.E
DU>

07/03/2003 08:30 AM

Hi all,

I am writing a VB program on a pc that does not have local SAS
installed but can run SAS thru a network.  I got a "provider not
found" error when trying to access the SAS.LocalProvider.  I figure I
probably need to tell it where the provider is.  How do I do that?

W.

cn.Provider = "SAS.LocalProvider"
cn.Properties("Data Source") = "c:\mydata"
cn.Open

 0

1 Replies
106 Views

Similar Articles

12/12/2013 9:25:25 AM
[PageSpeed]

Similar Artilces:

Re: SAS Data Provider
Don't use SAS\Share. It only comes with SAS Share software which you have to purchase (I'm pretty sure about this but it wouldn't hurt to double-check). Use the SAS IOM provider. From the SAS website: "You can install the SAS IOM Data Provider from the SAS Client-Side Components Volume 1 CD in your SAS Installation Kit. It is included as part of the SAS Providers for OLE DB 9.1 installation. Note: You also can download the most current version of this provider from www.sas.com/apps/demosdownloads/setupintro.jsp. Click on the link for SAS Providers for OLE DB...

Re: Reading SAS data into Excel using ODBC #2
Scott, I tried to send you an email direct but got a kickback. I have an unpublished paper that might shed some light on this area. It's not ready for primetime otherwise I would publish and send out on SAS-L. Contact me at your convenience if you want to get a preliminary copy. Alan Churchill Savian "Bridging SAS and Microsoft Technologies" www.savian.net -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Scott Bass Sent: Friday, October 14, 2005 3:05 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Reading SAS data into Excel using OD...

Re: Does anyone have any experience using SAS ... to read MARC format data?
> From: ben.powell@CLA.CO.UK > I would very much like to know if anyone on the list has any > experience of reading MARC formatted bibliographic data using > SAS. I have an old program written in a defunct language for > an application on VMS and am considering translating it. You may wish to check out the Utah archives of bibliographies which are maintained in BibTeX for LaTeX http://www.listserv.uga.edu/cgi-bin/wa?A2=ind0403C&L=sas-l&P=R10061 Ron Fehd the LaTeX maven CDC Atlanta GA USA RJF2@cdc.gov ...

Re: Does anyone have any experience using SAS ... to read MARC format data?
Thanks for the pointer LaTeX Maven (!!) but I would still need to convert from MARC in order to look at a BiBTeX storage format, Ben. On Fri, 6 Aug 2004 08:56:14 -0400, Fehd, Ronald J. (PHPPO) <RJF2@CDC.GOV> wrote: >> From: ben.powell@CLA.CO.UK >> I would very much like to know if anyone on the list has any >> experience of reading MARC formatted bibliographic data using >> SAS. I have an old program written in a defunct language for >> an application on VMS and am considering translating it. > >You may wish to check out the Utah archives of bibliog...

Re: SAS/AF, V8 objects, Data Entry, an example of use? #4
Randy! Thanks a lot for your advices! And you are right: The example is not correct, ie we have to distinguish between numeric and character vars! Svend -----Original Message----- From: Randy Herbison [mailto:RandyHerbison@westat.com] Sent: Monday, October 06, 2003 11:41 PM To: 'Svend Bang'; SAS-L@LISTSERV.UGA.EDU Subject: RE: SAS/AF, V8 objects, Data Entry, an example of use? Svend, Informats and setting column attributes (min and max values) are 2 other (of several)ways to implement data validation. Using formats to implement data validation is fine. You might want to conside...

Re: SAS/AF, V8 objects, Data Entry, an example of use? #2
Encouraged by the nice example and fine explanation, we have used the sunday for the following: Created a copy of sashelp.class and renamed it to sasuser.schoolclass. Sex was renamed to Gender and given a format $gender.: Value$gender 'M'='M Male' 'F'='F Female' ; Then we changed the test in Randy's program: DCL String(2) choice; DFinit: Put 'DFinit is opened'; Return; Init: Put 'Row opened'; Return; Gender: If gender = putc(gender,'$gender.') then do; choice=messageBox({'ERROR: Invalid gender'},&#... which one of the following SAS procedures is designed to provide functionality similar to the data step code above? Assume that a SAS data set OLD is sorted by ID. Consider the following step: data new (drop = vert_var i) ; array hor_var [3] ; do i = 1 by 1 until (last.id) ; set old ; by id ; hor_var [i] = vert_var ; end ; run ; Referring to the above, which one of the following SAS procedures is designed to provide functionality similar to the data step code above? TRANSPOSE EXPLODE MEANS/SUMMARY TABULATE SQL ... Is it possible to read a sas dataset NOT using sas? Is it possible to read a sas dataset NOT using sas and have observations and variables etc. rather than having meaningless chunks of text? On 18 mrt, 14:43, RolandRB <rolandbe...@hotmail.com> wrote: > Is it possible to read a sas dataset NOT using sas and have > observations and variables etc. rather than having meaningless chunks > of text? YEZZZZ, and even for free !!! Download the sas system viewer: http://www.umass.edu/statdata/software/downloads/SASViewer/index.html Hermie Hi Roland, I guess you know of the World Programming System, WPS? It can read (and write, I th... Re: search SAS data set from SAS code #3 Most O/S have a search feature, eg. Windows has search/find command off Start button, will look inside files for a string, eg. our libname / directory. Ultraedit has a handy search feature as well. On 'NIX, you'll use grep, mainframe, 3.something. Consider putting the program name in the data set label ( which shows up in CONTENTS ) at creation time to better keep track of this type of thing. data libname.mydata ( label = "Created by pgm" ); ... run; -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of Rose Sent: Tuesday, Ap... Re: How to change transaction data to individual level data in SAS #3 Tulikaa, What data to you want at the individual level -- overall transaction counts, counts of certain types of transactions, overall dollar value (or similar total), totals within certain categories, etc.? Determine that first (and that probably requires thinking through the intended uses), and then ask how to get that summary. Steve Albert (SAlbert at AOL dot com) On Tue, 11 May 2004 11:05:40 -0700, Tulikaa <tulikaa@YAHOO.COM> wrote: >I need to change transaction level data (multiple items for each >individual) to individual level data in a big file with thousands of >ob... Emailing SAS Graphs using the pull down option -- SAS 9.1 under Version: 9.1, TS1M3 under Win XP Pro If one creates a graph using SAS Graph and then clicks on File/Send Mail. a new message will be created in one's email system and the graph will appear as an attached BMP file. This is a nice feature since the alternative would be to export the file, go to email, open a new message, and attach the file. However -- and this is my main gripe -- there appears to be no option for naming the attached file. A second gripe is that one can only add one graph using this feature. Question1: Does anyone else use this method of emailing a graph Question2: Are ... using pthread to receive data on a socket and simultaneously play it using /dev/dsp Hi, I am writing a client for a real time audio streaming server. I am using pthread for that. I have one thread receiving data on a socket from the server. After buffering some data, other thread wakes up (checking how much data is in the buffer) to play the music. The problem is that when the 2nd thread is playing, the first thread is not able to receive data from the server. If the server sends the data slow, then there will be breaks in the audio. How do I solve this problem? Thanks. kanchan wrote: > Hi, I am writing a client for a real time audio streaming server. I am > using pt... Re: Exporting a SAS data set to Text file on SAS unix #2 You could try PROC EXPORT instead of the datastep... it should work to export a comma-delimited file. But Mike's suggestion will work well, and might be more flexible for you - and is not dissimilar to what PROC EXPORT actually physically does, I suspect. -Joe On Tue, Feb 2, 2010 at 3:48 PM, Ranjhana <ranjhanas@gmail.com> wrote: > Hi All, > > I used the following code to export a SAS dataset to text file, but i > am unable to get the header. Can anybody tell me how to get the header > (Variable names) to the text file ? > > Filename out "/home/z19/test_e... Re: SAS/DMS library default library allocations using SAS V8.2 on Minion, I don't know if this will work in your environment, but in Windows you can simply click on the libname, press the delete key, and then verify that you want to delete the libname. After deleting it, it doesn't reappear the next time you start a session. Let us know if that works on OS/390 as well. Art --------- On Dec 30, 11:29 am, Minion <acfar...@gmail.com> wrote: > In an attempt to speed up my ability to use FS Browse on OS/390, I > used the LIB window to define 2 libraries to be assigned at startup. > Now I cannot get rid of them and I am a... Re: SAS/DMS library default library allocations using SAS V8.2 on #2 The library allocations have to be stored <somewhere>, otherwise you wouldn't continue to get the prompt. You can look under your userid to see if it's there (though I suspect you've already done that), but a better question would be directed at the SAS sysadmin--ask them where these profiles/customizations are stored (the sasuser.profile is the generic one--your personal one is concatenated along with it). You may be able to see your session info under your userid tso log (shows usage information), though off the top of my head I can't remember if it captures allocatio... use data set DATA SSK; INFILE CARDS TRUNCOVER ; INPUT A$1-3 S $4-6 D$7-9 F \$10-12; CARDS; QW 12 14 11 ER 2 GD 35 12 ; RUN; I WANT TO CHANGE CHARECTER VARIABLE S,D,F TO NUMERIC VARIABLE AND SUM OF S,D,F onlu use data step please help me .. I.E I WANT OUTPUT LOOK LIKE IS A S D F 47 14 25 AND TO FIND PERENATGE ALSO I.E S--VARAIBLE DEIVIDEDED BY 10 I.E 47/10*100 D--VARAIBLE DEIVIDEDED BY 13 I.E 14/13*100 F--VARAIBLE DEIVIDEDED BY 17 I.E 25/17*100 FINALLY I WANT OUTPUT LIKE AS A S D F 47( %) 14(%) 25( %)-sum QW 12 14 11 ER ...

Which data structure to use ?
There is some old code lying there which I am working on. The Data Structure has these 4 operations (currently it is implemented as a Queue, singly linked list): (1) Add an element. (2) Remove an element using a specific key (3) iterate over all elements and do some work. (4) Insertion and removal are same in number of operations. e.g. If 5 elements were inserted then 5 (same) will be removed too. (5) iteration happens all the time, way more than the amount of insertion/removal. Queue was used because Insertion was O(1), iteration has nothing to do with Big O here in our case as we...

Unable to use BibTex
Till now I have been writting Bibliography by maintaining databse in the same .tex file, like mentioned below . \begin{thebibliography}{} \bibitem{basic} Paul G. Flikkema Digital Down Conversion (DDC) Theory'' \emph{www.hunteng.co.uk} \end{thebibliography} Now, I want to make a bibliography and want to make entry like this as mentioned in book by peter : @book{fg, title = {{An Innkeeper.s Diary}}, author = {John Fothergill}, edition = {3rd}, publisher = {Penguin}, year = 1929, address = {London} } How do I make a .bib file to make entry as mentioned above ? Is the style ...

Unable to use package...why ???
Hello , I'm new to Java and tried the following. First I created the file : Getbcard.java inside the directory : C:\myclasses\exam\test\dok below is the script : package exam.test.dok; public class Getbcard { public void setname() { System.out.println("Hello"); } } then , I compiled it using this command line: javac Getbcard.java and got the appropriated .class file: Getbcard.class Next , I created a new file , named : Showbcard.java in folder : C: \examples below is the script : import exam.test.dok.*; public class Showbcard { public static void main(String[] args) { System.o...

data table using