https://communities.sas.com/t5/SAS-Procedures/dictionary-on-rsubmit/m-p/59617#M16828 nvm got careless again.<BR /> <BR /> no need to rsubmit when executing the sql statement as well as the libname statement. Wed, 29 Jul 2009 03:53:42 GMT milts 2009-07-29T03:53:42Z https://communities.sas.com/t5/SAS-Procedures/dictionary-on-rsubmit/m-p/59616#M16827 Hi all,<BR /> <BR /> i executed a rsubmit to create a table from dictionary.columns then tried to download the result to my local machine.<BR /> <BR /> however the result table returns 0 observations.<BR /> <BR /> am i doing something possible?<BR /> <BR /> the code goes like this:<BR /> <BR /> options comamid=tcp remote=mysvr;<BR /> filename rlink '!SASROOT/connect/saslink/tcpunix.scr';<BR /> signon;<BR /> <BR /> libname mylib '/datasets' server=mysvr;<BR /> rsubmit;<BR /> libname mylib '/datasets';<BR /> endrusmbit;<BR /> <BR /> rsubmit;<BR /> proc sql;<BR /> create table mydict as<BR /> select * from dictionary.columns where libname="mylib";<BR /> quit;<BR /> proc download data=mydict out=mydict;run;<BR /> endrsubmit; Wed, 29 Jul 2009 03:23:25 GMT https://communities.sas.com/t5/SAS-Procedures/dictionary-on-rsubmit/m-p/59616#M16827 milts 2009-07-29T03:23:25Z https://communities.sas.com/t5/SAS-Procedures/dictionary-on-rsubmit/m-p/59617#M16828 nvm got careless again.<BR /> <BR /> no need to rsubmit when executing the sql statement as well as the libname statement. Wed, 29 Jul 2009 03:53:42 GMT https://communities.sas.com/t5/SAS-Procedures/dictionary-on-rsubmit/m-p/59617#M16828 milts 2009-07-29T03:53:42Z