Hi @JeffMeyers , please ignore my previous post (I have tried to delete/edit it, but was not able to). I solved those issues. Now, it runs beautifully, but I get this error message: " ERROR: Insufficient authorization to access /pbr/biconfig/940/Lev1/SASApp/endTB_derived_dict.xlsx." I get the same message whether I try to output the Excel file to a library or to work. I'm working in the web-based SAS Studio environment, in case that offers insight. here's the invocation of the macro: %data_specs(LIBN=derived, OUT=endTB_derived_dict.xlsx, INDEX=(endTB_Case_ID, endTB_Subject_ID, id_baseline_template), CAT_THRESHOLD=15, FORMAT=condensed, ORDER=NAME ); %data_specs thanks, carole
... View more