topic Re: Group all observation for a given year and a given country in New SAS User

Group all observation for a given year and a given country

alsi21ac — Thu, 28 Apr 2022 09:35:27 GMT

Hi all,

I have a dataset that looks approximately like this

Country year Dis_type type_extreme_temp type_flood

Afghanistan 1990 Extreme temp 1 0

Afghanistan 1990 Flood 0 1

Afghanistan 1992 Extreme temp 1 0

...

Albania 1991 Extreme temp 1 0

Albania 1991 Flood 0 1

...

and I would like to obtain a dataset that looks like this:

Country year type_extreme_temp type_flood

Afghanistan 1990 1 1

Afghanistan 1992 1 0

...

Albania 1991 1 1

...

i.e. I would like to group in the same observation all the disasters occurred in a given year (type_extreme_temp and type_flood are dummies =1 if that type of disaster occurred at least once in that year).

I tried by using proc sort but I didn't succeed.

Any help would be highly appreciated.

Re: Group all observation for a given year and a given country

PaigeMiller — Thu, 28 Apr 2022 09:59:35 GMT

This is a job for PROC SUMMARY

proc summary data=have nway;
    class country year;
    var type_extreme_temp type_flood;
    output out=want sum=;
run;

Re: Group all observation for a given year and a given country

Reeza — Thu, 28 Apr 2022 16:56:22 GMT

Do you want the summary to be the number of events or just 1/0 again? If 1/0 summarize to MAX statistic.

proc means data=have nway  MAX stackods;
    class country year;
    var type_extreme_temp type_flood;
    output out=want max=;
run;

@alsi21ac wrote:

Hi all,

I have a dataset that looks approximately like this

Country year Dis_type type_extreme_temp type_flood

Afghanistan 1990 Extreme temp 1 0

Afghanistan 1990 Flood 0 1

Afghanistan 1992 Extreme temp 1 0

...

Albania 1991 Extreme temp 1 0

Albania 1991 Flood 0 1

...

and I would like to obtain a dataset that looks like this:

Country year type_extreme_temp type_flood

Afghanistan 1990 1 1

Afghanistan 1992 1 0

...

Albania 1991 1 1

...

i.e. I would like to group in the same observation all the disasters occurred in a given year (type_extreme_temp and type_flood are dummies =1 if that type of disaster occurred at least once in that year).

I tried by using proc sort but I didn't succeed.

Any help would be highly appreciated.