f



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.
>
0
6/15/2008 2:16:21 PM
comp.soft-sys.sas 142827 articles. 3 followers. Post Follow

0 Replies
698 Views

Similar Articles

[PageSpeed] 21

Reply:

Similar Artilces:

Re: What r the data types in SAS? in Base SAS , and SAS SQL
> From: Amar Mundankar > Sent: Tuesday, July 21, 2009 8:10 AM > To: sas-l@uga.edu > Subject: What r the data types in SAS? in Base SAS , and SAS SQL > > Hi all, > What are the different data types in Base SAS and SAS SQL?? character, lengths from 1 to 32,000+ numeric: lengths from 2 to 8 dates are a subtype of numeric and are identified by their date, datetime, or time formats the new proc TSPL (Table Server Processing Language) supports ANSI data types: bigint, tinyint, etc. http://support.sas.com/documentation/cdl/en/tsag/30878/HTML/default/a003 065339.htm http://s...

Re: Opening a SAS catalog entry without SAS
Dear Jessica, Yes, the from www.sas.com freely available and distributable SAS system viewer program, vs. 8.02 can show and print vs. 6.12 catalogs. That is something, but not enough of course. And I don't understand that discrepancy, as the vs. 6.12 SASview already could do that too. Of course the vs. 8.02 can read vs. 8.02 (actually vs. 7) SAS datasets. It allows them to be printed or saved as text or comma delimited files. The database conversion program DBMS/copy may read and convert (format) catalogs as well, but I am not sure about that. I don't know about SAS LE, but I assume...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year.
I took the advanced exam this April because I wanted a relatively systematic way of assessing my knowledge of SAS in a short time span. For that purpose, it was worth it. Since I learn SAS by doing new tasks, or re-doing old tasks in a new way, I assume my knowledge of SAS is uneven, even though I am regarded as productive, and frequently creative in using SAS to solve our group's problems. I passed the test, with lower subscores on the components that I expected to be weakest on. I thought many of the questions made me think about some fundamental, sometimes subtle, features of the lan...

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 Advanced Programming Exam for SAS 9: SAS Joke of the year. #10
I actually think you are straight-jacketing the interview for a senior person. I would definitely look for someone who thought outside of the box. That may be ways of doing things other than macros or ODS or else putting a new spin on them. I ditched most of the macro language a decade ago, for example. As a hiring manager, I always went for creativity and not specific skills on hand and was very pleased with my hires. But hey, I don't hire anymore so it isn't something I have to face. BTW, no client has ever asked me for certification nor have I been quizzed on specific SAS knowledg...

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: R vs. SAS (was Replacement for SAS (SPSS vs. SAS, redux)) #5
I think that SAS and R are very similar, even though their designs are very different. What matters is that both can be used to accomplish the same things - just as English and Swahilli serve the same purpose (communication) equally well. As for the copyleft "mess", do you really believe the propaganda and outright lies perpetrated by some companies? Remember, they want you to pay $$$ for your software, and copyleft poses a huge threat to that goal. -----Original Message----- From: Peter Flom [mailto:flom@NDRI.ORG] Sent: Thursday, February 05, 2004 12:57 PM To: SAS-L@LISTSERV.UGA....

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #11
Kevin, Thank you for the nice words...I am sure I wouldn't have a chance on any stat exam, BTW. What I am good at is being in an absolute crisis and trying to get it solved with no time on the clock. That is why I think in a quirky manner. When the obvious isn't working, take a different path because there is simply no time left. It's what I did at MCI, SAS, and now as an independent. ....and that skill will not be measured on a certification exam or plopping me in front of a PC to hammer out an example SAS program. For any candidate, I can pick up their technical level with a few questions and watching their reactions. Alan Alan Churchill Savian www.savian.net -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Kevin Roland Viel Sent: Tuesday, September 04, 2007 4:02 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. On Tue, 4 Sep 2007, Alan Churchill wrote: > It seems that a test like this would toss me out of the pool from the > get-go. Heck, maybe that's what the goal would be ;-] Well then, maybe the rest of us might have a chance then :) Given that I have not used SAS regularly in months, I would be hurting. Hopefully, I would not be tossed immediately either. Isn't one point of the test to allow a organization to call itself a partner or some other distinction? Maybe to be listed among companies on SI's websites? Kevin Kevin ...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #7
Well Toby, let me ask something then. Since I am not an ODS fan and haven't used proc report/tabulate for some time, would that be an automatic disqualifier since you don't allow reference books or materials? SAS does not provide tools that help me code ODS (except for EG) and therefore a reference material is all I would need. Now, it's not like I haven't used proc report (used it extensively at one time), it's just that I prefer other means to produce the final output. It seems that a test like this would toss me out of the pool from the get-go. Heck, maybe that's wh...

