Hard to tell what may be going on. Have you tried using options mprint or  adding a %put _user_; statement after the proc sql to see what your code is resolving to? Are you getting any errors? If so what are they? ... View more

The question is different but looks like this one. https://communities.sas.com/communications. My first thoughts would be using scaproc and run those as Linus did the proposal in that thread. Analyzing programs without running those can be a hard challenge. SAS macro-s are possible change code. Perhaps you can set all access on data/programs read-only and run the code with having obs=0 being set. The code generation done as part of dataset content will be missed.     ... View more

Oh, sorry.  And let me add that he doesn't want the users manually uploading the data themselves. ... View more