Hello,   SAS VIYA Version LTS  2023.03   I am trying to automate a file download from the FTP but none of the methods I tried worked. The file I am trying to download is csv format and about 4Mb. In all the SAS tests, the connection to the server is successful (so, user and password are correct) and I also connected to that server using WinSCP and downloaded the file manually. Unfortunately, I let the SAS codes running more than 10min and because no results I stopped them manually. The 3 SAS codes I tried are below. I also added the SAS logs (the the logs are almost the same). I linked some of the SAS notes to http://support.sas.com/kb/57/165.html    Thank you for your help.   SAS Code 1: filename test99 ftp 'file.csv' cd='/csv/' host='myhost' user='myuser' pass='pass_example' debug; data work.test; infile test99 dsd dlm='$' firstobs=2; length var1-var58 $100; input var1-var58; run;   Code 1 Log: NOTE: 220-FileZilla Server 1.4.1 NOTE: <<< 220-FileZilla Server 1.4.1 NOTE: <<< 220-Please visit https://filezilla-project.org/ NOTE: <<< 220 welcome to myhost new NOTE: >>> USER myuser NOTE: <<< 331 Please, specify the password. NOTE: >>> PASS XXXXXXXX NOTE: <<< 230 Login successful. NOTE: >>> OPTS UTF8 ON NOTE: <<< 202 UTF8 mode is always enabled. No need to send this command NOTE: >>> OPTS UTF8 NLST NOTE: <<< 501 Option not understood NOTE: >>> OPTS UTF-8 NLST NOTE: <<< 501 Option not understood NOTE: >>> PORT 172,27,4,141,201,245 NOTE: <<< 200 PORT command successful. NOTE: >>> TYPE A NOTE: <<< 200 Type set to A NOTE: >>> CWD /csv/ NOTE: <<< 250 CWD command successful NOTE: >>> PWD NOTE: <<< 257 "/csv" is current directory. NOTE: >>> RETR file.csv NOTE: <<< 150 Starting data transfer. NOTE: The DATA step has been abnormally terminated. NOTE: The SAS System stopped processing this step due to attention. WARNING: The data set WORK.TEST may be incomplete. When this step was stopped there were 0 observations and 58 variables. WARNING: Data set WORK.TEST was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 12:42.47 cpu time 1.21 seconds =================================================================================================   SAS Code 2 filename test99 ftp 'file.csv' cd='/csv/' host='myhost' user='myuser' pass='pass_example' debug; proc import datafile=test99 dbms=csv out=work.test_ftp replace; run;   Code 2 Log NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST. NOTE: 220-FileZilla Server 1.4.1 NOTE: <<< 220-FileZilla Server 1.4.1 NOTE: <<< 220-Please visit https://filezilla-project.org/ NOTE: <<< 220 welcome to myhost new NOTE: >>> USER myuser NOTE: <<< 331 Please, specify the password. NOTE: >>> PASS XXXXXXXX NOTE: <<< 230 Login successful. NOTE: >>> OPTS UTF8 ON NOTE: <<< 202 UTF8 mode is always enabled. No need to send this command NOTE: >>> OPTS UTF8 NLST NOTE: <<< 501 Option not understood NOTE: >>> OPTS UTF-8 NLST NOTE: <<< 501 Option not understood NOTE: >>> PORT 172,27,4,141,202,95 NOTE: <<< 200 PORT command successful. NOTE: >>> TYPE A NOTE: <<< 200 Type set to A NOTE: >>> CWD /csv/ NOTE: <<< 250 CWD command successful NOTE: >>> PWD NOTE: <<< 257 "/csv" is current directory. NOTE: >>> RETR file.csv NOTE: <<< 150 Starting data transfer. NOTE: The SAS System stopped processing this step due to attention. NOTE: PROCEDURE IMPORT used (Total process time): real time 18:58.45 cpu time 1.71 seconds ==================================================================================================   SAS Code 3: filename test99 ftp 'file.csv' cd='/csv/' host='myhost' user='myuser' pass='pass_example' debug; FILENAME b_nfs "/folder1/folder2/home/folder3/b.csv";   data _null_; infile test99; file b_nfs lrecl=32767; input; put _INFILE_; stop; run;   NOTE: 220-FileZilla Server 1.4.1 NOTE: <<< 220-FileZilla Server 1.4.1 NOTE: <<< 220-Please visit https://filezilla-project.org/ NOTE: <<< 220 welcome to myhost new NOTE: >>> USER myuser NOTE: <<< 331 Please, specify the password. NOTE: >>> PASS XXXXXXXX NOTE: <<< 230 Login successful. NOTE: >>> OPTS UTF8 ON NOTE: <<< 202 UTF8 mode is always enabled. No need to send this command NOTE: >>> OPTS UTF8 NLST NOTE: <<< 501 Option not understood NOTE: >>> OPTS UTF-8 NLST NOTE: <<< 501 Option not understood NOTE: >>> PORT 172,27,4,141,144,55 NOTE: <<< 200 PORT command successful. NOTE: >>> TYPE A NOTE: <<< 200 Type set to A NOTE: >>> CWD /csv/ NOTE: <<< 250 CWD command successful NOTE: >>> PWD NOTE: <<< 257 "/csv" is current directory. NOTE: >>> RETR file.csv NOTE: <<< 150 Starting data transfer. NOTE: The DATA step has been abnormally terminated. NOTE: The SAS System stopped processing this step due to attention. NOTE: DATA statement used (Total process time): real time 10:31.49 cpu time 1.02 seconds   ... View more

