f



Re: Is it possible to read a sas dataset NOT using sas? #2

I think SPSS and DBMSCopy can read SAS datasets. Also for sure WPS.
Gerhard


On Tue, 18 Mar 2008 06:43:44 -0700, RolandRB <rolandberry@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?
0
3/18/2008 4:16:50 PM
comp.soft-sys.sas 142827 articles. 3 followers. Post Follow

0 Replies
1203 Views

Similar Articles

[PageSpeed] 34

Reply:

Similar Artilces:

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. Phil Rack www.minequest.com -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of RolandRB Sent: Tuesday, March 18, 2008 9:44 AM To: SAS-L@LISTSERV.UGA.EDU 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 of text? 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? YEZZZZ, and even for free !!! Download the sas system viewer: http://www.umass.edu/statdata/software/downloads/SASViewer/index.html Hermie Hi Roland, 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
Hi All, 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; RUN ; 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 >dataset. > >For example, I want to set file20070101.sas7bdat - >file20071231.sas7bdat (365 total files) into >file_history.sas7bdat. > >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?? > >Thanks again! > >Mark 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.
lazybone2k@GMAIL.COM wrote: > >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 >t...

Re: SAS
Chandu, ken, To be explicit start at http://support.sas.com/rnd/scalability/spde/index.html 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 http://www.nesug.org/ whenever everyone has general access to papers. Ian Whitlock ================= Date: Mon, 3 Jul 2006 12:40:24 -0400 Reply-To: evilpettingzoo97@AOL.COM 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. Data prod.Master_date; set prod.master_date; where snap_dt ne "&end_dt"d; run; 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) <rjf2@cdc.gov> 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 than WORK. Regards, Søren 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. Nat Wooding 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
jontugman, 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. 7 Exit. 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...

Web resources about - Re: Is it possible to read a sas dataset NOT using sas? #2 - comp.soft-sys.sas

Police: Off-Duty Memphis Officer Shoots Intruder at Home
Police in Memphis, Tennessee, say one of their off-duty officers was involved in a shooting in the nearby Mississippi city of Southaven

John Kasich, Unscripted
Windham, N.H. “I'm not a scripted man," John Kasich said Monday afternoon. Read more on WeeklyStandard.

China's Lunar New Year celebration involved a 540-robot dance routine
CCTV's Spring Festival Gala — an annual Chinese state television special celebrating the Lunar New Year — ran for four and a half hours this ...

Is it time to give up on WordPress sites?
It’s being reported by Malwarebytes’ CyberheistNews and other sources that a unexpectedly large wave of hacking has been hitting thousands of ...

Survivors found, but dozens still missing after Taiwan quake
CBS News Survivors found, but dozens still missing after Taiwan quake CBS News TAINAN, Taiwan At least four people, including an 8-year-old ...

Sir Elton John’s Cell Phone Shocker
This time last year, we were confirming that Christopher Nolan does not own a cell phone. And now, thanks to the latest episode of James Corden ...

NASA Releases 360-Degree Video Of Martian Surface
Today, NASA’s Jet Propulsion Laboratory released a new 360-degree video, giving you a virtual tour of the Martian surface. The video was created ...

Ted Cruz Lives Up to ‘Weasel’ Accusation with Shady Mailer
CNN has called it “astonishing” that Republican Iowa caucus winner Ted Cruz “continues to knowingly mislead” the public when it comes to his ...

For Passengers of a Royal Caribbean Cruise, Anything but Smooth Sailing
New York Times For Passengers of a Royal Caribbean Cruise, Anything but Smooth Sailing New York Times It was around 5 p.m. on Sunday when ...

Monday Evening Open Thread
You know who won the Super Bowl yesterday? Lady Gaga. Talk about whatever!

Resources last updated: 2/9/2016 12:24:50 AM