Okay, I've found a workaround to this problem and thought of sharing here for closure and if someone goes through the same issue. Since clearing the libname wasn't working, I decided not to use it altogether, and to replace any mention to UserHome for something else. Depending on what you're doing, I guess it might be hard to get rid of libname, but for my case it was doable. I found out that you can use actual paths in certain commands, so that's how I was able to solve this issue. After getting rid of using libname, the code became the following: proc sql;
create table "/data/home/&sysuserid/Prompt_Data" as
select trim(Prompt_Input) as Prompt_Input,
trim(Macro_Variable) as Macro_Variable,
trim(Value) as Macro_Value
from Prompts
;quit;
/* Print to report */
title "Table - Prompt variables";
proc print data="/data/home/&sysuserid/Prompt_Data"; run;
... View more