cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
_LB
‎09-01-2015
  • 170 Posts
  • 0 Likes Given
  • 0 Solutions
  • 2 Likes Received

automating macros w/ if & then statements

by Fluorite | Level 6 in SAS Programming
‎10-07-2011 04:32 PM
‎10-07-2011 04:32 PM
Hi Art- Thanks for the link, however, It is part of a larger macro so that I just want to "kill" the program if it doesn't fall on a specific day, plus actually I have a few programs bundled as well so I don't want to recode everything again.  Is this feasible? Thanks again. Lawrence %macro driver;   %if %sysfunc(day(%sysfunc(today()))) le 7 %then %do;     %a   %end;   %else %do;     "KILL PROGRAM" ?   %end; %mend driver; %driver ... View more

automating macros w/ if & then statements

by Fluorite | Level 6 in SAS Programming
‎10-07-2011 04:20 PM
‎10-07-2011 04:20 PM
Art, Question- If i want to simply end the program if it does not fall on a specific day, how does that go? Thanks. Lawrence ... View more

recalling macros

by Fluorite | Level 6 in SAS Programming
‎10-07-2011 03:02 PM
‎10-07-2011 03:02 PM
Tom, That works! Thank you! Lawrence ... View more

recalling macros

by Fluorite | Level 6 in SAS Programming
‎10-07-2011 01:42 PM
‎10-07-2011 01:42 PM
KSharp; The macro does work perfectly in all the programs if I run them separately- The first one works w/o incident, but then when it comes to the second one, it gives this error- NOTE: Autocall member, UNITSPEC, has not been compiled by the macro processor. It may contain a macro syntax error or not define a macro with the same name as the member. To autocall this member again, set OPTION MRECALL. ERROR: Windows Error Reporting failed because the client was not found. ERROR: Read Access Violation In Task [ Submit ] I have option MRECALL set into each macro but perhaps I need to set it differently? Thanks. Thanks again. Lawrence ... View more

recalling macros

by Fluorite | Level 6 in SAS Programming
‎10-06-2011 05:59 PM
‎10-06-2011 05:59 PM
Sorry about the error message that did not print right. ... View more

recalling macros

by Fluorite | Level 6 in SAS Programming
‎10-06-2011 05:59 PM
‎10-06-2011 05:59 PM
Hello all, A basic question regarding mrecall of macros- OK I have a program that calls all these macros- %monthday %monthnight   %monthBMT Within each of the macros I run another macro called %UNITSPEC that essentially does the same thing to each of the programs above but with some minor changes in the underlying query- However after the first program runs, it crashes out on me-log output follows as below- I do have within each program above- filename hhmacros "\\Fpmcb11\InfectionControl\sasprograms\MACROS\HH"; options mrecall mautosource sasautos=(hhmacros  sasautos) to recall the macros each time. Is this necessary? Thanks again. Lawrence ERROR:Windows Error Reporting failed because the client was not found. ERROR:  Read Access Violation In Task [ Submit ] Exceptionoccurred at (016F9DBA) TaskTraceback Address   Frame    (DBGHELP API Version 4.0 rev 5) 016F9DBA  0852D6FC sashost:Main+0xE37F6 0164D839  0852D970 sashost:Main+0x37275 01655CC8  0852D9C0 sashost:Main+0x3F704 674917BE  0852DA20 sasxzcrp:mcn_main+0x7BE 671F2984  0852DA4C sasxmac:mcn_main+0x1984 023E5B43  0852FB38 sasxshel:mcn_main+0x4B43 023E51BE  0852FB54 sasxshel:mcn_main+0x41BE 02406DE6  0852FB84 sasxshel:mcn_main+0x25DE6 02406C12  0852FB9C sasxshel:mcn_main+0x25C12 02404F81  0852FC28 sasxshel:mcn_main+0x23F81 023F0725  0852FC58 sasxshel:mcn_main+0xF725 023F4250  0852FCA8 sasxshel:mcn_main+0x13250 023FEA6E  0852FCE0 sasxshel:mcn_main+0x1DA6E 023FC92F  0852FD64 sasxshel:mcn_main+0x1B92F 0241CE05  0852FEF8 sasxshel:mcn_main+0x3BE05 02420169  0852FF6C sasxshel:mcn_main+0x3F169 02420C9E  0852FF8C sasxshel:mcn_main+0x3FC9E 01622854  0852FFA0 sashost:Main+0xC290 0170F038  0852FFB4 sashost:Main+0xF8A74 7C80B729  0852FFEC kernel32:GetModuleFileNameA+0x1BA ERROR: Generic criticalerror ... View more

automating macros w/ if & then statements

by Fluorite | Level 6 in SAS Programming
‎10-03-2011 07:47 PM
‎10-03-2011 07:47 PM
Thanks Art. That helps. I was close but was missing an element or two. ... View more

automating macros w/ if & then statements

by Fluorite | Level 6 in SAS Programming
‎10-03-2011 01:41 PM
‎10-03-2011 01:41 PM
Hello folks! A small question concerning the automation of macro's- SO let's say I have %a & %b that I want to run under certain circumstances- Lets say that if the day of the month is between 1 and 7 I want %a to run otherwise I want %b to run; Thank you all again. Lawrence ... View more

