f



Re: SAS/Access Opinions #3

Ken,

Use OleDb. There is no Access to SQL Server for Windows and ODBC is your
only option. Speed-wise, they are about the same but OleDb is more modern
and you will find less issues with it.

Alan

Alan Churchill
Savian
www.savian.net



-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Ken
Barz
Sent: Friday, April 25, 2008 10:41 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: SAS/Access Opinions

It looks like we're finally going to leap into the 20th century (21st
maybe some day) and get the ability to have our SAS connect to a
real-live database.  We know we're going to connect to a SQL Server
database.  However, we're making another purchase that may wind up
sitting on Oracle.  I've worked before with the ODBC SAS/Access product
so I have a feel for that.  Does anyone have an opinion on the value of
that versus the OLEDB version versus the database specific varieties?
We're a Windows shop and one of the SQL Server databases we'll actually
have to hit across the internet if that makes a difference.

Thanks,

Ken
0
savian001 (795)
4/25/2008 9:50:47 PM
comp.soft-sys.sas 142827 articles. 3 followers. Post Follow

0 Replies
384 Views

Similar Articles

[PageSpeed] 15

Reply:

Similar Artilces:

Re: R vs. SAS (was Replacement for SAS (SPSS vs. SAS, redux)) #3
Wow, that was a leap. Better not use Apache or PHP then. Andy >-----Original Message----- >From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On >Behalf Of ben.powell@CLA.CO.UK >Sent: Thursday, February 05, 2004 10:37 AM >To: SAS-L@LISTSERV.UGA.EDU >Subject: Re: R vs. SAS (was Replacement for SAS (SPSS vs. SAS, redux)) > >Sounds like R is the SAS equivalent of Linux .. who are >incidentally in all >sorts of a copy left/right mess at the moment. > >On Thu, 5 Feb 2004 09:39:37 -0500, Peter Flom <flom@NDRI.ORG> wrote: > >>I use both SAS a...

Re: SAS Sample 1728 Was ---> Re: SAS Sample 1727 #3
First, let me admit/acknowledge that I have no knowledge of the history of this thread. Been tied up catching up post SAS Global Forum and post the announcement of sasCommunity.org. But I would like to offer some thoughts regarding Toby's comment: > No as for the sascommunity.org, do we really want a macro library. Well I > would say yes and no. I would like to have one and there are those who > have > paced some Macros on there already. I believe Don and Ron both have, > actually they were on there before the Wiki went public. However, since > people tend to get Ma...

