f



Re: Reading SAS files from other programs #4

JMP started as a SAS-like Macintosh product at SAS when they had a demand
for a product on the Mac platform but apparently did not want to try a full
port. The joke around SUGIs was that JMP stood for John's Macintosh
Product. The "John" being John Sall who lead the effort at SAS.

Nat Wooding



             Jim Groeneveld
             <jim2stat@YAHOO.C
             O.UK>                                                      To
             Sent by: "SAS(r)          SAS-L@LISTSERV.UGA.EDU
             Discussion"                                                cc
             <SAS-L@LISTSERV.U
             GA.EDU>                                               Subject
                                       Re: Reading SAS files from other
                                       programs
             04/28/2006 03:40
             AM


             Please respond to
              Jim Groeneveld
             <jim2stat@YAHOO.C
                   O.UK>






Hi Mark,

In addition to my previous reply I can add, that though the SAS dataset
specification is proprietary, not published and officially unknown, other
software vendors have succeeded in analyzing it to read SAS datasets
directly. The original author of DBMS/copy, Henry Feldman, did so a long
time ago already, and his software has been used widely. Now that his
company has been bought by SAS that 'problem' has disappeared.

Something similar happened to the software package JMP, which already was
and is able to read SAS transport files, and as far as I remember also
reads
SAS datasets directly (but I'm not sure). Furthermore I don't know if e.g.
SPSS or S are able to read SAS datasets directly, but it might be
worthwhile
if they once would. An additional complication while reading the datasets
is
that you also would need the associated formats. Reading (or converting)
SAS
format catalogs seems to be more difficult. DBMS/copy handles formats if
they are available in source code, I believe.

And finally there is a very nice and free solution to read SAS datasets and
convert them to anything else. That is using the freely available (from
www.sas.com or support.sas.com) SAS viewer (either vs. 8 or vs. 9). It does
not support user defined formats, but if formats with long format names are
associated to variables in the dataset it nevertheless refuses to load the
dataset, a significant bug. But it displays the dataset nicely as a
spreadsheet. Then you can mark the whole spreadsheet and copy and paste to
e.g. Excel.

For reviews of bugs of both SAS viewers see:
http://tinyurl.com/z5ns8

On Thu, 27 Apr 2006 12:56:57 -0400, Coleman, Mark
<Mark.Coleman@LIBERTYMUTUAL.COM> wrote:

>Greetings,
>
>I am a regular user of Mathematica from Wolfram Research, and a new user
>of SAS. I'm exploring the feasibility of reading native SAS files
>directly from Mathematica. Are native SAS files based upon SQL, or is
>some other proprietary file structure used? If so, does SAS offer some
>sort of ODBC driver?
>
>Thanks,
>
>Mark



-----------------------------------------
CONFIDENTIALITY NOTICE:  This electronic message contains
information which may be legally confidential and/or privileged and
does not in any case represent a firm ENERGY COMMODITY bid or offer
relating thereto which binds the sender without an additional
express written confirmation to that effect.  The information is
intended solely for the individual or entity named above and access
by anyone else is unauthorized.  If you are not the intended
recipient, any disclosure,  copying, distribution, or use of the
contents of this information is prohibited and may be unlawful.  If
you have received this electronic  transmission in error, please
reply immediately to the sender that you have received the message
in error, and delete it.  Thank you.
0
4/28/2006 1:09:14 PM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

0 Replies
500 Views

Similar Articles

[PageSpeed] 40

Reply:

Similar Artilces:

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #4
Ed , I still contend and stick with they should both be able to program and know how SAS works. I prefer the intervewing company give a test, were the person being interviewed is sat in front a laptop or desktop and told to write code to solve some problems. No online help no books just the persona nd the computer. This weeds out those who can code and those who cant, from those who can you then talk to them about the code they wrote and you can deduce those who understand how SAS works and thos who dont. The pool you are left with are the qualified candidates atleast from a SAS perspective and you can make your choice from there. Toby Dunn Comprimise is like telling a lie, it gets easier and easier. Each comprimise you make, that becomes your standard. Perfection doesnt exist, once you reach it, its not perfect anymore. It means something else. From: Ed Heaton <EdHeaton@WESTAT.COM> Reply-To: Ed Heaton <EdHeaton@WESTAT.COM> To: SAS-L@LISTSERV.UGA.EDU Subject: Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. Date: Tue, 4 Sep 2007 16:52:16 -0400 Okay, I think I need to weigh-in on this. First, the exam is designed to test what you know about how SAS works. I think it does a fair job at that. (I say so partly because I only scored 89 on the exam. Now, I didn't prepare for the exam; I was really testing the exam when I took it as opposed to using the exam to test my skills.) The exam doesn't know how well you can program...

Re: Reusing code from SAS Program in another SAS Program #4
In response to a question by Keith, Paul Choate suggested using %INC. The suggestion is reasonable, but not his explanation. Since %INC is a macro you can put it anywhere in open code and it will read the code snippet during compilation. %INC is neither a macro nor a macro instruction. It is one of a few old SAS commands that begin with a %-sign and predate the current macro language. This can be shown by a batch job run with the option NOMACRO. Here is the log. NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0) Licensed to The SAS Learning Edition V2.0, Site ...

Re: Is there a system option for OpenVMS SAS version 8 where a sas program can create an output file with a file attribute of "Stream_LF" so that these external files c
Charles Patridge <charles_s_patridge@PRODIGY.NET> wrote: > Is there a system option for OpenVMS SAS version 8 where a sas program can > create an output file with a file attribute of "Stream_LF" so that these > external files can be served through an Apache WebServer properly? > > Currently, what happens is when we create a CSV file, the Apache Webserver > wants to load the contents of this CSV file into a single cell for Excel. > That is, all OBS are treated as a SINGLE record and all the contents is > loaded into a single cell within Excel. > > T...

Re: Reading SAS files from other programs
Mark, SAS dataset layout is proprietary and unknown. SAS provides both ODBC and OleDB drivers for reading the datasets. Alan Alan Churchill Savian "Bridging SAS and Microsoft Technologies" www.savian.net -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Coleman, Mark Sent: Thursday, April 27, 2006 10:57 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Reading SAS files from other programs Greetings, I am a regular user of Mathematica from Wolfram Research, and a new user of SAS. I'm exploring the feasibility of reading native SAS files directly from Mathematica. Are native SAS files based upon SQL, or is some other proprietary file structure used? If so, does SAS offer some sort of ODBC driver? Thanks, Mark ...

Re: Reading SAS files from other programs #2
Hi Mark, Have a look at the database converters DBMS/copy (Dataflux) and StatTransfer. Regards - Jim. -- Jim Groeneveld, Netherlands Statistician, SAS consultant home.hccnet.nl/jim.groeneveld On Thu, 27 Apr 2006 12:56:57 -0400, Coleman, Mark <Mark.Coleman@LIBERTYMUTUAL.COM> wrote: >Greetings, > >I am a regular user of Mathematica from Wolfram Research, and a new user >of SAS. I'm exploring the feasibility of reading native SAS files >directly from Mathematica. Are native SAS files based upon SQL, or is >some other proprietary file structure used? If so, does SAS offer some >sort of ODBC driver? > >Thanks, > >Mark ...

Re: Reading SAS files from other programs #3
Hi Mark, In addition to my previous reply I can add, that though the SAS dataset specification is proprietary, not published and officially unknown, other software vendors have succeeded in analyzing it to read SAS datasets directly. The original author of DBMS/copy, Henry Feldman, did so a long time ago already, and his software has been used widely. Now that his company has been bought by SAS that 'problem' has disappeared. Something similar happened to the software package JMP, which already was and is able to read SAS transport files, and as far as I remember also reads SAS datasets directly (but I'm not sure). Furthermore I don't know if e.g. SPSS or S are able to read SAS datasets directly, but it might be worthwhile if they once would. An additional complication while reading the datasets is that you also would need the associated formats. Reading (or converting) SAS format catalogs seems to be more difficult. DBMS/copy handles formats if they are available in source code, I believe. And finally there is a very nice and free solution to read SAS datasets and convert them to anything else. That is using the freely available (from www.sas.com or support.sas.com) SAS viewer (either vs. 8 or vs. 9). It does not support user defined formats, but if formats with long format names are associated to variables in the dataset it nevertheless refuses to load the dataset, a significant bug. But it displays the dataset nicely as a spreadsheet. Then you can mark t...

Re: how to read gzip file in SAS #4
Hi, I changed filename command as: filename hhafixed pipe 'C:\Program Files\GnuWin32\bin\gunzip -c C:\SEERMEDICARE\disk1\hhasaf91.txt.gz'; /*reading in a zipped file*/ Then SAS said 'C:\Program' is not recognized as an internal or external command, operable program or batch file. I tried Start-Run-C:\Program Files\GnuWin32\bin\gunzip , the file can be open by gzip.exe. What else should I do? Thanks. On 11/1/07, data _null_, <datanull@gmail.com> wrote: > > I think Howard was saying to debug your CALL to Gzip. I expect you > just need to call it with the full path. C:\your file path\gunzip > > open a DOS box to test > > On 11/1/07, wraong <wrong.wang@gmail.com> wrote: > > Hi, Howard, > > > > How to debug gunzip? > > > > Install *GNU Tar* and *GNU GZip* for Windows. Added "C:\Program > > Files\GnuWin32\bin" to my Path System variable by going to Control > Panel--> > > System Properties --> Advanced Tab--> Environment Variables > > > > Did I added wrong path? > > > > Thanks. > > > > Best, > > Rong > > > > > > > > On 11/1/07, Howard Schreier <hs AT dc-sug DOT org> <nospam@howles.com> > > wrote: > > > > > > On Thu, 1 Nov 2007 12:21:58 -0400, wraong <wrong.wang@GMAIL.COM> > wrote: > > > > > > >Hi,all, > > > > > ...

Re: Reading PDF Files into SAS #4
Thanks Matt and Nat. But when I try to save the PDF to text , nothing gets saved , the text file is totally empty. May be I am doing something wrong. Not Sure. Thanks again for the ideas. ...

Re: Searching for SAS Programming Tips: A Guide to Efficient SAS #4
The book you;re talknig about is aimed for SAS 6. That's a bit out of date. You might be happier going to the SAS Publishing webpages and looking for Bob Virgile's book on SAS Efficiency instead. HTH, David -- David L. Cassell mathematical statistician Design Pathways 3115 NW Norwood Pl. Corvallis OR 97330 _________________________________________________________________ FREE pop-up blocking with the new MSN Toolbar � get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ ...

Re: Running a SAS program within a SAS program
%include() On Mon, Apr 21, 2008 at 12:55 PM, Kathleen Santos <flowerpotcat@gmail.com> wrote: > 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 > -- =============================== WenSui Liu ChoicePoint Precision Marketing Phone: 678-893-9457 Email : wensui.liu@choicepoint.com Blog : statcompute.spaces.live.com =============================== ...

Re: Running SAS programs from within a SAS program
Keith, You can use a series of %include statements naming the programs in the order you want to call them in. %include "drive:\your_folder\program name.txt" ; Mah-J M. Soobader, PhD Principal consultant STATWORKS www.statworks.com -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of Keith W. Larson Sent: Friday, November 18, 2005 10:32 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Running SAS programs from within a SAS program Dear All, I have several small(ish) SAS programs that convert and format DBF files. Thanks to all who helped solve formatting problems. I would like to create a master SAS program that calls each one in sequence. Any ideas? Cheers, Keith __________________________________ Yahoo! FareChase: Search multiple travel sites in one click. http://farechase.yahoo.com ...

Re: running a sas file within a sas file
Like Joep wrote: that seems to be the right thing for the macro facility. With %include you are very static. With the macro facility that could be very dynamic. The simplest thing is: you could provide the statements you want to insert as parameter: %macro doit(stmt1=,stmt2=); ..... &stmt1 ..... &stmt2 ..... %mend; %doit(stmt1=%str(y=sqrt(y);), stmt2=%str(if y<2 then y=2;) ); with many other things you can do, e.g. conditional creating of statements, naming variables by parameters, create multiple statements with macro loops and much more. On the other hand: if you want to do such simple things like you wrote, avoid any %INC or %MACRO things! It is far more readable, if you don't use %INCLUDES. What do you think, that data-step will do: data a; %inc(inc1); %inc(inc2); %inc(inc3); run; ??? instead of: data a; set sashelp.class; if age>11 then age=11; keep name age; run; Gerhard On Mon, 9 Jun 2008 01:42:03 -0700, Joep Steeman <jsteeman@BUSINESSDECISION.COM> wrote: >On 9 jun, 09:20, zpe...@NATURE.BERKELEY.EDU (Zach Peery) wrote: >> Sorry to bug you all with such an easy one, but I havent had much luck >> with the usual help sources. >> >> I just want to run a sas program file within a sas program file. For >> example, in sas file 1 I want to set x equal to 2, then with file 2 >> invoked by file 1, I want to set y = 3. >> >> So sas file 1 looks like this... >> &g...

Re: Storing SAS-programs and -macros in SAS-datasets on a HOST-platform #4
SI provide an example of using a sas catalog as if it were a pds (as a "aggregate storage location"), in the onlinedoc at http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a000214504.htm#a00 0351123 (this is a 9.1.3 link, but the example is valid since before sas v8) However, sas catalogs don't (neccessarily) make cross/platform operations easier. A program is usually a lot smaller that the space it takes up in a sas catalog as a source entry. If you have a lot of programs, the proc upload or download time may become less welcome ;-) "Aggregate storage location&quo...

Re: Reading a file and Creating SAS datasets #4
Mike , A Hash solution would do it in one step. Toby Dunn "Don't bail. The best gold is at the bottom of barrels of crap." Randy Pausch "Be prepared. Luck is where preparation meets opportunity." Randy Pausch > Date: Mon, 12 May 2008 17:52:15 -0400 > From: msz03@ALBANY.EDU > Subject: Re: Reading a file and Creating SAS datasets > To: SAS-L@LISTSERV.UGA.EDU > > hi ... though I do not use CALL EXECUTE very often, I think that this is task where it might be of > use ... here's an example using SASHELP.ZIPCODE that contains a variable (STATECODE) with values > of the standard two-letter state abbreviations ... it reads instream data but could just as easily > read the state codes from an external file or a data set ... > > data _null_; > input state $2.; > call execute(cat( > > 'data ',state, ';', > 'set sashelp.zipcode;', > 'where statecode eq "',state,'";', > 'run;' > > )); > datalines; > NY > AL > AK > ; > run; > > -- > Mike Zdeb > U@Albany School of Public Health > One University Place > Rensselaer, New York 12144-3456 > P/518-402-6479 F/630-604-1475 > >> Thank you Jane. It really helped me a lot. >> >> >> On Mon, 12 May 2008 15:46:42 -0400, SUBSCRIBE SAS-L Jane Xue >> wrote: >> >>>Wish this could hlep some: >>> >>>DATA s...

Re: Creating SAS datasets from reading a file #4
Interesting -- this is around the third time today that this question has come up. You could use the approach Data dwproject_NY dwproject_md etc ; infile ... input ...; if state ='NY' then output dwproject_NY; else if state ='MD' then output dwproject_Md; else you need one of these for each state. run; And, I must ask, why do you want a separate file for each state? Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 SUBSCRIBE SAS-L Chandra Gadde <ddraj2015@GMAIL. To COM> SAS-L@LISTSERV.UGA.EDU Sent by: "SAS(r) cc Discussion" <SAS-L@LISTSERV.U Subject GA.EDU> Creating SAS datasets from reading a file 07/11/2008 02:57 PM Please respond to SUBSCRIBE SAS-L Chandra Gadde <ddraj2015@GMAIL. COM> Hi All I need your help in creting SAS datasets based on sates in a file. I need to create sas dataset for each state that is saved in a file. I have a file called stlist.del is saved in the following path. C:\dwproject\stlist.d...

Re: How to print the name of the current SAS program to a file #4
Thank you all for your responses. I haven't been running my programs in batch mode (and when I tried it, it introduced some new "wrinkles" to my output), but at least I know how it can be done. --Steve On 10/1/07, Stephen Speck <sspeck.at.work@gmail.com> wrote: > > Hello all, > > I'm a newbie to SAS, and even though I've poured over at least 2 SAS > books, and the online documentation for SAS, I cannot seem to find any way > of capturing the name of the SAS program I am running, so as to output it > the footnote section of a report I am printing. I know I could simply > hard-code the file name and path into my program, but I'd like to avoid it > so I'm not changing it every time I change the source file's name. > > For example, if I run a program called "C:\My SAS Source Code\foo.sas", I > want to get this info into a macro variable for output as a component in a > footnote. I'd like to avoid using the following: > > %LET SOURCEFILE = "C:\My SAS Source Code\foo.sas"; > > I'd rather use a built-in function or macro variable that returns this > information. > > The version of SAS I am using is version 8, if that is relevant. (And > although it won't help solve my immediate problem, if such a function/macro > variable/whatever exists in a later version, say so. You never know who > else it will help.) :) > > Thanks in advance,...

Re: Can a SAS program call another SAS program
> From: David Fickbohm > 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. still!?!? surely that is a typo: 9.1? i.e.: -The- 9.1==9.1.3 include it: - - - subRoutineX.sas - - - *...; - - - subRoutineX.sas end - - - - - - autoexec.sas - - - filen...

Re: Running SAS programs from within a SAS program #2
Or better when programs are in one directory file code "drive:\your_folder\" ; %inc code ( prog1 prog2 prog3 ... ) ; Then the next step is parameter driven macros in an autocall library. %prog1(parm1=...) %prog2(alpha=...) ..... Ian Whitlock ================= Date: Fri, 18 Nov 2005 22:54:54 -0500 Reply-To: mah-j@statworks.com Sender: "SAS(r) Discussion" From: "mah-j@statworks.com" <msoobader@VERIZON.NET> Subject: Re: Running SAS programs from within a SAS program Comments: To: "Keith W. Larson" <keith_w_larson@YAHOO.COM> In-Reply-To: <20051119033140.88868.qmail@web51405.mail.yahoo.com> Content-type: text/plain; charset=iso-8859-1 Keith, You can use a series of %include statements naming the programs in the order you want to call them in. %include "drive:\your_folder\program name.txt" ; Mah-J M. Soobader, PhD Principal consultant STATWORKS www.statworks.com -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L]On Behalf Of Keith W. Larson Sent: Friday, November 18, 2005 10:32 PM To: SAS-L Subject: Running SAS programs from within a SAS program Dear All, I have several small(ish) SAS programs that convert and format DBF files. Thanks to all who helped solve formatting problems. I would like to create a master SAS program that calls each one in sequence. Any ideas? Cheers, Keith ______________________...

Re: Executing separate SAS File from Main SAS File
See %include -----Original Message----- From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu]On Behalf Of tobyrathgeb@stanford.edu Sent: Tuesday, August 02, 2005 2:42 PM To: sas-l@uga.edu Subject: Executing separate SAS File from Main SAS File Hi All I was wondering if I can initiate execution of SAS code stored in a SAS file from my main SAS code. Help very much appreciated. Thanks Toby __________________________________________________________________________________________________________________________________ This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately. Ce courrier �lectronique est confidentiel et prot�g�. L'exp�diteur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) d�sign�(s) est interdite. Si vous recevez ce courrier �lectronique par erreur, veuillez m'en aviser imm�diatement, par retour de courrier �lectronique ou par un autre moyen. ...

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: Running a SAS program within a SAS program #2
Kathleen Based on your subject, my immediate impulse was %inlude() where you put a fileref in the quotes. However, I think you want to do something else. You say that you have individual programs that produce a set for each year. Do you store these sets somewhere or do you run the programs when you want data for a given year. I would suggest that you first get a collection of these yearly sets and run a contents on each one. Then, write a program similar to Data mylib.combined; set mylib.year1(rename = (Dates = Date ....)) mylib.year2(rename= (Sdates=Date....)) ..... ; The idea would be to get rid of the variations in the variable names. You could simply copy in the individual programs into one honking big program and keep running this until you get a uniform combined set but you will use a lot of machine cycles doing this. Assuming that you have to make several passes at the data in order to get things right, I would work from stored data sets where all you are doing is changing the rename statements. Good luck Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 Kathleen Santos <flowerpotcat@GMA IL.COM> To Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU Discussion" cc <SAS-...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year.
I took the advanced exam this April because I wanted a relatively systematic way of assessing my knowledge of SAS in a short time span. For that purpose, it was worth it. Since I learn SAS by doing new tasks, or re-doing old tasks in a new way, I assume my knowledge of SAS is uneven, even though I am regarded as productive, and frequently creative in using SAS to solve our group's problems. I passed the test, with lower subscores on the components that I expected to be weakest on. I thought many of the questions made me think about some fundamental, sometimes subtle, features of the language. I did some guessing, but that was on my weaker topics. So the exam results, in my view, reflected something real. I agree, a prospective employer should not put much stock in SAS certification exams. Many highly effective people are not good test takers. Besides, this exam is a crude instrument. My score was identical to a colleague who still regularly asks me for guidance in finding solutions in SAS to specific problems. I probably know more SAS than he does (and he is a good SAS programmer), but you wouldn't know from the exam results. As to version 9-specific questions, I don't recall whether there was much material that was version 9 only. But I expected the test to be more oriented to "advanced" concepts than to new features of version 9. By the way, even though I passed, I can't get a SAS advanced certificate -- because I haven't taken the...

Re: Reusing code from SAS Program in another SAS Program
Keith - Store your code snippets in a PDS and then %include into your programs. For example this program includes a format called "$REGCRT" that I've stored in the PDS DSCHEER.PROD.RUN.FORMATS($REGCRT): //LOOKUP JOB (DSDBX0000T,DS80,20,5,0),'CHOATE 654-2160',TIME=1, // USER=DSPAULC,MSGCLASS=X,NOTIFY=DSPAULC //GOSAS EXEC HWSAS //SYSIN DD * OPTIONS PS=2000 LS=80; LIBNAME VENDOR 'DS.SYS.WORK.VENDOR.PANEL' DISP=SHR; FILENAME FMT 'DSCHEER.PROD.RUN.FORMATS' DISP=SHR; %INC FMT($REGCRT); DATA LOOKUP; RETAIN SENDDATE VENDRC RCNAME VENDOR NAME ADDR1 ADDR2 ADDR3 ZIP PHONENUM INVADDR1 INVADDR2 INVZIP; SET VENDOR.PANEL; WHERE VENDOR IN ('HV0010' 'HV0011'); RCNAME=PUT(VENDRC,$REGCRT.); KEEP SENDDATE VENDRC RCNAME VENDOR NAME ADDR1 ADDR2 ADDR3 ZIP PHONENUM INVADDR1 INVADDR2 INVZIP; PROC PRINT; RUN; ENDSAS; Since %INC is a macro you can put it anywhere in open code and it will read the code snippet during compilation. hth Paul Choate DDS Data Extraction (916) 654-2160 -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Keith Sent: Friday, May 20, 2005 3:23 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Reusing code from SAS Program in another SAS Program I write SAS programs on the Mainframe. I have several programming steps in multiple programs that use the same IF statements, for example. Maintenance is getting to b...

Re: rtf file into excel spreadsheet/sas program #4
sasnew@GMAIL.COM wrote: > >hi all sas gurus, > >i want to convert an rtf file into a spreadsheet using sas program.how >can i do it? > >the data looks like this; > >Ablation > pituitary (gland) (with hypofunction) 253.7 > placenta - see Placenta, ablatio > uterus 621.8 >Ablepharia, ablepharon, ablephary 743.62 >Ablepsia - see Blindness >Ablepsy - see Blindness >Ablutomania 300.3 >Abnormal, abnormality, abnormalities - see also Anomaly > >i want it to look like this; > >CONDITION SUBCOND CODE > SEE SEE_ALSO >Ablation pituitary (gland) (with hypofunction) 253.7 > - - >Ablation placenta - - > Placenta, ablatio - I can't think of any sound reason why I would do this in SAS. (I can think of unsound scenarios, like Hannibal Lecter threatening to eat me if I didn't prove this was possible, but no sound reasons.) Use a tool which 'reads' RTF files. I would look at Perl and the Win32::OLE module, or a module which handles RTF specifically, and convert this into a data file before dumping it into a format that Excel can handle. Others would use VBA, or C#, or whatever. But RTF is *not* a database format. And raw RTF is not easy to decode by hand. HTH, David -- David L. Cassell mathem...

Web resources about - Re: Reading SAS files from other programs #4 - comp.soft-sys.sas

Program - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

Government reveals changes to controversial Safe Schools program
The federal government has unveiled changes it wants made to a controversial anti-bullying program in schools.

SeaWorld says it will end killer whale breeding program - CBS News 8 - San Diego, CA News Station - KFMB ...
SeaWorld Entertainment, Inc. announced that as of Thursday, orcas will no longer be bred at its parks in San Diego or anywhere else in the country, ...

SeaWorld Orca Breeding Program Coming To End « CBS Boston
The announcement follows years of controversy over keeping orcas in captivity.

Behind the SeaWorld killer whale program controversy - Videos - CBS News
The wildlife theme park chain announced new policies for the breeding and showcasing of its killer whales. The shakeup comes after years of controversy, ...

SeaWorld says it will end killer whale breeding program
MIAMI (AP) — SeaWorld announced Thursday it will immediately stop breeding killer whales, essentially phasing the iconic orcas from its theme ...

YouTube Stops Complaining About T-Mobile’s Binge On, Joins Program
Remember all those years ago, when YouTube publicly railed against T-Mobile’s Binge On program , saying the wireless company may have violated ...

T-Mobile Adds YouTube to Binge On After T-Mobile Changes Program for Video Providers
... concerns all had some sort of agenda. As it turns out, YouTube (and the rest of us who had issues with Binge On) really just wanted the program ...

'Teen Mom OG' Star Catelynn Lowell Leaves Home for Program in Arizona: 'This Is For Me and My Family' ...
'Teen Mom OG' star Catelynn Lowell leaves home after troubling tweets, but insists she's not going to rehab.

Uber Offers Drivers Instant Pay In Pilot Program
Uber drivers will be able to get paid instantly via a GoBank account, in a pilot launched Thursday in San Francisco. Uber drivers in San Francisco ...

Resources last updated: 3/18/2016 12:37:19 PM