I'm looking for a way to read in data from a text file somewhere online, do some simple calculations, and display the output on a page I control. That page should update its results every hour (since the text file is updated hourly.)

I'm not looking for anything complicated, just something that can do something like "If temperature>90 then condition=hot" and then display the variables. I just don't know where to get started or what programming I need.

8/15/2006 3:11:38 PM

excel+remote desktop

[Edited on August 15, 2006 at 3:25 PM. Reason : .]

8/15/2006 3:24:48 PM

depending on what the page looks like, you could use some scripting language coupled with regular expressions

8/15/2006 3:43:08 PM

Shivan, what languages do you know / would you feel most comfortable with? You can probably schedule SAS to do this with the output through ODS.

8/15/2006 4:51:11 PM

^I know some html, have forgotten most of java. I know some SAS, but don't know how to schedule it to do stuff. I'll look into it, thanks.

^^The page is just a text file that looks like this:

YYYY MM DD hh mm WD WSPD GST WVHT DPD APD MWD BARO ATMP WTMP DEWP VIS PTDY TIDE
2006 08 15 19 50 040 2.0 3.0 0.7 7 MM MM 1015.9 27.1 29.3 MM MM -1.2 MM
2006 08 15 18 50 050 2.0 2.0 0.7 8 MM MM 1016.3 27.2 29.3 MM MM -0.5 MM
2006 08 15 17 50 030 2.0 3.0 0.7 7 MM MM 1016.8 27.2 29.2 MM MM -0.3 MM
2006 08 15 16 50 030 1.0 2.0 0.8 7 MM MM 1017.1 27.2 29.0 MM MM -0.0 MM
...

And the problem is that I don't really know any scripting languages. (Just looking for something simple though.)

8/15/2006 5:09:57 PM

What procedure should I use to schedule SAS to do something hourly?

8/16/2006 3:55:02 PM

cron job

8/16/2006 4:00:33 PM

cron job + script written in language of your choice

8/16/2006 4:54:22 PM

file located off site?

script file with a random webhost?

8/16/2006 11:40:56 PM

Quote :

"What procedure should I use to schedule SAS to do something hourly?"

I'd just grab it on a page view, no need to update it if no one is looking.

8/17/2006 12:13:02 AM