Re: Is it possible to read a sas dataset NOT using sas?
You might try the Universal OLE DB driver.
Docs at: http://tinyurl.com/2cmgcf
Driver page at: http://tinyurl.com/2hbc23
I think this should allow you to read a sas data set but not write to it.
Also, the driver does not support much beyond a Select * clause.
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Sent: Tuesday, March 18, 2008 9:44 AM
Subject: 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 an...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
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?
and even for free !!!
Download the sas system viewer:
I guess you know of the World Programming System, WPS? It can read
(and write, I th...RE : read/update sas dataset using SAS/Share and JDBC
Does anyone know how to display SAS dataset in java/swing client
without pre-defining SAS library in SAS/share startup ? e.g. How to
read and dispaly sas dataset in java/swing client, which is available
on my desktop (using SAS/Share JDBC driver and without pre-defining
libname in sas/share startup script).
I have started sas/share server as below :
PROC SERVER ID = sassrv01
OAPW = <userID>
AUTHENTICATE = optional;
I installed SAS/Share JDBC drive to connect. FYI, I am able to
display sas dataset in java/swing client by pre-defi...Re: combine n SAS datasets in to one SAS dataset. #2
On Thu, 17 Jan 2008 12:06:01 -0800, stulkem@YAHOO.COM wrote:
>Thanks for your help in advance!
>I have hundreds of SAS datasets that I want to combine into one SAS
>For example, I want to set file20070101.sas7bdat -
>file20071231.sas7bdat (365 total files) into
>How can I write this into a macro or array or whatever will work so I
>don't have to write each individual file name??
You must provide some rule or process which SAS can use to discover the
names of the data sets t...Re: How to read a SAS log into a SAS dataset.
>Dear SAS-L listers,
>This may be the millionth time somebody is asking this question " how to
>read a SAS log into a SAS dataset?". I looked at previous posts and
>gathered info from various SUGI papers and found a way to get the log and
>read it. But i dont know for some reason its not working. Please help me.
>I used a Proc printto procedure to print the log to a external file
>location and try to read in the log and create a SAS dataset which will
>contain info about Filename, Owner name, Group name, Elapsed time, CPU
To be explicit start at
Russ Lavery and I have a NESUG Paper "An Annotated Guide: The New (8.2),
Free & Fast SPDE Data Engine". It will be availiable at
whenever everyone has general access to papers.
Date: Mon, 3 Jul 2006 12:40:24 -0400
Sender: "SAS(r) Discussion"
From: Ken Borowiak <evilpettingzoo97@AOL.COM>
Subject: Re: SAS - 9; Partition of SAS Datasets.
Comments: To: c...Re: Deleting SAS Data from a SAS DATASET #2
Chandra - this isn't my expertise area - I'm sure others may have better
ideas but I'll make three comments.
If your datasets have a large number of variables, in your datastep
method a WHERE clause will be more efficient - the IF statement causes
each record to be fully read before it can be selected for deletion. A
WHERE clause would only read the single variable in the case of records
that meet the criteria for deletion.
where snap_dt ne "&end_dt"d;
You probably would be better off changing your data model t...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 al...Re: SAS Macro to delete a SAS dataset #2 313487
I too like(d) PROC DELETE.
When I used it I was forced to remove it and use PROC DATASETS because
PROC DELETE is not documented.
Also, but I have not tested it. How does it work with indexed data
sets, audit trails, generation data groups, views, etc.?
I don't worry much about deleting, "all" of my programs run in batch
and are obsolete as soon as they are written.
On 12/3/09, Fehd, Ronald J. (CDC/CCHIS/NCPHI) <firstname.lastname@example.org> wrote:
> > From: SAS Techies
> > Subject: SAS Macro to delete a SAS dataset
> > Here's a simple SAS...Re: SAS Macro to delete a SAS dataset #2 131884
Proc delete cannot delete views (I just tried).
Of the macros suggested, I prefer the SQL version. The original
version does not work if the USER option is set to something other
On Thu, 3 Dec 2009 08:41:55 -0600, Data _null_; <iebupdte@GMAIL.COM> wrote:
>I too like(d) PROC DELETE.
>When I used it I was forced to remove it and use PROC DATASETS because
>PROC DELETE is not documented.
>Also, but I have not tested it. How does it work with indexed data
>sets, audit trails, generation data groups, views, etc.?
...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
ben.powel...Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #2
Test preparation is akin to following a simple algorithm:
1. Evaluate the test and discover if it is worth taking.
2. If #1 evaluates false then go to exit.
3. Determine if your *test* knowledge of SAS is insufficient.
4. If #3 evaluates true, do the test preparation.
5. Pay the money.
6. Take the test.
From your standpoint, the step of paramount importance is step #1. That is
where you mainly failed. From SAS' standpoint, only one step matters: #5.
This is the only reason the test was created in the first place.
The world would be a better place if all employers un...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: Email into SAS server and starting a SAS job. Possible? #2
on 3/16/2006 12:21 PM David L Cassell said the following:
> Alistair.Gordon@NEWTYNE.COM wrote:
>> Is this possible?
>> We have a SAS BI Enterprise and a big UNIX server. Is it possible for
>> someone to email into the server and attach a CSV file say, and upon
>> receipt of the file the server goes 'Ah ha!' and kicks off a SAS job
>> that rips out the attached file and does something or other with it?
>> What needs to be done?
> Yes, this is possible. Although I agree with Mike and Alan that other
> approaches may b...