Using passed string instead of a file for input?? 1

[mstrgrl]

Has anyone ever passed a string containing input data instead of an actual file for something like a proc import? We are using SAS IntrNet to allow Java code to go from application server to SAS server to run some code then send results back to the app server. My consultant does not want to use a file for input and output.

Thanks!!

 

[ChrisW75]

I've used MQ to pass data from SAS up to a database. I've never used something like that to pass info IN to SAS though.
The only method I've seen for doing something like that is using SYSPARM to pass parameters in to SAS, or system variables.
You can use %SYSGET to get the value stored in a system variable

http://support.sas.com/onlinedoc/913/getDoc/en/mcrolref.hlp/a000543699.htm

Not sure about alternative methods, and I don't really know anything about MQ either as all I did was run code that had already been written.

If your consultant doesn't want to use files then I would hope he has some proposal of how to get potentially large amounts of data back and forth...

 

[klaz2002]

Look into the SOCKET option on the filename statement. You can also use the PIPE option in that same statement. I dump the results of a DOS Dir command this way.

Filename test PIPE "dir c:\";

data test;
infile test;
input &;
run


Hope this helps you,
Klaz

 

[ChrisW75]

Sounds interesting, I'll have to look into that one myself Klaz!