f



Re: Reading SAS data sets on UNIX by non-SAS apps #2

John:
Following on Richard's thoughtful suggestions, the Affinium system would
likely capture data from csv files. SAS PROC EXPORT produces them quickly,
and loading them into external systems works faster for relatively basic
data structures and data formats, in my experience, than xml parsing.
Sig

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of John
Bentley
Sent: Monday, October 18, 2004 10:10 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Reading SAS data sets on UNIX by non-SAS apps


I have SAS data sets on AIX that we need to read with Unica's Affinium
campaign management software, also on a UNIX box.  (Let's not get into why
we didn't go with the SAS Solution.)  SAS Institute doesn't supply an ODBC
driver for the UNIX environment, and the Affinium implementors don't want to
use the SAS SQL Library for C and or deal with APIs.  Other that dumping the
SAS data sets as flat files, can anyone suggest a solution?

Thanks in advance for the help.
0
HERMANS1 (2684)
10/18/2004 4:04:24 PM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

0 Replies
784 Views

Similar Articles

[PageSpeed] 10

Reply:

Similar Artilces:

Re: search SAS data set from SAS code #2
Rose, The answer to your question depends on your operating system. In Windows, there's the Search tool. In Unix/Linux, you can use grep Bob Abelson HGSI 240 314 4400 x1374 bob_abelson@hgsi.com Rose <myr_rose@YAHOO.COM> Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> 04/19/2005 11:13 AM Please respond to myr_rose To: SAS-L@LISTSERV.UGA.EDU cc: Subject: search SAS data set from SAS code Hi All, Suppose I have a sas permanent data set which was created early, I know the library path but I couldn't remember in which s...

Re: How to filter sas data sets into separate sas data sets #4
Something like this is the old way. You could use a proc sql if you have a new enough version. Increase your buffersize and if you have enough memory you may get it into a hash routine. DATA WORK.NEW; MERGE small (IN=A OBS=500) big ; BY ID_FIELD; IF A=1; RUN; QUIT; RICH -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@listserv.vt.edu] On Behalf Of Lizette Koehler Sent: Monday, April 02, 2007 10:53 AM To: SAS-L@LISTSERV.VT.EDU Subject: How to filter sas data sets into separate sas data sets Listers, This is my failing point in coding SAS. T...

Re: How to filter sas data sets into separate sas data sets #3
Lizette, Instead of trying to merge the two data sets, I would probably try to create a SAS format from the values of VAR1 in data set 1. Then, NODE1, NODE2 and NODE3 could be compared against the format for a match. The example below is a simplified version of what you could do and shows a printout of how it works. It has 5 observations in data set 1 and only 3 variables in data set 2, but I think the logic should hold for the example you gave. After the example is code that could be used to actually split the data as you had requested. Hope this helps. * create sas data set 1 ; data ...

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: Exporting a SAS data set to Text file on SAS unix #3
hi ... actually, what I posted earlier was too much code (sorry) this is enough (a bit more succinct) * variable names into a macro variable (tab separated); proc sql noprint; select name into :vars separated by '09'x from dictionary.columns where libname eq 'SASHELP' and memname eq 'CLASS' order varnum; quit; data _null_; file 'z:\class.txt' dsd dlm='09'x ; if _n_ eq 1 then put "&vars"; set sashelp.class; put (_all_) (:); run; -- Mike Zdeb U@Albany School of Public Health One University Place Rensselaer, New York 12144-3456 P/518-402...

Re: How to filter sas data sets into separate sas data s ets
I think that both Ron's (as he mentioned) and Richard solutions require that VAR1 is in both datasets. But from the original post, it seemed to me that VAR1 is only in data set 1, and it must be matched to 1 of 3 variables in data set 2 (NODE1, NODE2 or NODE3) to be output to the NEWLIST data set. For this reason, I think a format is one possible approach. Maybe the original poster can clarify this point. Thanks. Jack Clark Research Analyst Center for Health Program Development and Management University of Maryland, Baltimore County -----Original Message----- From: SAS(r) Discussio...

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: Difference Between PC SAS and UNIX SAS #2
I cannot give a complete list by any means for these two systems but there are functions listed in TS486 that are specific to windows and afaik, Sleep is one of these. I suggest that you look at the Companion to the ... Operating System in the online docs for each of these and compare the two systems. Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 Suthakar Iyer <suthakariyer@YAH OO.COM> To ...

Re: search SAS data set from SAS code
> From: Rose > Hi All, > Suppose I have a sas permanent data set which was created > early, I know > the library path but I couldn't remember in which sas program code I > created it. how can I search from so many sas program files in > different folders and find it. a problem familiar to all of us delayed-housekeeping folks. Libname Libref '<directory-specification>'; DATA LibRef.DataSetName; use your system utilities to search for the dir-spec of your libref. search: *.sas containing text: <dir-spec> once you have found the libname...

