I did see that, but I was able to confirm the credentials, but using them through the other process of CSVs. This sounds like an issue with locks, but I haven't been able to resolve it using the options for the locking methods either. ... View more

@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

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

A suggestion using non-proprietary data. Use one of the SAS supplied map data sets and dummy such as this to create some maps data work.displaydata; input state value; datalines; 1 23 5 18 18 26 21 134 27 44 33 9 ; run; proc gmap map=maps.us data= work.displaydata all ; by state; id state; choro value; run; quit; inside your layout code.   See if that works as expected. If not then you can share an entire document. I also suggest using goptions reset=all; as some goptions seem to persist from session to session.   I ran your layout code with the above map and get a warning from the log: WARNING: COLUMN_GUTTER causes WIDTH to exceed available space for PDF destination. Setting COLUMN_GUTTER=0 to avoid paneling. and only the middle row of graphs actually appeared even though I have the by lines appearing for all 6 maps. My results window with the html output does show all 6 maps in 3 side-by-side pairs though.   I don't work with PDF's much so I'm not sure what other options may be needed. I do note that the layout apparently ... View more

@Delgoffe_MCRI wrote: 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? From http://blogs.sas.com/content/sasdummy/2014/01/29/using-filename-zip/  : For password-protected ZIP files, you'll still need to use external tools like WinZip, 7-Zip, or gzip. This SAS Global Forum paper shows how that can work.     ... View more