Displaying 3 results from an estimated 3 matches for "datamonth".
2010 Mar 15
1
inner join sqldf
...ings="NA", check.names=TRUE, quote=
"\"'")
test_sql_innerjoin <- sqldf("select * test_sql_psd inner join test_sql_tsf
on test_sql_psd.prochi=test_sql_tsf.prochi")
colnames(test_sql_psd)
[1] "prochi" "prescribed_date" "dataMonth" "item_code"
[5] "res_seqno" "quantity" "directions" "no_of_packs"
[9] "datasource" "scan_ref_no" "name"
"approved_name"
[13] "form...
2010 Mar 12
7
sqldf not joining all the fields
...skip = 0, check.names = TRUE,fill=TRUE,
strip.white = TRUE, blank.lines.skip = TRUE,
comment.char = "#", allowEscapes = FALSE, flush = FALSE,
fileEncoding = "", encoding = "unknown")
x_data
prochi prescribed_date dataMonth item_code res_seqno quantity directions
CAO0000713 22/06/2001 NULL 842752 NULL 60 1/D
CAO0000713 28/04/2000 NULL 7800 NULL 100G A/TD
CAO0000713 10/04/2000 NULL 842652 NULL 60 1/D
CAO0000713 03/07/2000...
2011 Jan 12
2
aggredating date data
...te into weeks or months as
required?
Thanks.
The input looks like
ID datadate("YYYY-MM-DD") value_for_day
-- ----- -------
-- ------ --------
and I want to be able to change it to
ID dataweek value_for_week
or
ID datamonth value_ for_ month