Hi,
After managing to almost finish my code I realized I forgot to add a variable.
What I am currently trying to do is add a command that will chose the closest matching variable do another one.
Right now my code does the following : Matches an inactive company (with dlrsn= 02 or 03) to an active company from the same Industry (Sic Code) with the closest Fyear to the deletion date (DLDTE) of the Inactive company)
As you can see in the picture of my current data set there is a value COSTAT (which tells me when a company is active(0) or inactive(1)) and a value AT (total assets).
I need to make a pair sample. So when a company is inactive (COSTAT=1) I need sas to be able to chose an Active (costat=0) company with the closest AT to the Inactive company
*UPDATE*
This is the closest I have managed to make your code work with my data:
The code:
proc sql;
create table CALICE as
select h.GVKEY as matched_company, h.AT as matched_at,
g.AT as at_to_match
from Altman.size as h, Altman.size as g
where h.COSTAT eq '1' and g.COSTAT eq '0'
group by g.AT
having min(abs(h.AT-g.AT));
quit;I have obtained the following table:
To be honest I have no idea as how I am going to obtain my final table from this , but at least it works and I can go on !
