f



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
0
msoobader (65)
11/19/2005 3:54:54 AM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

0 Replies
777 Views

Similar Articles

[PageSpeed] 22

Reply:

Similar Artilces:

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 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: 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 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: Possible to run a SAS program within another SAS program?
Julie, Uhhh create a macro that simply %includes the programs you want and in what order. It would be very specific to you the creator and user, in other words right biw I can't think of a good way to pass al the info you need to the macro from the user. As you can tell the user interface would be the crucial part of this. I personally wouldnt want to have this in my production code but have written SAS programs that do nothing more than %include a list of programs. Toby Dunn From: oseithedude@GMAIL.COM Reply-To: oseithedude@GMAIL.COM To: SAS-L@LISTSERV.UGA.EDU Subject: Possible to run a SAS program within another SAS program? Date: Wed, 7 Dec 2005 11:28:43 -0800 Hello, I have 9 SAS programs, all within the same Windows folder that I usually run at the same time - one right after the other. For convenience, is it possible to write a simple SAS program that will let me run all the programs at once or to have a program that will allow me to pick and choose which SAS programs I want to run (e.g., in the case I only want to run the first 3 and last program out of the 9 SAS programs) and which order the programs are run in? I guess what I'm really looking for is if there is a way to call another SAS program using only a couple lines of code so that, if I choose not run that program, I can just comment that code out or something like that. Let me know if this is possible, thanks!!! Julie ...

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

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: Possible to run a SAS program within another SAS program? #3
why just last week, we discussed this: Date: Mon, 21 Nov 2005 11:01:30 -0500 Subject: Re: Running SAS programs from within a SAS program http://www.listserv.uga.edu/cgi-bin/wa?A2=ind0511C&L=sas-l&P=R33664 Ron Fehd the %include maven CDC Atlanta GA USA RJF2 at cdc dot gov > -----Original Message----- > From: osei the dude > Hello, I have 9 SAS programs, all within the same Windows > folder that I > usually run at the same time - one right after the other. For > convenience, is it possible to write a simple SAS program > that will let > me run ...

Re: Possible to run a SAS program within another SAS program? #6
On Wed, 7 Dec 2005 22:32:49 -0800, oseithedude@GMAIL.COM wrote: >nevin.krishna@gmail.com wrote: >> You could use the %include statement to call a specified program. >> for example : >> >> %include "c:\documents and settings\nkrishna\my >> documents\macros\upcase_mac.sas"; >> >> where upcase_mac.sas is a program stored in the above path..so you >> could write an include statement for each program and then copy and >> paste them into any order you need..unless of course i am >> misunderstanding your needs..:-) >> >...

How to run several SAS programs in one sas Program
Hi, Is it possible to run several SAS programs in one sas Program. I can use the %INCLUDE, but is there another way? Tx On Mar 18, 5:31=A0am, laika <michel.verhe...@axa.be> wrote: > Hi, > > Is it possible to run several SAS programs in one sas Program. I can > use the %INCLUDE, but is there another way? > > Tx If you want to read each program as a separate batch program you can use SYSTASK. systask (or %systask) is a good option. If you want to run several programs on different machines (local or remote) then "rsubmit" could be of use:...

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: 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: run a SAS program before SAS session starts
> From: mpajoh@ODOT.ORG > How can I run a SAS program every time before the interactive session > starts? > > Masoud > > I use SAS 9.1.1.3 on XP. Here are the files you need to make a batch file which executes some sas program then opens sas: http://www.sascommunity.org/wiki/Batch_processing_under_Windows - - - StartOneThenSAS.bat - - - call sas MyProgram1 call sas Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov ...

Re: Can a SAS program call another SAS program #3
Dear SAS-L-ers, 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: 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: Can a SAS program call another SAS program #2
Dave, What you want to do can be done with %include. Bob Abelson HGSI 240 314 4400 x1374 bob_abelson@hgsi.com David Fickbohm <DavidF@HOMEGAIN.COM> Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> 10/15/2004 04:05 PM Please respond to David Fickbohm To: SAS-L@LISTSERV.UGA.EDU cc: Subject: Can a SAS program call another SAS program People, 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...

