Apologies if there's an obvious answer to this, but I haven't been able to find it. Let's say I have a macro variable:   %macro do_thing(var); <insert code doing things based on &var here> %mend do_thing; %do_thing(1); %do_thing(2); %do_thing(3); .... %do_thing(9); And I also have a list of values stored in a macro variable: %let list_var = 1,2,5,7,9; If I wanted part of the code in %do_thing to execute only if the value of &var was one of the values in &list_var, how would I do that? My naive expectation would be something like: %macro do_thing(var); <insert code doing things based on &var here> %if &var %in (&list_var) %then %do; <insert &list_var-specific code here> %end; %mend do_thing; But %in doesn't seem to exist.   ... View more

The other day, my cat walked across the keyboard of my work laptop and managed, somehow, to rearrange a bunch of tabs on my open SAS EG (8.3). Rather than try to sort it out manually, I figured it would be easier to reset it to the default and work from there. I've got it mostly the way I want, but the problem is that I previously had it setup so that code, log, results, and output data were all tabs in a single pane, but it's reverted back to splitting them into two subpanes. I can drag them into a single one, but it switches back every time I open a new program. I know I've changed this behavior before, but I can't for the life of me figure out what I did. ... View more

My work laptop had a hard drive failure recently, and I was issued a new one. Along with upgrading me to Windows 11, I was given an upgrade from SAS EG 7.2 to 8.3. For the most part, it's going fine, but I've got two issues that I haven't been able to find a solution for:   1) The browser-style tabs at the top of the main window that list your open, active files--is there a way to get rid of that? I've found the controls for almost everything else--I even managed to wrangle the new log setup into something I'm comfortable with--but I can't find anything that touches that, and it's both unnecessary (I use the project display, which so far serves the exact same purpose in a much more readable way), and regularly causing me to click on the wrong thing and confuse myself (ie, I go to click back to my code from the results or log display, and instead end up in an entirely different code file).   2) The behavior of the run button. My instinct, from previous versions of EG, is to use F8 to run a selected portion of code and the run button to run an entire file. But 8.3 defaults the run button to "run selected", it seems, and I haven't seen the option to change that.   Thank you in advance for any advice! ... View more

I'm trying to add a column with a manual title to an already existing proc report. However, when I add the code to the column line, the resulting report puts all of the new data in the title rows rather than the table, then fills the table cells in with 1. Here's my code:   data test; input col1 $ col2 $ col3 $ col4 $ col5 $ @@ ; datalines; foo bar foo bar foo bar foo bar foo foo foo bar foo bar foo ; proc report data=test spanrows nowd style(header)={bordertopwidth=.5 borderbottomwidth=.5 borderleftwidth=.5 borderrightwidth=.5 borderstyle=solid bordercolor=black}; column ('Overall' (("Group 1" (col1 col2)) ("Group 2" (col3 col4)) ("Group 3" (col5)) )); define col1 / " " style(column)={width=100%}; define col2 / " " style(column)={width=100%}; define col3 / " " style(column)={width=100%}; define col4 / " " style(column)={width=100%}; define col5 / " " across style(column)={width=100% vjust=m just=c tagattr='wrap:yes'}; run; The result I'm getting is this: What I'm looking for is Group 3 to be on the same row as Group 1 and Group 2, and 'foo' to be in the cells where the 1s are. As far as I can tell, my column statement is nested properly, and messing with the the final group doesn't seem to change anything. What am I missing? ... View more

I have the following piece of code that works fine as a standalone pull:   proc sql; connect to teradata (authdomain='LDAP_auth' SERVER= teramed1 mode = teradata); create table test as select * from connection to teradata ( select sub_ed.eci, sub_ed.hh_episode_bgn,count(sub_ed.incurred_dt) as ed_during_ct , min(incurred_dt) as ed_during_dt from sudd02a.hh_3_ed sub_ed left join sudd02a.hh_1_episodes sub_ep on sub_ed.eci = sub_ep.eci and sub_ed.hh_episode_bgn = sub_ep.hh_episode_bgn group by 1,2 where sub_ed.incurred_dt between sub_ed.hh_episode_bgn and sub_ep.hh_episode_end); quit; However, when I wrap the select statement into a left join as part of a much larger pull from Teradata     left join (select sub_ed.eci, sub_ed.hh_episode_bgn , count(sub_ed.incurred_dt) as ed_during_ct , min(incurred_dt) as ed_during_dt from sudd02a.hh_3_ed sub_ed left join sudd02a.hh_1_episodes sub_ep on sub_ed.eci = sub_ep.eci and sub_ed.hh_episode_bgn = sub_ep.hh_episode_bgn group by 1,2 where sub_ed.incurred_dt between sub_ed.hh_episode_bgn and sub_ep.hh_episode_end) ed2 on ep.eci=ed2.eci and ep.hh_episode_bgn=ed2.hh_episode_bgn Enterprise Guide throws the error:   ERROR: Teradata prepare: Datatype Mismatch in THEN/ELSE expression.   I can't figure out what might be causing that error. It's not the ON variables: there's a join just above this one that uses the exact same tables and variables, and it works fine.    ... View more