Re: R vs. SAS (was Replacement for SAS (SPSS vs. SAS, redux)) #2
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 and R; I"ve used SAS for 10 or 15 years, R for about 6 >months - 1 year. > >Each has strengths and weaknesses; I'd not like to give up either. > >Strengths of SAS (esp. compared to R) > >Tech support - I have SAS tech support's phone number and our license >number memorized. They're great. > >SAS-L - There's also an R-help list...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #4
Ed , I still contend and stick with they should both be able to program and know how SAS works. I prefer the intervewing company give a test, were the person being interviewed is sat in front a laptop or desktop and told to write code to solve some problems. No online help no books just the persona nd the computer. This weeds out those who can code and those who cant, from those who can you then talk to them about the code they wrote and you can deduce those who understand how SAS works and thos who dont. The pool you are left with are the qualified candidates atleast from a SAS perspecti...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #8
On Tue, 4 Sep 2007, Alan Churchill wrote: > It seems that a test like this would toss me out of the pool from the > get-go. Heck, maybe that's what the goal would be ;-] Well then, maybe the rest of us might have a chance then :) Given that I have not used SAS regularly in months, I would be hurting. Hopefully, I would not be tossed immediately either. Isn't one point of the test to allow a organization to call itself a partner or some other distinction? Maybe to be listed among companies on SI's websites? Kevin Kevin Viel, PhD Post-doctoral fellow Department of Geneti...

Re: R vs. SAS (was Replacement for SAS (SPSS vs. SAS, redux)) #4
No, sorry if I made it sound that way..... SAS and R are totally different in the way they work, how they are structured, what the statements look like, and so on. Not like French and Spanish, not even like English and Spanish. More like English and Swahilli. R has a lot in common with S Plus, both are based on the S language. But there is no hostility that I know of between S Plus and R (unlike the situation with Linux) Peter >>> <ben.powell@CLA.CO.UK> 2/5/2004 10:36:32 AM >>> wrote Sounds like R is the SAS equivalent of Linux .. who are incidentally in all sort...

Re: SAS/ACCESS
Does the DBMAX_TEXT option do what you want? http://support.sas.com/onlinedoc/913/getDoc/en/acreldb.hlp/a003113591.htm -- Jack Hamilton jfh@alumni.stanford.org Videtis illam spirare libertatis auram On Jan 22, 2009, at 8:57 am, Matthew Pettis wrote: > Hi, > > > > I have a CLOB coming back from an Oracle passthrough query that is > >1024 > in length. How do I specify that my receiving variable in a SAS > dataset > be longer than 1024 characters to accommodate this? By default, I get > SAS thinking that this is 1024 characters, when it is really a CLOB > and > I want to set some large default length on this variable length... > > > > Thanks, > Matt ...

Re: Reading & Writing SAS data sets without SAS #3
Chang, You're correct in that a number of companies have done it. I believe SPSS can do it, WPS, Stat Transfer, dbmscopy, and perhaps others have also done it. But what I think is unique about this is that Alan is talking about offering plug-ins so you can roll-your-own so to speak. How cool would it be to have some type of driver/plugin for R? Phil Philip Rack MineQuest, LLC SAS & WPS Consulting and WPS Reseller Tel: (614) 457-3714 Web: www.MineQuest.com Blog: www.MineQuest.com/WordPress -----Original Message----- From: Chang Chung [mailto:chang_y_chung@HOTMAIL.COM] Sent: Monday...

