Exporting The variable value from SAS to UNIX

[Uli]

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

[Peter_C]

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.'");

[Ksharp]

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

[TimB_SAS]

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

[Clarke_Thacher]

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.