Hello,   I am looking for how to find two different variables but only if they exist within the same group. For example I want a list of groups where both A and B exist together. In the example below, that would be Group 1, Group 3, and Group 4. Thank you!   Group Code 1 C 2 B 3 B 4 B 5 C 3 A 1 B 4 A 5 B 1 B ... View more

Hello,   I am trying to sort my output and am not sure how to insert a few lines in the right place, without re-ordering everything (if possible).   Basically it looks like this, as an example:   blue - 01 red-02 purple- 03 orange- 04 grey-05    These fields are numbered up to 100, with a code that already existed and are in the correct order. However between lets say blue 01 and red 02, I would like to add an additional field (for example green) so it would come after blue and before red. Is there a number I can assign to green, so that it will be listed after red and before purple. For example would 02.1 work, or is there a way to insert without messing up the other fields? There are basically 100 fields that are assigned codes in order, but I need to insert about 5 in certain places. Thanks!  ... View more

Hello, I am wondering if there is a way to use an 'IF THEN' statement where one record can meet the criteria to include the full group. In this example the criteria is if the person is in the USA at any point in the dataset then all of their other records can be included. So for Person A since they were in USA, all 8 records would be included. For person B since they weren't in USA, no records would be included.   person  year fiscal period # of vacations location A 2013 1 0 Canada A 2013 2 0 USA A 2013 3 0 Canada A 2013 4 0 Canada A 2014 1 0 Canada A 2014 2 0 Canada A 2014 3 1 Canada A 2014 4 0 Canada B 2013 1 0 Canada B 2013 2 0 Canada B 2013 3 0 Canada B 2013 4 0 Canada B 2014 1 0 Canada B 2014 2 0 Canada B 2014 3 0 Canada B 2014 4 0 Canada ... View more

Hello, I am having an issue with something in SAS (version 9.4) and could use some expertise! Basically my macro currently looks like this:   proc sql; select count(*) into: thirtyfive_counts from history_upi, dummy_upi_clean, dummy_upi_76, history_upi_76; quit; %macro yyy(when); %if &when ne 0 %then %do; %include 'G:\Groups\HHR\new 35 file.sas'; %end; %mend; %yyy(&thirtyfive_counts);   Ultimately, I want this program(in the include statement) to be run if there are any records in any of those 4 datasets (listed in the from statement). The issue I am having is if one of those datasets is empty (which will sometimes be the case) it is giving me an error and not running the program. However, if I only list the datasets where this is a record, it will work fine. I would like it to run if there is an observation in any of the four datasets. Is this possible? Thanks!   ... View more