@sassy_seb Check out my export macro. You can get the latest version using my REDCap survey in the previous comments or reading my paper(s) on LexJansen.com by searching "REDCap Your SAS Friend". The most recent one should be listed first.   To answer your question more pointedly - I've circumvented those issues by first downloading the data dictionary via API and using it to define features instead of the code REDCap provides as an export option. This is even more important with the use of style characters in values now.   I will also be presenting new content on REDCap at the SESUG Conference in Bethesda September 22-24th (2024). Registration is still open - as is call for content. https://sesug.org/SESUG2024/index.php  ... View more

Yes, it uses regular expressions to remove HTML, carriage returns, and completely parses the REDCap data dictionary to provide labels and formats to the SAS dataset it creates.   At times you may need to control how it interprets the type of variable it makes based on existing data (ESPECIALLY with missing data codes), but the next version under development will go through and replace text missing data codes with numeric acceptable values before import to avoid that...so stay tuned! ... View more

I have recently published a macro to export REDCap data into SAS along with formats and a data dictionary. Please see my paper, presentation, and code by filling out this survey: https://redcap.link/REDCapIsMySASFriend.   Distribution using this method allows me to distribute only the most recent version, so you can check back to this survey in the future as well.   Also available on LexJansen under SESUG 2022: "REDCap: Your SAS Friend for EHR Manual Abstraction" ... View more

I have recently published a macro to export REDCap data into SAS along with formats and a data dictionary. Please see my paper, presentation, and code by filling out this survey: https://redcap.link/REDCapIsMySASFriend.   Distribution using this method allows me to distribute only the most recent version, so you can check back to this survey in the future as well.   Also available in LexJansen under SESUG 2022: "REDCap: Your SAS Friend for EHR Manual Abstraction" ... View more

I have recently published a macro to export REDCap data into SAS along with formats and a data dictionary. Please see my paper, presentation, and code by filling out this survey: https://redcap.link/REDCapIsMySASFriend.   Distribution using this method allows me to distribute only the most recent version, so you can check back to this survey in the future as well.   Also available on LexJansen under SESUG 2022. "REDCap: Your SAS Friend for EHR Manual Abstraction" ... View more

I have recently published a macro to export REDCap data into SAS along with formats and a data dictionary. There is also a token cloaking macro that will utilize external files to pull in your token and set options to prevent disclosure.   Please see my paper, presentation, and code by filling out this survey: https://redcap.link/REDCapIsMySASFriend. You can also find them on lexjansen under SESUG 2022.   Distribution using this method allows me to distribute only the most recent version, so you can check back to this survey in the future as well. ... View more

I have recently published a macro to export REDCap data into SAS along with formats and a data dictionary. Please see my paper, presentation, and code by filling out this survey: https://redcap.link/REDCapIsMySASFriend.   Distribution using this method allows me to distribute only the most recent version, so you can check back to this survey in the future as well. ... View more

Hello ballardw, Thank you for your comments! The mix in units was an oversight that I hadn’t caught. I’ve fixed that to show inches only and also changed the hpos= to 0. Unfortunately the output has not changed. The titles display correctly in the gridded layout (appropriate size, centered on column, appearing in center of page without being cut off), but the graphs do not.   The bottom of the page has been cut off in the picture because the output correctly appears in the first row of my gridded layout and nothing comes below it. Here is the full page after changes:   The problem is that the first map seems to be centered on the page instead of the first column, and the second map is cut off by the page ending and is therefore only half showing.   I'm using long and lat coordinates in my mapping file so I'm not sure how to change the shape files to display differently if that's what's needed.   Ideally I would like each map to appear in its respective column, centered on the column and column heading. If there is a better way to code this while still using the by statement, I would be open to that as well.   Thanks again! ... View more

Thank you for your quick feedback @ballardw.   Unfortunately, I get this error:   NOTE: The zip file dmf_table_33.csv doesn't exist. ERROR: Physical file does not exist, dmf_table_33.csv.   It seems to not recognize the zipped folder. The files are password protected. Would that make a difference? ... View more