Re: UNIX file permissions for SAS data sets #2
Hi, Richard and everyone. I called SAS Tech Support (919-677-8008) and got the following suggestion, very similar to what you told me in a private communication. They suggested editing the SAS/CONNECT script file tcpunix.scr, adding a line to set the umask right before it issues the SAS command on the remote host, e.g.: type 'umask 022' LF; type 'sas -dmr... In this case, I am not using unxspawn for the remote SAS session. If I were, I believe I would have to do what you suggested, which is to create a shell script file with the umask command in it. A co-worker suggested the...

Re: search SAS data set from SAS code #5
Rose, You have some good advice on search techniques, but they may beinadequate. I hope your LIBNAME wasn't something like libname lib "&dir" ; Perhaps you should also search for ".member", but that also couldhave the same problem. You might also look for key variablenames or values, or procedures that you know created the data.The date from a PROC CONTENTs might provide useful information,or an old report created by the same program with a footnote,"Source code: ...". Maybe data lib.w ( label="created by ..." ) ; would be a good habit to ...

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

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: Unix SAS: How to save log file while in SAS session? #2
On Wed, 18 Aug 2004 12:18:03 -0500, Duck-Hye Yang <dyang@CHAPINHALL.ORG> wrote: >Hello, > >I am using SAS Unix Display manager. >I put together single small sas programming files in one giant sas programming file. >I need to save log and output files AFTER each single small programming file. >The problem is that I do not know how to save log and output while in SAS session. > >Below is the outline of what I'd like to do: > > >DM 'clear log'; >DM 'clear output'; >SAS 1 programming start here >end here >x 'file "SAS...

Re: Read SAS date from log/turning it into SAS datetime value #2
Hi Richard, Rich The datestyle Rich0850 finds, occurs in the log produced by a batch-sas session - and doesn't appear on an interactive-sas session log. Where you can anticipate the use for later parsing of the log, I would reccommend - as Richard (Richard A. DeVenezia <radevenz@IX.NETCOM.COM>) did - insert into the autoexec, a statement to generate a more-easily read datetime. In all my sessions, (keeping altlogs of all interactive sessions has proved very very useful, time and again) I have this statement at the end of the autoexec....... %put starting (contract/project/applicatio...

Re: Compressing data sets (was Re: [SAS-L]) #2
OK, "you or a program on your behalf will have to decompress them before use". -- JackHamilton@FirstHealth.com Manager, Technical Development Metrics Department, First Health West Sacramento, California USA >>> "Richard Graham" <richardwgraham@earthlink.net> 01/05/2004 5:04 PM >>> Actually you can compress(WINZIP, PKZIP) SAS data sets and use them in the compressed format. There is software named ZipMagic which allows zip files to be used as windows folders. I have done this with mixed results when the underlying data set is upwards of 4GB. Bu...

Re: XML data to SAS data set converstion #2
A correction. The initial post asked: "Is it possible to convert an XML data to SAS data set without a SAS environment?" If there is no SAS at all in a particular shop, then there is no way to do this conversion. If access to SAS is available via IOM then there are ways. What "environment" means becomes the question. If a shop can simply convert into a compatible SAS XML format that is a possibility. The other is to convert it into a delimited file or get it into a database that a SAS shop can read. The SAS dataset layout is binary and unknown. You could put it into a S...

Re: suggest: improve SAS Deployment Wizard for SAS v9.2, phase 2 #2
> From: A Little Birdie > > I just searched the SAS-L archives (should have done that > first) and found references to these two pages: > > http://www.sascommunity.org/wiki/Category:V9.2_Phase_2 > > http://www.sascommunity.org/wiki/V9.2_Phase_2_install_guide > > Have you seen this page? > ***************************************************** > http://support.sas.com/kb/35/631.html <---<<< NICE! ***************************************************** > It looks like it addresses your needs, and might be something > nice to add to the SASCo...

Re: MVS Merge Variable Data Using SAS Merge or SAS SQL JOIN #2
A: You may want to consider using nested queries to create the keys that you need to join the tables? That gives the SQL compiler a way to bound the search space. For example, proc sql; create table temp as select * from (select <key transformation>,* from small) as t1 left join (select <key transformation>,* from large) as t2 on t1.<transformed key> EQT t2.<transformed key> ; Now the SQL compiler has two keys from the same domain that it can index or use as sort keys. This method works with composite keys as well. Just make sure that the <transformed key> v...

Re: Compressing data sets (was Re: [SAS-L]) #2 #4
It's not a big deal, but there is a difference between reading a file directly and having another program as an intermediary, and someone someday is going to get into trouble because they didn't take that into account. I'm not sure what you mean by "using SAS/Connect to read non-SAS files". -- JackHamilton@FirstHealth.com Manager, Technical Development Metrics Department, First Health West Sacramento, California USA >>> "Bruce Johnson" <bjohnson@SOLUCIENT.COM> 01/06/2004 9:36 AM >>> But if another program is doing it, within SAS, wh...

