Displaying 2 results from an estimated 2 matches for "stn_num".
2010 Feb 17
3
sql query variable
This is the very last thing I need to make everything work properly. My
query:
sqlQuery(conn, "select to_char(lsd,'yyyy-mm') as yr,ttl_mo_prcp from
mo_rains where stn_num=023000")
Is there a way to may the stn_num in the query variable, ie make it so that
whenever my script is run, the user must choose and input the station
number?
Cheers.
--
View this message in context: http://n4.nabble.com/sql-query-variable-tp1558189p1558189.html
Sent from the R help mai...
2010 Feb 15
4
Separating columns, and sorting by rows
Dear anyone who knows more about R than me (so everyone). I have been bashing
my head on the keyboard all day trying to do something with my table.
I have some data, like so:
yyyy-mm Rainfall(mm)
1 1977-02 17.4
2 1977-03 34.0
3 1977-04 26.2
4 1977-05 42.6
5 1977-06 58.6
6 1977-07 23.2
7 1977-08 26.8
8 1977-09 48.4
9