Hello @user021 .  Unfortunately I haven't had time to update this macro lately.  The company I work for doesn't currently use this macro and I've been busy with my family and haven't had as much time to work on my personal macros.  I can try to take a look at adding the 95% CI of the mean (I think that's just +/- 1.96 STD correct?).  I think adding 95% CI for a proportion would be quite a bit more work given how the macro is constructed.  I think that would require getting the binomial CI for each level individually unless there's an option in PROC FREQ that I'm missing. ... View more

Thank you @ChrisHemedinger .  I went back in to see options.  I have a button for Save and a button for "Submit for Review."  I tried clicking the Submit for Review (sorry it made another waiting for review version) to see if there is a pop up to skip to publish, but it sent it out for review again. ... View more

Hello @User04 .  I submitted an update to this page with the new version some time ago (and for another macro of mine) but it is still waiting for review.  I think I need to contact support for this.   @ChrisHemedinger Do you know why my updates submitted a few months ago are still marked as waiting for review?  I haven't been able to post the updated version to a couple macros. ... View more

The goal in the end is to make something automated within a macro where the axis intervals are not linear like this square root transformation or log transformation.  I am hoping to have a variable that has the transformation (e.g. x2=sqrt(x) and then plot x2) but then format the axis so that the original scale is shown.  The macro I am writing will cover a wide variety of lab types so the ranges are quite different and are quite difficult to make manual formats for especially with outliers blowing up the axis range.  If I could just take whatever value SAS picked for tick values and apply a transformation to them somehow it would work, but I don't think it's possible without applying a format/function. ... View more

Hello @sskt .  I have an update to the article up for review with a new version of the macro attached.  When the review is finished it should be available for download. ... View more

Hello @beloko , I tested your scenario with the current version of the macro and I don't see the issue happening there.  When the article updates with the new version attached (tablen_05102022.sas) I would try with that version: %tablen(data=sashelp.cars,var=type horsepower type,type=2 1 2,by=origin,dis_order=1|1);   ... View more

Hello @NovGetRight .  Thank you for the suggestion.  I have come across situations like this as well and am learning to account for them in future programs. ... View more

Hello @SASuserlot  My apologies for not getting back to you sooner.   1. I would like to change the color of the text where it creates the  hyperlinks for example in " Top summary" sheet. in columns with with dataset name will hyperlink to other sheets in the file. I want to change the color of dataset to blue so we know its as hyperlink. I played around the first proc report column styles but it did not worked for me. Any ideas  --You can do this within a compute block.  There should be a number of CALL DEFINE statements that are assigning the URL for the hyperlinks.  If you go to where these are made and at the same time add something like CALL DEFINE('column name','style/merge','style={color=blue}'); it should color the font blue.  BACKGROUNDCOLOR will change the fill color.   2.  Is this macro through any notes/ warning to indicate if one of the library missing the dataset  lets say one have 3 datasets and another have 2? . I understand that 'select '  macro variable have the ability to select the datasets. --If a dataset is in one library but not the other it would only be visible in the first sheet summary.  There should be dates for the dataset that exists and nothing for the one that doesn't   3.  Is it gives any indication or notes or warning about if 'compare' dataset missing the one of the variable in the ID macro variable compare to base dataset? Ex: lets say base have variables 'usubjid studyid siteid' but compare have ' usubjid studyid' only. If we call ID macro variable with 'usubjid studyid siteid', is it gives any notes or warning one of the dataset missing the values or it will just run with the common variables? --There are no warnings or notes to indicate which ID variables exist or don't in each dataset.  These are only listed on the first page summary.  This is because each dataset can have a different combination of variables so there was no reason to add warnings in this case. ... View more

Hello @Anita_n .  Sorry I wasn't able to reply.  I have a paper submitted to PharmaSUG next year that if accepted will walk through how I make both a Sankey diagram and a Sunburst chart in more detail.  My current iteration of these programs looks like the following (note this is run on bogus random data): The counts are added to each node and the connecting lines can either be the group they come from, the group they go to or split half and half.  The paths can be either set to groups or outline each patient moving.  The outlining doesn't work as well unless more points are allowed: Something that has been more popular than the Sankey here has been the Sunburst chart.  This allows you to start in the middle and follow exact paths that patients follow whereas in the Sankey the patients become muddled within each node so specific patients cannot be followed (unless coloring each bar for a patient specifically I suppose, but that is a lot of colors/patterns): I have macros for both of these and if my paper is accepted I will be sharing the techniques and macros on a community page.  If you are interested in trying one of the macros please feel free to e-mail me jpmeyers.spa@gmail.com    ... View more

Hello everyone.  I wanted to apologize for not being to reply to anyone as of late.  My new role no longer uses some of the macros I've created so I don't have as much opportunity or need to make updates, and my current life situation with young children has kept me from making replies/updates in my spare time.  I am planning to try to catch up if I can this weekend.  I am uploading my most recent version of the macro to this article which I will use to test some of these issues. ... View more

One thing to know is that you can nest layout statements. So rather than trying to add a line break just add another layout lattice or add a layout gridded with the number of rows you need and split the text: Entry 'subgroup'.. ; Layout gridded / rows=2; Entry 'column 2 row 1 text'; Entry 'column 2 row 2 text'; Endlayout; Layout gridded / rows=2; Entry 'column 3 row 1 text'; Entry 'column 3 row 2 text'; Endlayout; Entry 'column 4 text'; ... View more

Can you post a picture of what it looks like vs what you want it to look like (modify with paint)? Can cut out the graph part and just show the label. ... View more

Hello @user021 .  I don't know if the last version I updated on this page has this feature but my local one does.  If you e-mail me at jpmeyers.spa@gmail.com I can send the most recent version that I have.  I don't currently use the macro in my current position so I haven't updated it in a while. ... View more