f



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
0
5/30/2008 9:16:47 AM
comp.soft-sys.sas 142827 articles. 3 followers. Post Follow

0 Replies
497 Views

Similar Articles

[PageSpeed] 9

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 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: 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: 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: 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: 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: SAS/Access for Teradata #4
Thanks Bob for your message. While we are not using UNIX, your reply prompted me to go back and request that our server support person use BTEQ, had to be installed, to test connection and not the software that was initially used. (Turns out the previous test was using OBDC not native teradata drivers) Short anwswer to long story.. BTEQ failed. While the answer was truly a teradata issue (not SAS) I'm posting the solution so that others may learn and not get trapped in the middle (SAS versus teradata). Solution: This problem is being addressed by DR 103605. No code fix is currently available. To correct the problem, must manually clean out remnants of prior CLI installations. **** assumes %SYSTEMROOT% is C:\Windows\System32 1) delete shared .dll files that are no longer used in TTU 8.1. Delete these files if present: C:\Windows\System32\wincli32.dll C:\Windows\System32\tdusr32.dll C:\Windows\System32\tdgss.dll C:\Windows\System32\localisation.dll 2) If TTU 8.1 version of ODBC is installed, then need to ensure that C:\Windows\System32\terasso.dll is version 4.8.1.x This file is needed by Teradata ODBC and needs to match up with CLIv2's terasso.dll This also means that you cannot mix TTU versions of ODBC and CLIv2, ODBC and CLIv2 must both be TTU 8.1 versions. 3) Clear out unneeded windows registry key values. Note: this step is not mandatory but should be done for the sake of completeness. Delete these entries from the windows registry. Start->Run->Reged...

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: 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: 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-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: 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. W...

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: 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: 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: 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...

Re: Difference Between PC SAS and UNIX SAS but getting off topic #3
Mary I was at NCSU and left in 1973. One of the young stat profs, Ron Gallant, if memory serves, came up with the Ames story. And I, too, do not recall the days of punched cards at all fondly. 1) you had to wait for a job to be read in. 2) cards became damaged on the edges from wear and had to be replaced regularly 3) you could drop the deck and scramble it. There were ways around this but they were imperfect 4) I had one experience with a new card reader which, upon encountering a damaged card, made you think that it was a different card that was the problem and one or more of your cards from that was read through the reader was/were never seen by the system. 5) try inserting new characters between columns on a punch card. There are more of these but I would rather not remember them. Nat vironmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 Mary <mlhoward@AVALON. NET> To Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU Discussion" cc <SAS-L@LISTSERV.U GA.EDU> Subject Re: Difference Between PC SAS and UNIX SAS but getting off topic 06/...

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...

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

Teradata - Wikipedia, the free encyclopedia
This article reads like a news release , or is otherwise written in an overly promotional tone. Please help by either rewriting this article ...

Teradata (@Teradata) on Twitter
Log in Sign up You are on Twitter Mobile because you are using an old version of Internet Explorer. Learn more here Teradata @ Teradata Teradata ...

teradata - YouTube
Teradata is a leading provider of powerful, enterprise analytic technologies and services that include Data Warehousing, Business Intelligence ...

Blasting Past Data-Driven Roadblocks: Speaking With Teradata Applications CMO Lisa Arthur
While most marketers today understand why they need to establish data-driven marketing strategies, the big question for most is how exactly to ...

Teradata Drops 10%: Year View Disappoints; Hadoop in Focus
Shares of big data and analytics tech company Teradata (TDC) are down $4.39, or 10%, at $39.58, after the company this morning reported Q1 revenue ...

Turbid Days for Teradata
Sterne Agee downgraded the analytics firm to Neutral from Buy. Teradata (TDC: NYSE) By Sterne, Agee & Leach ($52.58, Oct. 15, 2013) We are downgrading ...

UPDATE: Goldman Sachs Downgrades Teradata Corporation as Weak Spending Pushes Growth Out Again
In a report published Tuesday, Goldman Sachs analyst Greg Dunham downgraded the rating on Teradata Corporation (NYSE: TDC) from Conviction List-Buy ...

Teradata releases the power of IoT data
... Extracting value from that data and gaining useful business insights from it though is a complex process. Big data applications company Teradata ...

Teradata marketing exec lands on national Top 10 list
Teradata marketing exec lands on national Top 10 list

Teradata's Rolodex May Lure Cisco to HP: Real M&A
Teradata's Rolodex May Lure Cisco to HP: Real M&A Bloomberg Teradata Corp. (TDC) could take a cue from dealmaking customers Comcast Corp. and ...

Resources last updated: 3/17/2016 5:31:50 AM