topic Re: Assign a dataset to a lobal dataset via remote submit in SAS Programming

Assign a dataset to a lobal dataset via remote submit

R_Chung — Fri, 28 Jul 2017 08:23:24 GMT

Hello everyone,

I would like to store dataset in a remote subit session to a global dataset.

How could I do that?

example:

%global data global_dataset;

*assume all connection to another host is successed;

rsubmit;

* assume i get a dataset b from the host database;

*this is what I have tried;

data a;

set b;

run;

ENDRSUBMIT:
SIGNOFF;

proc print a;

*a gets no rows

Anyone can help?

Kurt_Bremser — Fri, 28 Jul 2017 08:47:15 GMT

To copy a dataset from the remote to the local session in a SAS/CONNECT context, use proc download.

This:

%global  data global_dataset;

will only put the macro variables &data and &global_dataset into the global symbol table.

R_Chung — Fri, 28 Jul 2017 09:38:24 GMT

it succeeds to get data after editing to

proc download data=b out=a;

run;

However, after running the sas code in Unix, a message is occured:

No registered SAS sessions match target info

Kurt_Bremser — Fri, 28 Jul 2017 09:59:54 GMT

What do you mean by:

after running the sas code in Unix

Please provide context, code and log.

R_Chung — Fri, 28 Jul 2017 10:05:18 GMT

/unix_location> sas myProgram.sas
/unix_location> No registered SAS sessions match target info

ChrisBrooks — Fri, 28 Jul 2017 10:37:17 GMT

Google is your friend.....