I would like to ask regarding creating library by using stored process. I have 2 stored process that will 1 library (physical). In the first stored process I created the library and its name based on username;because I have severals users that will use it. And the second stored process is access its library. So, every users has their own library. When I create library in the first stored process is successfull; but when I access it by using second stored process, it said the library is not exist. Here are my code: Test1.sas: *create libary %stpbegin; %global month_from month_to _METAUSER; libname test BASE "<my libref location>"; DATA _NULL_; call symput("table_name",cats("Lib_","&_METAUSER")); run; DATA test.&table_name; *(the problem) month_from="&month_from"; month_to="&month_to"; run; %stpend; Test2.sas:*access library %stpbegin; %global month_from month_to _METAUSER; libname test BASE "<my libref location>"; DATA _NULL_; call symput("table_name",cats("Lib_","&_METAUSER")); run; DATA _NULL_; set test.&table_name; *(the problem) call symput("month_from"),month_from); call symput("month_to"),month_to); run; %stpend; Hopefully, anyone can help me or suggest another way so the 2 stored process can communicate by its own user. Thank You.
... View more