Refer to the link to SAS Documentation I included. Example 4 uses the DIR option to the filename statement when using SFTP. It gives you a directory listing as output which you can then parse to figure out what files you want to include.   Example 4: Reading Files from a Directory on the Remote Host This example reads the files  test.dat  and  test2.dat  from a directory on the remote host.   filename infile sftp '/users/xxxx/' host="unixhost1" dir; data _null_; infile infile(test.dat) truncover; input a $25.; infile infile(test2.dat) truncover; input b $25.; run; ... View more

You should be able to use the DIR option to get a listing of files in the folder. You could then parse that listing to determine which files have the dates you want and "get" them by name.   https://documentation.sas.com/?docsetId=lestmtsglobal&docsetTarget=p0xln1fiwsr340n1xxf4mkmfxp6f.htm&docsetVersion=9.4&locale=en     ... View more

I don't see the SFTP hostname in your code.  You might need &username@&hostname . ... View more

Is your windows server mapped/mounted to the Unix server?  Or are you running software like Samba to make the Windows server visible to Unix?  If not, Unix will not be able to "see" the windows server. ... View more

Make sure there is a period ('.') after your format... so it should look like FORMAT CIK $10.;   And yes, the variable COMPANY_FKEY needs to be defined in the work.test dataset  if you are going to test its value in the workingdata data step. ... View more

That's fine..I was just trying to show you an example of how to use the INTNX function to do what you wanted: Using: intnx('month', mydate, 0, 'B');   ...where "mydate" is your date variable should give a date that is the beginning of the same month/year.    Good luck! ... View more

I couldn't reproduce the error you were getting. As long as I use a valid FROM and TO email address, your code worked on my system (after creating a dataset named "overall"). Maybe you can rerun and show the log section with the error (delete any email addresses)? ... View more

I don't know of a format that would do it, but the INTNX function can do it:   data test;   mydate = mdy(1,4,2017);   newdate = intnx('month', mydate, 0, 'B');   put mydate= mmddyy10. newdate= mmddyy10.; run;   log: mydate=01/04/2017 newdate=01/01/2017 ... View more

"Maxim 23 Recursion. See Maxim 23."   Nicely done.  Although, I think seeing recursion in a SAS program would blow most SAS programmers' minds. ... View more

The "sequence does not exist" error usually is telling you that the Oracle sequence (s_id) either has not been created or the user ID you are using to access it doesn't have permission in Oracle to access it. I don't see anything wrong with your Proc Sql code. ... View more