I would like do it respectively . First make these txt file ,then using command to ftp them up to SAS Server. data x;
input obs name $ lastname $;
cards;
1 bob smith
2 sandy lane
3 luke rath
;
run;
proc sql;
create table temp as
select distinct name from x;
quit;
data _null_;
set x;
*output all of txt file under c:\temp\ ;
call execute(catt('proc export outfile="c:\temp\',name,'.txt" data=x(where=(name="',name,'")) dbms=tab replace;run;'));
run;
Then
cd c:\temp\
ftp 10.1.66.14
enter your username and password
>binary
>prompt
>mput *.txt
Ksharp
... View more
