If you there is absolutely no other code after your "endhere", in other words you simply want the whole program to stop, code: if &have_file='No' then abort return; otherwise use the macro %IF suggestion that others wrote. ... View more

Thanks. I looked in the FAQs and none of those suggestions worked. Posted in the Analytics U Community. And I'm the queen of tagging people @BeverlyBrown ! 🙂 ... View more

Hi @BeverlyBrown ! I just tried to sign in to SAS OnDemand for Academics for the first time and got the following error. I don't know what a federated SAS profile is. I'm using my only email address which is an gmail.com one. So I don't think I can create another profile, nor do I want to.  Any idea how this can be fixed? Thanks! Michelle Buchecker Incompatible Profile This SAS Profile does not meet the compatibility requirements of SAS OnDemand for Academics. You will need to sign up using a different profile instead. If you wish to use a different profile, then return to the Sign In page. If you have no other profile currently but would like to create one, then visit https://www.sas.com/profile/ui/#/create. When creating your profile, note that SAS OnDemand for Academics is not compatible with federated SAS Profiles. ... View more

And here I thought I was flying under the radar @MichelleHomes ! 🙂  ... View more

🤣 ... View more

@ChrisHemedinger just now saw that we were supposed to use our community name as our trivia name. Sorry, I thought it would link by login profile. I was Michelle B.  thanks again for running this! Lots of fun! ... View more

Because the log shows: EDW_Member_Sub_Program_Code=. that means this var is still being read as numeric. Notice how MMIS_Public_Health_PGM_Code2= That there is a blank after the equal sign instead of a period. Because there is a period after the equal sign for EDW_Member_Sub_Program_Code that's how we know SAS still thinks it is numeric. Can you show us the log that has not only what you have in the previous post, but with the code in the log as well? ... View more

Looking at the data, EDW_Member_Sub_Program_Code and FPL_Range_Code should be character. Please change those to $, and rerun the code and show the log and code. ... View more

I agree with the above comments. But a wild guess is that you also need to add the DSD option to the end of your INFILE statement. ... View more

Buenos dias Jairca. Esta publicación tendrá la información actualizada https://communities.sas.com/t5/SAS-Global-Forum-2020/How-is-SAS-responding-to-current-health-concerns-in-regards-to/gpm-p/628285 ... View more

Hi, I'm not really sure what your desired output is, but this code simplifies a lot of what you were attempting to do. I'm just not sure how you wanted to handle the missing value. In SAS, missing values are treated like negative infinity, so any date will be larger than the missing date.   data have; infile datalines missover; input id date : yymmdd10.; datalines; 1 2019-12-17T13:30 1 2020-01-16T12:15 1 1 2019-12-19T14:25 ; proc print; run; proc sql noprint; create table want as select distinct id, max(date) as edt format = yymmdd10. from have group by id order by id; quit; Michelle ... View more

I think the FDR memorial is a hidden gem. I also like the Spy Museum, and Ford's Theater.    - Michelle Buchecker ... View more

proc sql;  select name, birthdate, test   from a except select name, birthdate, test   from b;   should do it. ... View more