Not really... this is a University project. We also tried to use this solution instead.. filename in "&dir_proj.wzor.xlsx"; /* PROXY= is important for going outside firewall, if you have one */ /* proxy="http://yourProxy.company.com" */ ; filename out "&dir_proj.excel\&p._&z._&g._&v..xlsx"; data _null_; length filein 8 fileid 8; filein = fopen('in','I',1,'B'); fileid = fopen('out','O',1,'B'); rec = '20'x; do while(fread(filein)=0); rc = fget(filein,rec,1); rc = fput(fileid, rec); rc =fwrite(fileid); end; rc = fclose(filein); rc = fclose(fileid); run; libname xlout XLSX "&dir_proj.excel\&p._&z._&g._&v..xlsx"; data xlout.data; set do_excela; put run; data xlout.data_transposed; set vintage_transposed; run; libname xlout clear; It overwrites the data but the fomatting is decimal not percent and we are struggling to change it after the data is loaded to excel
... View more
