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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: