topic Re: Exporting The variable value from SAS to UNIX in SAS Programming

Exporting The variable value from SAS to UNIX

Uli — Mon, 16 May 2011 12:39:53 GMT

Dear All,

Can you please help me out of this issue.

I hacve created sample.sas program, please find the program below.
sample.sas program :

data a;
input a $5.;
datalines;
hello
howru
;

proc sql;
select a into :id separated by ',' from a ;
quit;

data _null_;
call system('export var="&id."');
run;

I have created samp.sh program , here i am executing the sample.sas program and print the output from SAS program in UNIX environment. I am not getting the result.

*shell Script:
samp.sh

#!/usr/bin/ksh

sas sample.sas

echo $var

Could you please help me out about the above issue. I have used X command as well.

Thanks In Advance.

Best Regards

Re: Exporting The variable value from SAS to UNIX

Peter_C — Mon, 16 May 2011 18:02:24 GMT

might try replacing
call system('export var="&id."');
with
call system("export var=""&id.""");
If the shell script command "export" supports single quotes, then use
call system("export var='&id.'");

Re: Exporting The variable value from SAS to UNIX

Ksharp — Wed, 18 May 2011 01:23:46 GMT

Maybe You can code like this:
[pre]

data a;
input a $5.;
datalines;
hello
howru
;
run;
data _null_;
set a end=last;
file '/usr/bin/ksh/samp.sh';
length id $ 500;
retain id;
id=catx(' ',a);
if last then do;
envir_var='export var='||id;
put envir_var;
end;
run;

[/pre]

Ksharp

Re: Exporting The variable value from SAS to UNIX

TimB_SAS — Wed, 18 May 2011 20:00:58 GMT

Check this SAS Note: http://support.sas.com/kb/9/089.html

Re: Exporting The variable value from SAS to UNIX

Clarke_Thacher — Wed, 25 May 2011 19:58:06 GMT

The reason why this is so difficult is because environment variables are inherited by the child process but the parent process is unaffected by the child process.