Re: SAS/ACCESS
DBMAX_TEXT does the trick; thank you all who helped! Matt -----Original Message----- From: Jack Hamilton [mailto:jfh@stanfordalumni.org] Sent: Sat 1/24/2009 1:42 AM To: Pettis, Matthew (Prof II&RS) Cc: SAS-L@LISTSERV.UGA.EDU Subject: Re: [SAS-L] SAS/ACCESS - Oracle: setting field lengths in SAS datasets returned from passthrough Does the DBMAX_TEXT option do what you want? http://support.sas.com/onlinedoc/913/getDoc/en/acreldb.hlp/a003113591.htm -- Jack Hamilton jfh@alumni.stanford.org Videtis illam spirare libertatis auram On Jan 22, 2009, at 8:57 am, Matthew Pettis wrote: > Hi, > > > > I have a CLOB coming back from an Oracle passthrough query that is > >1024 > in length. How do I specify that my receiving variable in a SAS > dataset > be longer than 1024 characters to accommodate this? By default, I get > SAS thinking that this is 1024 characters, when it is really a CLOB > and > I want to set some large default length on this variable length... > > > > Thanks, > Matt ...

SAS CONNECT/SAS Display Manager or BASE SAS
Hi, We have SAS EBI Server license. Many or our SAS Programmer wants to use BASE SAS (or SAS Display Manager) instead of SAS Enterprise Guide. But As you know Windows Server comes with only two terminal licenses. I see that we have SAS/CONNECT license (which came with BI suite). Can I install BASE SAS on PC and use SAS/CONNECT to run code on the server? Or Do we have to buy PC license for BASE SAS? What's options we have. Please help. Thanks On Oct 21, 8:11=A0am, abcu...@YAHOO.COM (Abc Unha) wrote: > Hi, > We have SAS EBI Server license. Many or our SAS Programmer wants to =A0us...

Re: Exit SAS gracefully / Condtional execution of code without SAS macro #2
I recall hearing an explanation of why %IF can't be made to work in open code, but I can't remember exactly what it is. Anyone else remember? It would cause an incompatibility or ambiguity of some kind, I think. It's not too hard to ignore only a single statement in open code: ===== SAS v9 %let go = 1; data _null_; %sysfunc(ifc(&GO., put 'go was true', put 'go was false', put 'go was missing')); run; %let go = 0; data _null_; %sysfunc(ifc(&GO., put 'go was true', put 'go was false', put 'go was missing')); run;...

