Hi Cynthia,
Thank you so much for your reply and it was absolutely helpful to me as always.
Initially, I knew what I wanted to achieve was more than complicated due to my limited SAS + HTML skills.
I had a chat to my boss yesterday, sat down and try to simplify our process. Our main goal is to use a little programs involved as possible. Due to limited resources available in our company, SAS/IntrNet and SAS Enterprise Intelligence Platform are definitely out of the questions. And we are sticking to SAS Dev 9.1, Excel and Mainframe at this stage.
What I am trying to find out is that, at this stage, I am going to output my datasets into Excel (This is definitely a simple process to do so, no qualms about this). Then someone in my team will manually fill in the points and new price of these vehicles on the spreadsheet.
Now here come the hard bit, my question is that... Once these points and prices been filled up, is there a way to use SAS to copy the details of all these vehicles from the spreadsheet and drop the whole batch into Mainframe? This batch process will happen every fortnight and what we would even like to achieve in the future is that structuring this SAS code in a way that it is able to detect the existence of this Excel spreadsheet in a folder every night and drop it into Mainframe.
If so, I really appreciate that there are articles out there that can help me out in making this happen.
Cynthia, I am not sure if this can be done but all in all your help been greatly appreciated, you have gone far and beyond! This forum can't be any better without you!
Cheers,
Yennie
... View more