Re: Reusing code from SAS Program in another SAS Program #5
Ian, I agree with your statement: "Well maybe it is best postponed to the time Keith shows that parameterization would be helpful to him." If it does turn out that parameterization would be helpful to him, he is in luck. I will agree to offer him, and SAS-L, the best example that my understanding of the SAS Component Language and my meager skills will allow. And I hope you, and as many other mmmm's as possible, will do likewise with the SAS Macro Language. I hope it has become apparent to you and other mmmm's that the SAS Component Language can handle whole classes of pr...

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: run a SAS program before SAS session starts #2
Masoud; That's what autoexec.sas is for. Look it up in the documentation. Ed Edward Heaton, Senior Systems Analyst, Westat (An Employee-Owned Research Corporation), 1650 Research Boulevard, TB-286, Rockville, MD 20850-3195 Voice: (301) 610-4818 Fax: (301) 294-2085 mailto:EdHeaton@Westat.com http://www.Westat.com -----Original Message----- From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu] On Behalf Of mpajoh@ODOT.ORG Sent: Tuesday, November 27, 2007 4:17 PM To: SAS-L@LISTSERV.UGA.EDU Subject: run a SAS program before SAS session starts How can I run a SAS program every time before the interactive session starts? Masoud I use SAS 9.1.1.3 on XP. ...

Re: Reusing code from SAS Program in another SAS Program #7 1547527
Hi Keith, is it exactly the same code (a) or only the same structure but with different variable names in it (b) ? (a) you may save the "IF code" in a separate member (let's say IFcode) and simply %INCLUDE that member within your various data stes. FILENAME xxx FILENAME xxx 'a.b.c.' DISP=shr; DATA ... SET ... %INCLUDE xxx(IFcode); run; (b) you could use the same technique but with macro logic in order to set the variable names dynamically before including IFcode does this help ? Regards Roland -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Keith Sent: Saturday, May 21, 2005 12:23 AM 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 be a problem because I may have to make the same code change in 50 different programs. I would like to write the If statement only once and read it into the appropriate data steps of the various programs. If someone could give me help on how I could do this, it would be appreciated. ...

Re: Reusing code from SAS Program in another SAS Program #7 647546
Ian Whitlock wrote: > %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. %RUN and %LIST are two others; is that a complete list? The MACRO statement is also not disabled by OPTIONS NOMACRO, but it doesn't start with a percent sign. -- Jack Hamilton Oakland, California ...

Re: Reusing code from SAS Program in another SAS Program #6 1547525
Keith, You have two choices: 1st.: create macros containing your if statements and store them either in a user or public macro library. 2nd.: Create text files contaiing your if statements save them in a PDS and %include them in your program. Toby Dunn From: Keith <kmccall00@CHARTER.NET> Reply-To: Keith <kmccall00@CHARTER.NET> To: SAS-L@LISTSERV.UGA.EDU Subject: Reusing code from SAS Program in another SAS Program Date: Fri, 20 May 2005 15:23:07 -0700 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 be a problem because I may have to make the same code change in 50 different programs. I would like to write the If statement only once and read it into the appropriate data steps of the various programs. If someone could give me help on how I could do this, it would be appreciated. ...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #6
I interviewed at a company that gave a test where I had a half hour to produce a very simple report using PROC REPORT. I was provided all the manuals I wanted, but because I had used PROC REPORT before, I wanted none of them. I finished in five minutes, and most people on SAS-L would be able to beat that time. Bob Abelson HGSI 240 314 4400 x1374 bob_abelson@hgsi.com "toby dunn" <tobydunn@HOTMAIL.COM> Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> 09/04/2007 05:15 PM Please respond to "toby dunn" <tobydunn@HOTMAIL.COM> To SAS-L@LISTSERV.UGA.EDU cc Subject Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. 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...

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

Web resources about - Re: Running SAS programs from within a SAS program - 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, ...

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

The Latest: Des Moines hosts 4 top programs for early rounds
The Latest on the first full day of the men's NCAA Tournament, including games being played in Providence, Rhode Island, Raleigh, North Carolina, ...

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

Comcast Joins Program to Train Military Vets as Cable Techs -
... lagging tech support while generating some good will among the public, Comcast has announced that the company has launched a new program to ...

'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 4:50:29 PM