how to add fonts to the sas registry (was RE: Re: sas/graph:
Success! A google search led me to: http://support.sas.com/documentation/onlinedoc/base/91/freetype-hub.pdf Which includes the magic option on FONTREG to use the "all" mode. (And now that I look back on the FONTREG docs, I see it there was well :-P). So here's code that works: * =================================== ; proc fontreg mode = all msglevel = verbose ; truetype 'c:\windows\fonts' ; run ; data phoney ; do n = 1 to 2000 ; x = ranuni(-1) ; if n le 1000 then grp = "one" ; else grp = "two" ; output ; end ; run ; gopti...

Re: Exit SAS gracefully / Condtional execution of code without SAS macro #3
> From: Jack Hamilton > I recall hearing an explanation of why %IF can't be made to > work in open code, for my macro kludge ifthenelse check our most excellent archives: http://www.listserv.uga.edu/archives/sas-l.html search for: ifthenelse substring search: [X] subject contains: author's address: RJF2 since: Jul 2004 until: Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov FAQ: How to use SAS-L http://www2.sas.com/proceedings/sugi29/247-29.pdf ...

Re: Exit SAS gracefully / Condtional execution of code without SAS macro #8
Where did you find that? It's not in the online documentation of macro statements at <http://v9doc.sas.com/cgi-bin/sasdoc/cgigdoc?file=../mcrolref.hlp/a002047076.htm> It is, however, in the list of reserved words. -- JackHamilton@FirstHealth.com Manager, Technical Development Metrics Department, First Health West Sacramento, California USA Coelum, non animum mutant, qui trans mare currunt. >>> "toby dunn" <tobydunn@hotmail.com> 01/07/2005 2:35 PM >>> Jack, Here is what is in the v9.1.3 online docs: %ABORT Statement --------------------...

Re: Exit SAS gracefully / Condtional execution of code without SAS macro #4
True, using the abort statement doesn't always end the session, but it also doesn't always stop execution of subsequent code, which is the goal. The original problem was "Ideally, I'd like SAS to stop processing subsequent statements but I can't find any code that will stop SAS elegantly without it closing down the whole "SAS System" (such as ABORT)." As far as I know, that's correct - there's no SAS statement which means "ignore the rest of the input but don't shut down". %IF in open code really would be a nice solution (though not...

Re: SAS 9 and SAS 8
I suggest that you look at the SAS web site http://support.sas.com/documentation/whatsnew/index.html Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 pausha <pausha1@GMAIL.CO M> To Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU Discussion" cc <SAS-L@LISTSERV.U GA.EDU> Subject SAS 9 and SAS 8 11/20/2008 03:28 PM Please respond to pausha <pausha1@GMAIL.CO M> Could someone send me the papers or articles that gives the differences between sas 8 and sas 9 and new function and changes in sas 9. Thanks CONFIDENTIALITY NOTICE: This electronic message contains information which may be legally confidential and/or privileged and does not in any case represent a firm ENERGY COMMODITY bid or offer relating thereto which binds the sender without an additional express written confirmation to that effect. The information is intended solely for the individual or entity named above and access by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copyi...

Re: To SAS or not To SAS (or whatever else)!!,
OK, I'll be the first to bite here. First, check out our most excellent archives. There have been many, many discussions on the merits of sas versus anything from spss to sql server analytics to oracle to you name it. You might need to get creative in your search, like sas AND advantage or sas AND oracle and (obviously) sas AND spss. I've used a good many of the analytical tools out there, including many years with both sas and spss, and I can tell you from first hand knowledge, nothing even comes close to sas with regard to flexibility of the tool. You can do pretty much anything ...

Re: SAS and SAS/IML TO C
ricardosilva@SERASA.COM.BR wrote: > >Dear Users, > >There's some way to convert SAS and/or SAS/IML codes to C code? > >Thanks, > >Ricardo=20 Sure there is. Umm, unless you didn't want to spend a bunch of person-months writing the code by hand, and then a bunch of person-years validating and debugging all that code. If all you want is something simple, like a sort, or a sum of constants times your varables, then you can do that in any decent language. If you want any kind of generality, you are stuck. Let's say you want some subset of PROC MIXED in C. W...

Web resources about - Re: Q: SAS -> MySQL without SAS/ACCESS - comp.soft-sys.sas

North Carolina Deputies Suspended for ‘Failures to Act’ During Trump Rally Violence
A group of sheriff’s deputies in North Carolina have been suspended after a Donald Trump rally where a protester was punched after being escorted ...

German court rules against Apple in patent suit with OpenTV over streaming technologies
Reuters reports this evening that a German court has ruled against Apple in a case centered around video streaming patents owned by OpenTV. Kudelski’s ...

Twitch users decided my fate in a VR game built on Amazon Lumberyard
Hidden away on the exhibition floor at the Game Developers Conference in San Francisco today, I found a short line next to the big booth for ...

Obama slaps new sanctions on North Korea after tests
By Joel Schectman and Yeganeh Torbati WASHINGTON (Reuters) - President Barack Obama imposed sweeping new sanctions on North Korea on Wednesday ...

Black Maryland Cop Killed By Fellow Officer Who Thought He Was Shootout Suspect
Jacai Colson, a Prince George’s County (Mary.) cop, was killed over the weekend by friendly fire during a shootout outside PGC police headquarters. ...

Which Xbox 360 Games Are Free This Week On Xbox Live? Which Games They Are, And How To Get Them
If you’re an Xbox Live member, you already know that Microsoft gives free Xbox games away to members every week. The Xbox games vary week to ...

Hacker who stole celebrities' nude photos will plead guilty
CNET Hacker who stole celebrities' nude photos will plead guilty CNET A hacker who accessed accounts of actress Jennifer Lawrence, pictured ...

5 things we learned from Janet Yellen about Fed rate hikes and the U.S. economy
Federal Reserve policymakers said the U.S. economy is strong enough to handle increases in a key interest rate this year, but they have scaled ...

Watch: DC Metro System Shut Down by Emergency Inspections
Thousands in the Capitol scramble to commute without the trains.

Google Adds Metronome Card To Search
Want to find out the answer to a calculation but you’re too lazy to type it yourself? You can just paste in the formula and Google will be able ...

Resources last updated: 3/17/2016 1:17:30 AM