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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.