topic Re: Converting Stata to SAS egen sum in SAS Programming

Converting Stata to SAS egen sum

n7 — Sun, 14 Jun 2020 12:50:16 GMT

Hello,

I am working on converting some Stata code to SAS and running into trouble with a line including egen = sum(another variable):

bys var1 var2: egen vary= sum(varx)

Do you know how this could be translated into SAS code?

Thanks!

Re: Converting Stata to SAS egen sum

ed_sas_member — Sun, 14 Jun 2020 13:55:14 GMT

Hi @n7

Assuming that 'varx' as no missing value and that 'vary' corresponds to the sum of 'varx' value in each subgroup made of a unique combination of 'var1' and 'var2', you can try this:

proc sql;
	create table want as
	select *, sum(varx) as vary
	from have
	group by var1, var2;
quit;

Best,

Re: Converting Stata to SAS egen sum

Kurt_Bremser — Sun, 14 Jun 2020 13:56:08 GMT

I would think it is

proc sql;
select var1, var2, sum(varx) as vary
from have
group by var1, var2;
quit;

see if it gives the same result.