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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.