1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
proc import datafile="/home/u44593168/timesheets_sas.csv"
out=work.raw
dbms=csv
replace;
getnames=no;
run;
data work.clean;
set work.raw;
project = VAR1;
date = VAR2;
hours = VAR3;
drop VAR1 VAR2 VAR3;
run;
proc sort data=work.clean;
by project date;
run;
proc timeseries data=work.clean
out=work.final;
by project;
id date interval=day accumulate=total;
var hours;
run;