Re: SAS System Viewer 9.1 unable to open SAS datasets ( SAS 9.1.3)
A question in return: is your table from windows? compressed from another system? and specially with personnel formats hard coded inside? Andre msiddu2000 a �crit : > SAS System Viewer 9.1 was able to open datasets that were created by > V8 engine (SAS 8.2), but is unable to open datasets that are created > with V9 engine (SAS 9.1.3). > > Does this need SAS System Viewer to be upgraded ? > or > Something else needs to be done ? > > -- Andr� WIELKI INED (Institut National d'Etudes D�mographiques) Service Informatique 133 Boulevard Davout 75980 Paris Cedex 20 m�l : wielki@ined.fr t�l : 33 (0) 1 56 06 21 54 ...

Re: SAS/Access Opinions
Ken, we've used SAS Access to ODBC for, gosh, 15 years now, both to SQL Server and to Oracle, and have had absolutely no problems, either for local or remote databases accessed over the internet. (Parenthetically, we have, on rare occasions, tried to use the pass thru facility to send SQL Server specific commands to the server, and ODBC seemed to have a problem with it, but, it's rare, and right now, I can't even remember what the problems were). Having said that, ODBC is pretty old and OLE DB is considered the more modern way to go, at least for Windows shops. There is one practical difference (as far as SAS is concerned) that weighs in favor of OLE DB: for ODBC, you need to have an ODBC data source set up for each database you want to access *on each workstation*. For OLE DB, the connection string is contained right in your SAS statement, so you don't need to go around to each workstation whenever you create a new database. The only reason we haven't upgraded to OLE DB is because ODBC is part of our bundle, and the OLE DB license would cost us a bundle. HTH, Karl On Fri, 25 Apr 2008 10:41:12 -0600, Ken Barz <Ken.Barz@CPCMED.ORG> wrote: >It looks like we're finally going to leap into the 20th century (21st >maybe some day) and get the ability to have our SAS connect to a >real-live database. We know we're going to connect to a SQL Server >database. However, we're making another purchase that may wind up >sitting on ...

Re: Deleting SAS Data from a SAS DATASET #3
The disadvantages of using SQL delete are (1) NOBS= is no longer accurate, and (2) POINT= may behave unexpectedly. If those are not issues, then the delete would be faster, with or without an index, than recreating the data set (especially if the data set has indexes that would need to be rebuilt). -- Jack Hamilton jfh@alumni.stanford.org On Aug 15, 2008, at 11:17 am, Mary wrote: > One thing you might do is to add an index on the snap_dt to the > dataset; if that's there then you should be able to delete the > records in place: > > proc sql; > delete from prod.master_date; > where snap_dt = "&end_dt"d; > quit; > run; > > In both the ways you are trying now you are creating new data sets > rather than deleting records from the current data set; it would > seem to me that a SQL delete statement would be faster than creating > new datasets even if there isn't an index on the date. > > -Mary > ----- Original Message ----- > From: SUBSCRIBE SAS-L Chandra Gadde > To: SAS-L@LISTSERV.UGA.EDU > Sent: Friday, August 15, 2008 12:14 PM > Subject: Deleting SAS Data from a SAS DATASET > > > Hi All > > I have several SAS datasets that are very very big. (50GB of size). > Every > month, the data is being appended to these datasets. I need to > deleted the > data which is greater than 24 months. What is the best method to do > this? > Please help me. > ...

Re: Difference Between PC SAS and UNIX SAS #3
On Fri, 6 Jun 2008 05:51:32 -0700, Lou <lpogoda@HOTMAIL.COM> wrote: >On Jun 5, 11:50 pm, PaulOK <nancynpaul-s...@yahoo.com> wrote: >> On Jun 5, 5:53 pm, "Lou" <lpog...@verizon.net> wrote: >> .... >> >> > In my limited experience, there are minor programming differences - you use >> > a forward slash instead of a backward slash in path names for example, >> >> .... >> Actually one can use either forward or backward slashes in Windows SAS >> programs. > >Yes one can use either in SAS for Windows, but not in SAS for Unix > >> >> libname datalib "c:/data/project/work"; >> >> works exactly the same as >> >> libname datalib "c:\data\project\work"; >> >> .... >> >> > Lastly, the documentation for SAS on Unix is riddled with misinformation and >> > in some cases is flatly wrong - obviously copied from some other platform >> > (probably Windows) and not checked for accuracy or applicability. >> >> Could you provide a specific example where the UNIX SAS documentations >> is 'flatly wrong'. > > >I'm not currently working in a place that has a unix environment, so >this is from memory. Where I was working a couple of years ago, the >company had made the decision to go to SAS on Unix, bought a shiny new >server, installed SAS, etc. I was par...

Re: SAS vs. SPLUS vs. SAS #3
I don't know much about trials work, but it has been discussed on the r-help list, and there are definitely people who use R for this type of thing Peter -----Original Message----- >From: Paul Miller <pjmiller_57@YAHOO.COM> >Sent: Dec 11, 2009 4:09 PM >To: SAS-L@LISTSERV.UGA.EDU >Subject: SAS vs. SPLUS vs. SAS > >Hello Everyone, >� >I’ve recently become interested in sequential clinical trials designs. I’ve purchased a book that discusses the topic called “Analysis of Clinical Trials using SAS: A Practical Guide.” Upon trying to run some of the ...

Re: SAS -> MySQL without SAS/ACCESS
XML, OleDb driver for SAS (free), ODBC driver from SAS (free). SAS/Access is only required to get data from a source, not the other way around. Alan Alan Churchill Savian www.savian.net -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of RolandRB Sent: Friday, June 13, 2008 1:50 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Q: SAS -> MySQL without SAS/ACCESS What is the easiest and neatest way to get a sas data set into MySQL without using SAS/ACCESS? I am hoping there are some useful URLs for this. ...

Re: SAS code beautifier or SAS Tidy #3
Yes indeed. I gave Alan the worst code (authors shall remain anonymous to protect the guilty, but the project involved Mortgage Banking services...) I have seen in over two decade of looking at SAS code, and his utility cleaned it right up. On Wed, Jun 10, 2009 at 4:30 PM, Richard Read Allen <peakstat@wispertel.net>wrote: > Try www.savian.net. I think Alan Churchill may have developed some > utilities > that may be able to help you. > > -Richard > > -----Original Message----- > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Mary > Sent: ...

Re: Invoking SAS from non SAS environment! #3
Ankit, If performance is an issue then definitely go with a web service based approach. Web services offer synchronous and asynchronous communication. Since web services communicate over port 80, they are secure and they are as fast as your internet connection. Using older stuff such as ftp and telnet are going to be slower not to mention a lot more cumbersome. Also, going down these older paths can work but it will be a hacked up solution and may not be supported by the IT dept over time? Why? Open ports outside of 80 are security issues. Hence, why web services are so important. However, i...

Re: SAS AF application is not supported in SAS EG? #3
Then you might not know what fun you're missing :)) On Wed, Oct 28, 2009 at 7:50 PM, Savian <savian.net@gmail.com> wrote: > On Oct 28, 11:41 am, UKR <nlk...@gmail.com> wrote: > > Thank you for your comments. > > I will investigate Silverlight and oleDB technologies as well as costs > > associated with keeping single SAS PC license. > > In any case how SAS Institute could abandon AF so easily, if favor to > > which kind of technology? What solutions does SAS Institute provide to > > support GUI programs on windows server? Does anybody ha...

Re: SAS/Access Opinions #2
Hi All, Karl has some good comments. I can offer one slight tweak in that while going to each workstation and setting an ODBC token map is commonly done. For SAS programs it isn't always necessary, you can put it in your SAS string on-the-fly. e.g. locate NOPROMPT in the example archive posts: http://listserv.uga.edu/cgi-bin/wa?A2=ind0710B&L=sas-l&P=R39045 Hope this is helpful. Mark Terjeson Senior Programmer Analyst Investment Management & Research Russell Investments Russell Investments Global Leaders in Multi-Manager Investing -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of KarlK Sent: Friday, April 25, 2008 10:38 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: SAS/Access Opinions Ken, we've used SAS Access to ODBC for, gosh, 15 years now, both to SQL Server and to Oracle, and have had absolutely no problems, either for local or remote databases accessed over the internet. (Parenthetically, we have, on rare occasions, tried to use the pass thru facility to send SQL Server specific commands to the server, and ODBC seemed to have a problem with it, but, it's rare, and right now, I can't even remember what the problems were). Having said that, ODBC is pretty old and OLE DB is considered the more modern way to go, at least for Windows shops. There is one practical difference (as far as SAS is concerned) that weighs in favor of OLE DB: for ODBC, you need to have an ODBC data source set up f...

Re: Using SAS with large datasets (linking SAS and Access)
I have very little experience with using this but I have found that if you have SAS Access for PC Products licensed, just as you can issue a libname statement pointing to an Excel workbook, you can also issue one for an Access database. Try doing this and then look at your SAS explorer window where you will see an icon for the Access file and will then be able to look at the Access tables as if they were SAS data sets. Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 ben.powell@CLA.CO .UK Sent by: "SAS(r) To Discussion" SAS-L@LISTSERV.UGA.EDU <SAS-L@LISTSERV.U cc GA.EDU> Subject Re: Using SAS with large datasets 06/23/2008 06:01 AM Please respond to ben.powell@CLA.CO .UK If you haven't already, export the data out of Access asap as mdb operations tend to be several orders of magnitude slower than SAS. Export to tab or csv and import into SAS. The export procedure from Access is relatively painless. If you've already done that and are still facing problems you should provide more info on variabl...

Re: SAS/Access for Teradata #3
On Thu, 29 May 2008 16:51:34 -0400, Linda Pavlish <lap7858@YAHOO.COM> wrote: >We have recently upgraded to Teradata V2R6 and no longer am able to use the >SAS/Access for Teradata drivers. (SAS 9.1.3 SP4). Basically, when you >issue the libname statement > libname xxxx Teradata tpdid = xxx schema = xxxx user=xxxx > password= xxxx; > >the SAS session will hang. (It continues to clock until we kill the >session). We have had this tracked with Tech support for over a month with >no useful solution yet so I'm desparately hoping someone else has >experience and solved this problem. > >Any and all suggestions are welcomed. > >Thanks No experience with Teradata, but an idea: maybe you could SAS ask for a 9.2 installation to test it with that? Another thing: ask them to increase the priority for that problem! Tell them, that you have a serious production problem, maybe that motivies them to work faster... Gerhard ...

Re: SAS-Related Friday Gift For All SAS-Lers #3
Correction, the Book address for your Browser (as opposed to an FTP tool) is http://www.warpraptor.com/x/ On Fri, Jul 24, 2009 at 8:32 PM, Joe Whitehurst <joewhitehurst@gmail.com>wrote: > One more tip about the Book: *Seafood, Pictures, Facts, and Nutrition > Information; you don't have to download the whole book to browse its > pages. Just point your Browser at: www.warpraptor.com and navigate to * > *AtlantaFishMarketBookTable_Of_Contents.pdf. Open this document and use > the Table of Contents found there (starting on page 3) to access all the > sections by c...

Re: Q: SAS -> MySQL without SAS/ACCESS
If the dataset is not huge, then converting the database table into a CSV file may be the way to go. MYSQL's own CSV read/write facility is extremely efficient (or was when I used it three years ago). On Fri, Jun 13, 2008 at 3:50 PM, RolandRB <rolandberry@hotmail.com> wrote: > What is the easiest and neatest way to get a sas data set into MySQL > without using SAS/ACCESS? I am hoping there are some useful URLs for > this. > ...

Re: old SAS guy with new SAS question #3
On Sun, 16 Nov 2008 20:33:21 -0800, Daniel Nordlund <djnordlund@VERIZON.NET> wrote: >> -----Original Message----- >> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On >> Behalf Of John F. Regus >> Sent: Sunday, November 16, 2008 7:19 PM >> To: SAS-L@LISTSERV.UGA.EDU >> Subject: old SAS guy with new SAS question >> >> You three were of the most help to an old man in simplifying >> how to get output from my PC file into a SAS dataset. >> However, when I did use the INPUT statement I coded INPUT $. >> thinking this would put everything into its natural place in >> the output SAS table. Wrong. It only got the first variable >> of 5 characters. >> >> I went through my "Little SAS Book" trying to find the answer >> to this but the "Little SAS Book" has an appropriate >> title...it is little and does not cover a lot of things. >> SAS help and documentation takes you over the hills and >> through the woods without getting to the point or even a >> concise answer. >> >> Here is my problem. >> >> I am reading a .csv PC flat file (I conquered the problem of >> reading the PC file into a SAS dataset by adding the INPUT >> statement...only not all the data goes through because I need >> to use columnar input instead of list input). >> >> The layout of the .csv PC flat file is so...

Re: Running a SAS program within a SAS program #3
Kathleen, You can use %INCLUDE in a SAS program to call other SAS programs. Jack Clark Research Analyst Center for Health Program Development and Management University of Maryland, Baltimore County -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Kathleen Santos Sent: Monday, April 21, 2008 12:55 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Running a SAS program within a SAS program Hello, I would like to combine multi years of data into one. Each year has a particular data set and a particular program to create a SAS dataset. However, not all programs are the same (e.g. variable names may change throughout the years). What I would like to do is to create one program that would call on the other programs to create SAS datasets. Then I'll integrate them together and do whatever I it is I need to do. I hope someone can help me. Thanks. Kathleen ...

Re: SAS-L Panel / SAS-L Archives #3
I think, actually, this is one of the great strengths of mailing lists; SAS-L in particular: Mistakes don't survive. If you ask an "expert", he or she may get it wrong. Everyone makes mistakes (except Ian :-). People can also misunderstand questions. But, if you post a question here, and someone posts a wrong response, or if a question is confusing, things get straightened out, usually quickly. Peter >>> "David L. Cassell" <cassell.david@EPAMAIL.EPA.GOV> 12/23/2003 4:29:34 PM >>> Jack Hamilton <JackHamilton@FIRSTHEALTH.COM> replied:...

Re: RE : Re: copulas and SAS #3 674067
joewhitehurst@GMAIL.COM replied: > >Adel, > >You may find the following artilce interesting. [article by Thomas Mikosch not copied] This is a really good article, and a really useful point to make. But 55K is a lot of article to copy. Would it have been easier to point to a URL? The people who read SAS-L as a digest and the people who have slow connections are probably not overly thrilled. I'll refrain from pointing out that you sound like me today. ("Are you sure you want to do this? Here's some material which suggests you should try a different approach..."...

Re: Running sas code on mainframe through SAS-UNIX #3 1556255
I think the easiest solution would be to use the mainframe job scheduler to submit your job in a hold state, looking for a trigger dataset (once the trigger dataset appears, the job is released from hold). You would ftp that dataset up to the mainframe as needed (and since the system is simply looking for the presence of a file, it can be a single line). If you need to pass parameters, you could include them in the trigger file, and have the first step of your mainframe job read the file for the parameters. And, while some of us mainframers learned on a system that used all capital letters,...

Re: Running sas code on mainframe through SAS-UNIX #3 672823
Saket, This is easy. Say your JCL is located in AAA.BBB.CCC(JCL) on the Real Computer. From UNIX, run filename mfjcl ftp "'AAA.BBB.CCC(JCL)'" host = <host name> user = <mf userid> pass = <mf pass> ; filename subjcl ftp "intrdr" rcmd = "site filetype=jes" host = "&host" user = "&user" pass = "&pass" ; data _null_ ; infile mfjcl ; input ; file subjcl ; put _infile_ ; run ; FTP grabs the JCL from the Real Computer, then writes it back but now to the internal reader, thus immediately submitting the job. If at the moment you were in SDSF, you would see the job pop up in the queue (FTP does not interfere with you being logged on the mainframe already). I have just found the method indispensable when I need to operate without logging on the mainframe yet the SAS program needs to mount a tape, rendering SAS/Connect useless (in most installations, the interactive mf session invoked by SAS/Connect, cannot mount tapes). Kind regards ------------ Paul Dorfman Jax, FL ------------ +-----Original Message----- +From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On +Behalf Of saket.kapoor@GMAIL.COM +Sent: Friday, September 15, 2006 1:17 AM +To: SAS-L@LISTSERV.UGA.EDU +Subject: Running sas code on mainframe through SAS-UNIX + + +Hi Friends, + +I have on JCL followed by sas code on MAINFRAME.I need to run this code +from SAS -unix session. + +Please h...

Re: SAS-L BOF at SAS Global Forum 2009 #3
Hi to all, I have enjoyed a great deal with you guys. Thanks for all the fun. Regards, Murphy On Thu, Mar 26, 2009 at 8:49 AM, Arthur Tabachneck <art297@netscape.net>wrote: > My congratulations to DataNull and Joe, as well, both extremely well > deserved. > > And, if you had as much trouble as I did in trying to click on Mike's link > to the analyses, hopefully the following will work better: > > http://www.sascommunity.org/mwiki/images/3/3c/SGF_2009_SAS-L_Stats.ppt > > Art > > p.s. Many, many thanks to Ron Fehd and Art Carpenter for showing me how to > post such links to the wiki. > -------- > On Wed, 25 Mar 2009 16:42:25 -0700, Nordlund, Dan (DSHS/RDA) > <NordlDJ@DSHS.WA.GOV> wrote: > > >Congratulations to data _null_ (Hall of Fame) and Joe Matisse (SASLROY) -- > well deserved. > > > >Dan > > > >Daniel J. Nordlund > >Washington State Department of Social and Health Services > >Planning, Performance, and Accountability > >Research and Data Analysis Division > >Olympia, WA 98504-5204 > > > > > >> -----Original Message----- > >> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of > >> Mike Rhoads > >> Sent: Wednesday, March 25, 2009 3:55 PM > >> To: SAS-L@LISTSERV.UGA.EDU > >> Subject: SAS-L BOF at SAS Global Forum 2009 > >> > >> In short, a good time w...

Re: Can a SAS program call another SAS program #3
Dear SAS-L-ers, David Fickbohm posted the following: > I am writing a report that counts the number of widgets produced by > partners. I have a small routine that finds the partners id > number and > name. Obviously I could copy this code into my program and > execute it. I was wondering if there was a more elegant way > of "Calling" a SAS program > from within a SAS program. I am running SAS 8.1 in windows. > David, there sure is a more elegant way; and a simple one at that! Simply use the %INCLUDE statement. The %INCLUDE statement allows you to in...

Web resources about - Re: SAS/Access Opinions #3 - comp.soft-sys.sas

Opinion - Wikipedia, the free encyclopedia
In general, an opinion is a judgment, viewpoint, or statement about matters commonly considered to be subjective , i.e. based on that which is ...


NHL cutting size of goalie equipment - NHL on CBC Sports - Hockey news, opinion, scores, stats, standings ...
NHL goaltending equipment will be shrinking again soon. Starting next season, goalies will be will wearing equipment better suited to body size ...

Opinion: OK, this is what the 4-inch iPhone SE needs (and doesn’t need) for me to downsize
Apple’s March 21st event is just five days away and we have a comprehensive rundown on what to expect including details on the new 4-inch iPhone ...

Unpopular opinion: the latest, not the greatest Mustang
Filed under: Ford , Coupe , Open Road The latest Mustang may be a technological wonder of a sports car but it has sacrificed some cherished nostalgia ...

OPINION: Conservatives Must Back Ted Cruz - Breitbart
It is time for conservatives to come together to stop Donald Trump. It is time to unify around Sen. Ted Cruz (R-TX).

Wisconsin Supreme Court justice apologizes for anti-gay opinion pieces
Wisconsin Supreme Court Justice Rebecca Bradley on Monday apologized for anti-gay opinion pieces she wrote as a college student 24 years ago, ...

GOP debate: Clinton may regret immigration pledge (Opinion) - CNN.com
Buck Sexton says that in their efforts to court the Latino vote, Sanders and Clinton may have created a vulnerability one of them will come to ...

Court won't reconsider opinion that frees murder suspect
ATLANTA (AP) — Georgia's highest court on Monday declined to reconsider its ruling that says a judge can't set a new trial for a murder suspect, ...

Tomah VA Nurse Writes Opinion Piece Attacking Noted Whistleblower
'I do not know Honl, but he is no hero and his actions have done more harm than good'

Resources last updated: 3/17/2016 7:09:44 AM