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.
>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
>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
> 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?
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 ?
> Something else needs to be done ?
INED (Institut National d'Etudes D�mographiques)
133 Boulevard Davout 75980 Paris Cedex 20
m�l : email@example.com 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
> Try www.savian.net. I think Alan Churchill may have developed some
> that may be able to help you.
> -----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
>From: Paul Miller <pjmiller_57@YAHOO.COM>
>Sent: Dec 11, 2009 4:09 PM
>Subject: SAS vs. SPLUS vs. SAS
>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
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Sent: Friday, June 13, 2008 1:50 AM
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
...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
>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
>> > 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
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).
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;
> 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.
> ----- 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).
> 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
> 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
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).
This problem is being addressed by DR 103605. No code fix is currently
To correct the problem, must manually clean out remnants of prior CLI
**** 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:
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
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
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 <firstname.lastname@example.org> 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
You can use %INCLUDE in a SAS program to call other SAS programs.
Center for Health Program Development and Management
University of Maryland, Baltimore County
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Sent: Monday, April 21, 2008 12:55 PM
Subject: Running a SAS program within a SAS program
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
do whatever I it is I need to do.
I hope someone can help me.
...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.
Environmental Specialist III
Dominion, Environmental Biology
4111 Castlewood Rd
Richmond, VA 23234
Phone:804-271-5313, Fax: 804-271-2977
Sent by: "SAS(r) To
Re: Using SAS with large datasets
Please respond to
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)
On Fri, Jul 24, 2009 at 8:32 PM, Joe Whitehurst <email@example.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
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.
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Ken
Sent: Friday, April 25, 2008 10:41 AM
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
>> -----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 <firstname.lastname@example.org> 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
...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
>>> "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
>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
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
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
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
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
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.
vironmental Specialist III
Dominion, Environmental Biology
4111 Castlewood Rd
Richmond, VA 23234
Phone:804-271-5313, Fax: 804-271-2977
Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU
Re: Difference Between PC SAS and
UNIX SAS but getting off topic
06/...Re: Running sas code on mainframe through SAS-UNIX #3 672823
This is easy. Say your JCL is located in
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 ;
file subjcl ;
put _infile_ ;
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).
+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
+Subject: Running sas code on mainframe through SAS-UNIX
+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.
On Thu, Mar 26, 2009 at 8:49 AM, Arthur Tabachneck <email@example.com>wrote:
> My congratulations to DataNull and Joe, as well, both extremely well
> 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:
> 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.
> >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...