proc gchart, vbar, fill/3d options + line chart

by Fluorite | Level 6 in Graphics Programming
‎09-26-2011 05:14 PM
‎09-26-2011 05:14 PM
Sanjay, Can you send me an email to Lawrence.Block@ucsfmedctr.org or post your actual email address so I can send you the data. Thank you. Lawrence ... View more

proc gchart, vbar, fill/3d options + line chart

by Fluorite | Level 6 in Graphics Programming
‎09-26-2011 04:42 PM
‎09-26-2011 04:42 PM
Sanjay, Can I send you data set in an excel spreadsheet or csv file? Just easier than attempting to recreate the entire set to post? Thanks. Lawrence. ... View more

proc gchart, vbar, fill/3d options + line chart

by Fluorite | Level 6 in Graphics Programming
‎09-26-2011 04:07 PM
‎09-26-2011 04:07 PM
Sanjay; I will upload the code so you can run it in whole and a little further in depth explanation on the issue. Thanks. ... View more

proc gchart, vbar, fill/3d options + line chart

by Fluorite | Level 6 in Graphics Programming
‎09-26-2011 03:13 PM
‎09-26-2011 03:13 PM
Sanjay, Because I like to push the limit I am back again w/ more questions on the GTL. This time I am using the secondary x axis. What I am attempting to do is shift the secondary x axis to the bottom but above the units (I have hacked the unit names for security purposes), change the format to a monyy5. format. I have been attempting to use the DISPLAYSECONDARY function without much success. The other option is to place the months in the yellow circle w/ the rate if there is someway to split the text into two lines. I attempted this as well without much success. The other glitch I have is that it produces a thrid unwanted key in the legend due to the data set structure of the overlay of the datasets so that the units essentially get a blank value for group value. I am not sure how to clear this out. Both the template code and the image is included that hopefully can help you help me. Thanks again for your assistance. Lawrence   define statgraph BarLineMultCo;     begingraph;      ;        layout overlay / xaxisopts=(display=(line ticks tickvalues))  cycleattrs=true  yaxisopts=(LABEL=('COMPLIANCE RATE') griddisplay=on linearopts=(tickvaluesequence=(start=0 end=1 increment=.1))) ;           barchart x=location y=comply / skin=modern discreteoffset=-0.3 barwidth=.6 /*FILLATTRS =(color=LIPGR)*/GROUP=COLOR_SCHEME            name='COMPLIANCE' legendlabel='COMPLIANCE';            ReferenceLine y=.85 / clip=true Lineattrs=( Pattern=solid thickness=4 color=blue) name="IAP GOAL 85%" legendlabel="IAP GOAL 85%";                       seriesplot x=fixdate y=comply / lineattrs=graphdatadefault(thickness=3 color=red) name="Overall"    LEGENDLABEL="Overall" xaxis=x2;                      scatterplot x=fixdate y=comply /    markerattrs=(symbol=circlefilled size=30 color=yellow) xaxis=x2 /*name="Overall"  LEGENDLABEL="Overall"*/;           scatterplot x=fixdate y=comply / markerattrs=(symbol=circle size=31 color=red) xaxis=x2 ;           scatterplot x=fixdate y=comply / markercharacter=comply discreteoffset= -0.2 markercharacterattrs=(color=red weight=bold) xaxis=x2; discretelegend  "Overall"  "COMPLIANCE" "IAP GOAL 85%" /   location=outside halign=right valign=bottom; endlayout;      endgraph;   end;   run; ... View more

proc gchart, vbar, fill/3d options + line chart

by Fluorite | Level 6 in Graphics Programming
‎09-21-2011 05:02 PM
‎09-21-2011 05:02 PM
That works. Thank you again. ... View more

proc gchart, vbar, fill/3d options + line chart

by Fluorite | Level 6 in Graphics Programming
‎09-21-2011 04:53 PM
‎09-21-2011 04:53 PM
Sanjay-OK that works! Thanks. However when I attempt to output in a PDF or RTF it does not render the colors correctly. Lawrence ... View more

proc gchart, vbar, fill/3d options + line chart

by Fluorite | Level 6 in Graphics Programming
‎09-21-2011 04:12 PM
‎09-21-2011 04:12 PM
OK Sanjay I am back with a new twist on the proc template. So now I have grouped variables-Yet I am having some difficulty dictating the colors- I have defined the template as: proc template; define style Styles.Mydefault; parent=Styles.Default; style Graphdata1 /Color=green; style Graphdata2 /Color=red; end; Yet I when add the next part and define the FILLATTRS aspect, it askes for a dynamic or constant value.  How do I substitute the Graphdatan components? into the statement   barchart x=role2 y=comply / skin=modern  /*FILLATTRS =(color=Mydefault)*/ discreteoffset=-0.3 barwidth=.8 GROUP=COLOR_SCHEME           name='COMPLIANCE'; One more question BTW- DO you know where there is a list of all the "skins"? I cannot find one anywwhere. Thanks again. Lawrence ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes from
View All
Quick links