03-14-2018 12:52 PM
I am trying to calculate the firm age based on FISCAL_YEAR_END_OP. I am trying to index the file in order to calculate from the first to late date of the opinion in my dataset. I am not able to output an age based on the code below.
Any help would be greatly appreciated!
proc sort data=opinion;
by COMPANY_FKEY FISCAL_YEAR_END_OP;
if index=. then index=0;
if COMPANY_FKEY = lag(COMPANY_FKEY) then index=index;
if first.index then output age;
03-14-2018 01:00 PM - edited 03-14-2018 01:00 PM
proc sort data=opinion; by company_fkey fiscal_year_end_op; run; data age; set opinion; lag_company_fkey=lag(company_fkey); if company_fkey^=lag_company_fkey then index+1; run ;
I'm not really understanding the point of your last data step.
03-14-2018 01:28 PM
Show some example data. Is your FISCAL_YEAR_END_OP a SAS date value, a numeric that represents a year, something else?
I doubt if your "index" is at all needed.
If your FISCAL_YEAR_END_OP is a year value such as 1994 then this might be as simple as:
Proc means data=opinion range; (or since you are counting with your "index" use N instead of range to get number of records for each company_fkey)
but without knowing what kind of values it is pretty hard to tell whether the calculation you are using is appropriate or not.