BookmarkSubscribeRSS Feed
milts
Pyrite | Level 9
Hi all,

i executed a rsubmit to create a table from dictionary.columns then tried to download the result to my local machine.

however the result table returns 0 observations.

am i doing something possible?

the code goes like this:

options comamid=tcp remote=mysvr;
filename rlink '!SASROOT/connect/saslink/tcpunix.scr';
signon;

libname mylib '/datasets' server=mysvr;
rsubmit;
libname mylib '/datasets';
endrusmbit;

rsubmit;
proc sql;
create table mydict as
select * from dictionary.columns where libname="mylib";
quit;
proc download data=mydict out=mydict;run;
endrsubmit;
1 REPLY 1
milts
Pyrite | Level 9
nvm got careless again.

no need to rsubmit when executing the sql statement as well as the libname statement.

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1612 views
  • 0 likes
  • 1 in conversation