Re: Compressing data sets (was Re: [SAS-L]) #2 #7
I'm crazy..yes, SAS/Access...not Connect... ________________________________ Bruce A. Johnson bjohnson@solucient.com -----Original Message----- From: Jack Hamilton [mailto:JackHamilton@firsthealth.com] Sent: Tuesday, January 06, 2004 1:22 PM To: SAS-L@LISTSERV.UGA.EDU; Bruce Johnson Subject: Re: [SAS-L] Compressing data sets (was Re: [SAS-L]) A new way to read/write Excel files in 9.1 was mentioned at SUGI, but as I recall it required a server running SAS/Access to PC File Formats. It wasn't SAS/Connect doing the reading and writing, just as SAS/Connect isn't doing the remote...

Re: Compressing data sets (was Re: [SAS-L]) #2 #6
A new way to read/write Excel files in 9.1 was mentioned at SUGI, but as I recall it required a server running SAS/Access to PC File Formats. It wasn't SAS/Connect doing the reading and writing, just as SAS/Connect isn't doing the remote reading and writing in a regular Connect session. Or are you thinking of something else? -- JackHamilton@FirstHealth.com Manager, Technical Development Metrics Department, First Health West Sacramento, California USA >>> "Bruce Johnson" <bjohnson@SOLUCIENT.COM> 01/06/2004 10:02 AM >>> "using SAS/Connect to...

Re: Unix help: How to hold a SAS run subsequent to run of another application inside SAS #2
Duck-Hye Yang <dyang@CHAPINHALL.ORG> wrote: > I am Unix user. > I tried to run an application inside SAS. > I need to use the output from the application in a subsequent SAS run. > I need to hold the subsequent SAS run until runing the application is done. > The problem is that when I tried to run together, the subsequent SAS program always picked up incomplete output. > It seems like two applications are running simulatenously. First off, do you really need to run an external process, or would it be easier to do that part of the work in SAS as well? (Just a thought, ...

Re: Difference Between PC SAS and UNIX SAS
I'm not aware of any differences in SAS. For sure, there are some differences for external interfaces. E.g. there are no drive letters in UNIX (C:\a\b\). Normally the path delimiters are slashes (/) instead on back-slashes (\) in UNIX, but you can use both in SAS (c:/a/b). And all the commands are different (cp instead of copy, ls instead of dir, mkdir instead of md, ...) As far as you don't need that external commands, SAS is all the same on both platforms. Some limitations could be different - not the SAS limits, but OS limits. A few years ago you could not have more than 2 GB as d...

Web resources about - Re: Reading SAS data sets on UNIX by non-SAS apps #2 - comp.soft-sys.sas

Reading education in the United States - Wikipedia, the free encyclopedia
Reading education is the process by which individuals are taught to derive meaning from text. Government-funded scientific research on reading ...

Crystal Palace v Reading score, result, video highlights, goals - Fox Sports Fox sports
Cabaye opened the scoring from the penalty spot in the 85th minute after Jake Cooper was sent off for fouling Yannick Bolasie. Substitute Campbell ...

Crystal Palace v Reading score, result, video highlights, goals
... goals by Yohan Cabaye and Fraizer Campbell have given Socceroos skipper Mile Jedinak’s Crystal Palace a 2-0 victory at second-tier club Reading ...

Still Surprised By Trump? Then You’re Not Reading Scott Adams
Trump is typically regarded as the least scientific candidate, but according to Scott Adams, he is the best at using the "science of persuasion." ...

Here's Mitt Romney Reading Mean Tweets by Trump and Trump Supporters
... the best tweet. Simon Dumenco, aka Media Guy, is an Ad Age editor-at-large. You can follow him on Twitter @simondumenco. Continue reading ...

Weekend Reading: Harry Reid on Supreme Court Vacancies and the "Biden Rule"
**Harry Reid**: [Filling the Supreme Court Vacancy](https://www.gpo.gov/fdsys/pkg/CREC-2016-03-02/pdf/CREC-2016-03-02-pt1-PgS1170-4.pdf?platform=hootsuite): ...

A brain-wave-reading device designed to improve sleep did wonderful and terrifying things to my dreams ...
The last week has been extremely unusual, to say the least. My dreams have been more colorful, detailed, vivid, and realistic than at any other ...

Students Not Reading Email? That’s Their Problem
A survey at Bowling Green State University shows that its students tend to read and respond to emails from their professors, but ignore emails ...

Melissa McBride Couldn't Speak After Reading The Walking Dead Season 6 Finale
The Walking Dead season six finale is going to be a mighty big, nasty pill to swallow.Several cast [...]

Man Learns About Ex’s Pregnancy & Friends’ Erotic Reading Habits Via Google Play
Sharing your review of an app — for good or bad — can help others decide if they should spend the money to add the service to their smartphone ...

Resources last updated: 3/15/2016 10:44:09 AM