@mcoccia wrote:
I have two different datasets 'rmi.zins' and 'rmi.zpub' Each only have two variables: 'ticker_symboli' and 'ticker_symbolp' respectively the second variable is 'mktcapi' and 'mktcapp' respectively
Other than SORTING those two data sets I do not see any place that rmi.zins or rmi.zpub are actually used.
To use a data set in a data step it must be on a Set, Merge, Update or Modify statement. Which does not occur.
Once a variable is read into the data vector it no longer has any association with the source data set.
I would almost guess that this is sort of an attempt to use logic from a spreadsheet except your data description does not have enough columns to match either of your attempted uses (Do i=1 to 89 or Do j=1 to 4024 so where did those magic numbers come from?)
If you expect to match records on some values of data variables that have different names then perhaps this belongs in proc sql.
Or provide a small sample of data from both the sets and what you expect as a result.
I would also expect that an variable with a name like ticker_symbol or ticker_symbolp might be used to MATCH on but I don't see that anywhere.
... View more