12-29-2014 03:57 AM
Iam getting input files in excel format into my local machine. Every time I am manually copying files into UNIX box using winscp tool. I am doing this because Sas eg is configured on UNIX.
Is there a way to read files from windows(local) from Sas Eg which is connected to UNIX.??
Thanks in advance!!
01-06-2015 11:26 AM
Here are the only two options I can think of. Both involve installing software.
Try looking at SAS/Access (this solution would be installed on your local machine - closest to what you're looking for I think)
You can also look at implementing Samba on the UNIX system. (this would be installed on the UNIX server and you'd have to configure it to connect to your local machine).
01-06-2015 12:56 PM
Thank You for the response.
Here is my actual requirement.
1) I get my input files in local machine(windows)
2) Need to run VBA code to read multiple input file and make one file
3) Need to read input file from SAS EG( from Unix env)
4) run some sas logic and create output Excel file
5) export into windows and run vba code to format the report
6) Send report in email as attachment.
currently we are doing this steps manually. Now i would need to automate it.
Since i am using SAS EG i am struggling to copy files from windows to unix automatically vice versa .Another issue is DDE is not working in SAS EG to run VBA codes.
Can any one help me on this to understand the best possible solution.
01-08-2015 01:47 PM
Based on what you're telling me I think you may go another route.
I also use the Putty suite of applications. Two components that would play a role in what you want to do is PLINK (to send a script to execute) and PSCP to copy files. Since the beginning and end of your process requires VBA then I think it's best to create a BAT file that will do the following: execute the VBA script in #2, transfer the files using PSCP for #3, execute the SAS logic (.sas file) using PLINK to transfer and execute an shell script from your machine for #4, download the exported Excel file using PSCP for #5 and execute the VBA code, and finally for #6 I would hope you can email the end result using VBA.
Minus the VBA components I use the above process every week.