Hi All,
I have two data sets. Attached are them in xls format. Rainfall_data has rainfall value for each day for different years. Where as Cover_index has START_DATE and END_DATE for a particular phase. Now i want summation of rainfall for each year only for those dates that lies between START_DATE and END_DATE from Cover_index . I used the code as below:
PROC SQL;
CREATE TABLE TEST AS
SELECT YEAR(B.DATE),SUM(B.RAIN) FROM COVER_INDEX A, RAINFALL_DATA B
WHERE (DAY(B.DATE) BETWEEN DAY(A.START_DATE) AND DAY(A.END_DATE))
AND (MONTH(B.DATE) BETWEEN MONTH(A.START_DATE) AND MONTH(A.END_DATE))
GROUP BY YEAR(B.DATE);
QUIT;
But its not giving me correct output. Pleae suggest how can we do this.
There is one issue here . That is START_DATE and END_DATE has values 20Jun2010 and 09Jul2010. But i want summation of rainfall for dates that lies between 20jun and 09jul for all the years given in Rainfall_Data
Guys help me out.
Looks like you have an emergency ,
PROC SQL;
CREATE TABLE TEST AS
SELECT YEAR(B.DATE),SUM(B.RAIN) FROM COVER_INDEX A, RAINFALL_DATA B
WHERE B.DATE BETWEEN mdy(month(A.START_DATE),DAY(A.start_DATE),year(b.date))
AND mdy(MONTH(A.end_DATE),day(a.end_date),year(b.date))
GROUP BY YEAR(B.DATE);
QUIT;
It may have typos, but you get the idea.
Haikuo
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.