Hello SAS Communities!    I am new to macro programming and need some help in creating a macro program. Any help will be appreciated! I am wanting to create a macro program named 'GraphStats' which may be used to summarise a numeric variable from any data set.    The macro should be able to generate 2 pieces of output (i.e. the macro should contain 2 steps):  1. A histogram with PROC SGPLOT  2. Summary statistics with PROC SUMMARY    The macro should also contain the following 4 parameters: 1. ‘DSName’ to specify the data set name 2. ‘Vbl’ to specify the numeric variable 3. ‘Stats’ to specify summary statistics. Include the defaults statistics of N, MEAN, and STDEV 4. ‘NDec’ to specify the number of decimals. Include a default value of 1    Thank you,  - James  ... View more

Hello SAS Communities,   I am working with the following Proc Anova which is testing whether the means of a continuous variable are continuous across 3 different states. My code for this Anova is listed here:    ODS OUTPUT ANOVAResults = WORK.Results; PROC ANOVA DATA= WORK.Analysis ORDER = INTERNAL; CLASS State; MODEL AgeAtVisit = State; RUN; QUIT;   Based on the above code, I am wanting to create a macro definition named 'RunANOVA' and specify 2 macro variables named 'Value' and 'Name'. The macro variable 'Value' will be used to create unique data sets containing the results by appending a number to the word 'Results' to create unique temporary data sets (i.e. Results 1, etc.) which will then be combined into one final data set. The macro variable 'Name' should specify the variable to be analysed in the Model statement.   My question: how do I modify the original Proc Anova to include the 'Number' and 'Variable' macro variables?    Thank you, James  ... View more

Hello SAS Communities,    I am working with a data set that is analysing diastolic blood pressure in different categories of ethnicity and race. I am wanting to create a Box Plot with PROC SGPLOT that displays Ethnicity on the X-axis and the diastolic blood pressure values on the Y-axis. I have been able to create a plot with all specifications that I desire, except the values and labels for the X-axis. These values do not display in the final output.   My Question: How do I get the x-axis values to display? Why are they not displaying?    Here is the code that I have currently written in efforts to generate my plot. I have also included the current output that I am receiving from this code.      PROC SGPLOT DATA = WORK.Analysis NOAUTOLEGEND; VBOXDBP/GROUP = Ethnicity FILLATTRS= (COLOR = BLUE) LINEATTRS= (PATTERN = SOLID) WHISKERATTRS= (COLOR = BLACK) ; STYLEATTRSDATACONTRASTCOLORS= ( BLACK ); STYLEATTRS DATASYMBOLS= (CIRCLE);   REFLINE 90 /AXIS=Y LINEATTRS=(COLOR=GREEN) LABEL='Diastolic Value' LABELLOC= INSIDE LABELPOS= MIN;     XAXISVALUES= ( ' ... ' ) OFFSETMIN= 0.2 OFFSETMAX = 0.2 LABEL= 'Ethnicity' LABELATTRS= (WEIGHT= BOLD);   YAXISVALUES= (0 10 20 30 40 50 60 70 80 90 100 ) OFFSETMIN= 0 LABEL= 'Diastolic Measurement' GRID LABELATTRS= (WEIGHT= BOLD);     INSET'WORK.Analysis (As of November 11, 2004)' /POSITION= BOTTOMRIGHT BORDER TITLE = 'Data Source:' TITLEATTRS= (SIZE= 9 PT WEIGHT= BOLD) TEXTATTRS= (SIZE= 8 PT STYLE= ITALIC);   RUN;   Thank you very much for all of your help in advance.  - James ... View more