found an article on WRDS: 2 options for those with the same issue: Option 1: Add "inencoding=asciiany" to your custom libname statements In your SAS code where you specify the library for your saved data, or if you have custom libname statements referencing WRDS data, simply add the option "inencoding=asciiany" to the end of the statements, for example: libname mylib '~/' inencoding=asciiany; libname complib '/wrds/comp/sasdata/d_na/' inencoding=asciiany; Option 2: Change the encoding of your saved dataset to UTF-8 so it matches WRDS data encoding You can change the encoding of your dataset to UTF-8 format with the following code: proc datasets nolist library=mylib; modify mydata / correctencoding=utf8; quit; ... View more

Try this: proc sql; create table temp.SEGMENTS_2 as select DATE, TIC, STYPE, count(Name) as count from temp.SEGMENTS_1 group by DATE, TIC, STYPE; quit; When you use a summary statement (like count() or sum()), any columns that you include in the SELECT statement should also be included in the GROUP BY statement. (In this case, since you want DATE, TIC, and STYPE in your ouput, they should also be in your GROUP BY list.) ... View more

It does not look like "next" either. It appears that perhaps you mean to match on FPI as well as your ticker. Maybe.   Your example output really needs to provide more examples such as what would the result be for AAPL 03783310 20FEB2020 EPS 7 AAPL 03783310 20FEB2020 EPS 8 AAPL 03783310 20FEB2020 EPS 9 AAPL 03783310 16JAN2020 EPS 6  And if your Measure variable plays any role in this you need to describe that as well.   Post the code in a code box opened on the forum with the </> or "running man" icon.   I am going to guess that perhaps you want something like: proc sql; create table want as select a.ticker, a.cusip, a.statpers, a.measure, a.fpi ,b.statpers as odate from WORK.IBES_NEW_APPLE as a left join WORK.IBES_NEW_APPLE as b on a.ticker=b.ticker and a.fpi=b.fpi and intck('month',b.statpers,a.statpers) =1 order by a.ticker, a.statpers descending, a.fpi ; quit; ... View more