Hi everyone,   I hope you're all doing well.   I wanted to discuss a recent suggestion from my boss regarding a potential change in our workflow. Currently, we typically execute SAS code on the server and save all related files, including code, datasets, and outputs, directly on that server. However, the new proposal involves saving all of these files on an FTP server while still running the SAS code on our existing server. Despite consulting with both our SAS after-sale engineer and the IT department, we haven't received a definitive answer on whether this approach would be effective.   Therefore, I'm reaching out to the community for any insights or experiences you may have had with a similar setup. Specifically, I'm interested in understanding if running SAS code on the server while storing related files on an FTP server is a viable approach. Your input on this matter would be greatly appreciated.   Thank you,   *************************************************************************** 1、connection is ok between FTP and SAS server,  I can use FileZilla to  upload  or download some files  2、Can I build the libraries direcly using libname xx "FTP path ....." ?  I am not sure ... View more

hi guys, Do anyone have some experience to run vba code using sas studio(https://welcome.oda.sas.com) instead of PC SAS?  Thanks so much. FILENAME myfile '/home/.../VB/test.xlsm'; x 'start excel'; x 'cd "/home/.../VB/test.xlsm"'; x 'excel /e myfile'; x 'application.run "test"'; x 'quit'; https://support.sas.com/resources/papers/proceedings16/7120-2016.pdf#:~:text=SAS%20programmers%20can%20employ%20PUT%20statements%20within%20a,run%20a%20VBA%20macro%20in%20an%20Office%20application. ... View more

data FatComp; input Test Response Count; datalines; 1 1 130 1 0 20 0 1 40 0 0 160 ; /******************************************************************************************* ** kappa *******************************************************************************************/ data kappa1; a=130; b=20; c=40; d=160; p0=(a+d)/(a+b+c+d); pe=((a+b)*(a+c)+(d+b)*(d+c))/(a+b+c+d)**2; se=sqrt((p0*(1-p0)/(1-pe)**2)/(a+b+c+d)); kappa=(p0-pe)/(1-pe); z=PROBIT(1-0.05/2); kappa_low=kappa-z*se; kappa_high=kappa+z*se; run; /*ods trace on;*/ ods output KappaStatistics=Kappa2; proc freq data=FatComp; weight count/zeros; tables Test*Response/agree; /* test kappa wtkap;*/ /* exact kappa ;*/ run; /*ods trace off;*/   hi sasusers,   please take a look at my code to calculate kappa,  the CI value is a little bit different between kappa1 and kappa2 while the estimate is almost same, so how to modify the code ( get the simple kappa in data step with the formula) to have the same result.   use two methods to double qc the kappa, I want get a 100% equal compare report, BTW, how to get the weight kappa using proc freq in SAS9.4.   Thanks. Sky.     ... View more

Hi guys, how to solve this issue , there are unrecognized characters open .xpt using universal viewer ? I can't open v8 xpt using pc sas, why? upload the picture later, thanks ... View more