is this what you are looking for: proc sql; create table crspyear1 as select a.*, b.fyear from IMPORT as a left join IMPORT1 as b on a.permno = b.lpermno and b.begfyr<a.date<=b.endfyr; quit; proc print data=crspyear1; run;
... View more
Yes I'm using the SAS studio. I have 2 data sets and I'm trying to merge them to proceed with my analysis. what I'm trying to do is to merge one observation from one dataset to the other one.
... View more
I keep getting this message and I'm not sure how to fix it? Can someone provide a step-by-step guidance as I'm new to SAS software. My data has more than 292,000 observations, and do not know how to proceed.
... View more