So I have a FTP script that takes a file from my home folder on one linux server to  another. This file is used as a credential file for SAMBA. This will be used as part of a larger program for other developers to shortcut having to manually ftp  this file to different servers.    When the file transfers through FTP it gets corrupted.  This is verified by manually downloading the file and reloading it through a FTP client (reflections FTP)    This is the second time this has happened in that the same thing happened to excel files even when the binary option is used.  Anyone know why this might occur-      Here is the script-It works just fine in terms of moving the data.      filename linhome "P:\cs.txt"; filename srvrdest ftp "/home/&sysuserid/cs.txt" user=&sysuserid host="&serv" cd="/home/&sysuserid" pass="&RITOPASS" binary debug; data _null_; infile linhome; file srvrdest; input; put _infile_; run; filename linhome clear; filename srvrdest clear;       ... View more

Happy Thankgiving week all!       I have a couple of small questions regarding output into Excel with ODS EXCEL.  I am running this on SAS 9.4 M3 on a linux system.    If you look at the attached -I am attempting to simply change the background color of the top headers-  I can do this within the style command for the headers but then it does across the row-which I don't want- I would like to individually change those colors. I have attempted to insert style statements  into:     ("ESTIMATED PERCENT AMBULATION FOR MONTH OF &MO_REPORT" month_num b_denom mon_compliance) between the parentheses w/o success.  I can do this for the ODS PDF destination and that works though.   Also when I use the code style (header)={background=white just=center color=gray font =("arial",8.0pt) bordercolor=black borderwidth=1 frame=box}; It works into the EG windoes environment but  does not render the black borders around cells in the ODS excel output.   Any advice on this?    Some snippet of code below.    Any assistance much appreciated.    Lawrence    proc report data=dfrx.ms_stats_out (where=(fac_id= "xxx")) headline headskip nowd spanrows style (column)={background=white just=center color=black font =("arial",7.5pt) bordercolor=black borderwidth=1 frame=box} style (header)={background=white just=center color=gray font =("arial",8.0pt) bordercolor=black borderwidth=1 frame=box};       columns UNIT ("PERCENT/AMBULATION/FOR/&Flow_Beg" numerator denom pct_compliance) ("ESTIMATED PERCENT AMBULATION FOR MONTH OF &MO_REPORT" month_num b_denom mon_compliance); ...  define UNIT/'Unit' style (header)={background=white just=center color=black font =("arial",8.0pt)}; define pct_compliance/"% Compliance" style (header)={background=green just=center color=white font =("arial",8.0pt) bordercolor=black borderwidth=2}; define month_num/"Numerator " style (header)={background=green just=center color=white font =("arial",8.0pt)}; define b_denom/"Denominator" style (header)={background=green just=center color=white font =("arial",8.0pt)}; define mon_compliance/"% Compliance" style={tagattr='format:0%'} style (header)={background=green just=center color=white font =("arial",8.0pt)}; define Numerator/"Numerator" style (header)= {background=green just=center color=white font =("arial",8.0pt)}; define Denom/"Denominator" style(header)={background=green just=center color=white font =("arial",8.0pt)};   .... run;  ... View more

Hello all-   This is a technical question regarding to what occurs during a set creation- If you are already creating a new dataset from an old dataset and you have some added variables or some other changes can the dataset sort of balloon or expand during its creation and then upon it finishing-then applies compression (if option is set) ?       And can this happen during a data step and/or sql procedure? The reason I ask is that last week-someone's data step suddenly hit the space constraints on a unix server. Although the dataset was only 20 gigs with 30 gigs of space left it was pretty evident it was the activity that led to some further space constraint issues.   Lawrence   Lawrence ... View more

So I have a screenshot below of the website I am attempting to access- In it there there essentially two parameters-beginning and end date-   I also need to pass my uder/password for access. Is there is a "simple" way to do this?   Many Thanks for your time.   Lawrence     ... View more