Hello, Does anyone have an insight to how to do this cleanly? I need to link insider filings to permno. I've been told I need to download the msenames (or mfenames?) data set, but am not sure how to do that. Thanks!
Can you phrase your question more generically? This will help to generate more response.
Right now it's phrased in such a manner that only someone with expertise in your field area and data sets can answer it.
how would you link data from one database with data from another database? i need to sync up the entries across two databases into one master list, sorted by one unifying variable.
SQL join
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.