Hi,   VIYA 2023.03   I would like to create a a dynamic title for a graph chart, where the text displayed to change based on a selection from the graph chart. The method I used so far is using a button bar (similar approach presented in https://communities.sas.com/t5/SAS-Communities-Library/How-to-customize-your-SAS-Visual-Analytics-report-Part-3-Create/ta-p/315058) but because I also have a page filter, every time I select a different value in the filter, the graph changes and there is no selection and hence the button bar display all the possible values. The button bar will display only one value only after I make a new selection in the graph chart. Would anyone have any ideas how to stop the button bar changing when I change the filter value?   Or maybe a different approach not using "button bars" but "text content" and parameters (for this method I couldn't save the graph selection to the parameter)?       Thank you, smm662002 ... View more

Hi,   SAS VIYA LTS 2023.03   The legend (situated below the graph) for a pie chart created with SAS Visual Analytics has changed from displaying the text to "Category". When I click the mouse on "Category" the legend is displayed in a box overlapping on the pie chart. The correct legend text was initially displayed but after reopen the report the legend has been replaced.   Does anyone had the same issue and what was the solution to fix it?   Thank you, smm662002 ... View more

Hello,   SAS Version: 9.4 M5   I have tried to use the function FINANCE 'ppmt' with 0 interest rate but I have received the following warning:    "NOTE: Argument 2 to function FINANCE('PPMT',0,2,120,1000000,0,0) at line 37 column 14 is invalid."   I have used the same parameters in PPMT function and it works.  The code I used is below and the result I was expecting from FINANCE ppmt is -8333.33.    data test2; temp_finance=finance('PPMT',0,2,120,1000000,0,0);  ===>  . temp_ppm=ppmt(0,2,120,1000000,0,0);                          ===>8333.333 run;     data test1; temp_finance=finance('PPMT',0.08,2,120,1000000,0,0);           ===> -8.42762968 temp_ppm=ppmt(0.08,2,120,1000000,0,0);                                   ===> 8.4276296798 run;   A similar issue has been raised for FINANCE 'pv' (Solved: Invalid argument to function FINANCE 'pv' with 0 interest rate - SAS Support Communities) and it looks like a bug.   Regards, smm662002   ... View more