Hello,   I am trying to code get a tabulate to work to output all my different outcomes in one table, but i am having issues. I am getting the error  Some records were not included because of missing values   I am not sure why this is or how to get round it.   I have code up variables as a flag = 1 if it meets the criteria.  E.g. If X > 1 then Var1 = 1; If Y > 250 then Var 2 = 1; Count = 1; etc. I am then trying to split these by a flag. I have the data create a mock data shown below:   Flag Var1 Var2 Var3 Var4 Weight Yes . 1 . 1 2 No . 1 . 1 2.5 Maybe 1 . . 1 1 Potential 1 . 1 . 1 Yes 1 . . 1 2   From that data I am then trying to code it to look like this   Then i produce the code PROC TABULATE DATA = DATA; TABLES Var1 Var2 Var3 Var4, Flag*(COUNT); CLASS E1_A_01_HIT E1_A_02_HIT E1_A_03_HIT GBF; VAR COUNT / WEIGHT = Weight; RUN;   I am after the table so i can get it all in one table. All the Flags Yes, No maybe etc would be populated with a number but for this example you can see what I am aiming for. Do you know how to populated this from the table and why the error is being created or another way of getting the table i am after.   Thank you,   Yes No Maybe Potential Var1 2   1 1 Var2 2 2.5     Var3       1 Var4 4 1.5 1       PLEASE FIND THE CODE.   data ORIGINAL; input VAR1 VAR2 VAR3 VAR4 VAR5 WEIGHT FLAG $; datalines; 1 1 . . . 2.5 Z 1 1 1 1 1 4 Y 1 1 . . . 2.5 X 1 1 . . 1 1 Z 1 . 1 1 . 1 Z 1 . 1 1 . 1 Y 1 . . . . 3 X ; RUN; DATA ORIGINAL; SET ORIGINAL; COUNT =1; RUN;   PROC TABULATE DATA = ORIGINAL; TABLES VAR1 VAR2 VAR3 VAR4 VAR5, FLAG*(COUNT); CLASS VAR1 VAR2 VAR3 VAR4 VAR5 FLAG; VAR COUNT / WEIGHT = WEIGHT; RUN;   THE LOG 10547 PROC TABULATE DATA = ORIGINAL; 10548 TABLES VAR1 VAR2 VAR3 VAR4 VAR5, FLAG*(COUNT); 10549 CLASS VAR1 VAR2 VAR3 VAR4 VAR5 10550 FLAG; 10551 VAR COUNT / WEIGHT = WEIGHT; 10552 RUN; NOTE: Some records were not included because of missing values NOTE: 7 observations were read from "WORK.ORIGINAL" NOTE: Procedure TABULATE step took : real time : 0.006 cpu time : 0.015 10553 quit; run;   PROC FREQ DATA = ORIGINAL; TABLE (VAR1 VAR2 VAR3 VAR4 VAR5)*FLAG / NOROW NOCOL NOPERCENT; WEIGHT WEIGHT; RUN;   the Proc Freq outputs what i would like to see but not in the single table i would of would much prefer.   Thanks, ... View more

Hello,   I am looking at counting variables backwards from a start point   The below examples shows what we have. I am looking at these 13 variables and hoping to count backwards to see how many Y's are consecutive from point 13 working backwards. E.g. ID1 = 1 as after this it hits a N, ID2 = 0 as Y comes after this point and ID 3 = 5. data have; input ID (var1-var13)($); cards; 1 Y Y N N Y Y Y N Y Y Y N Y 2 Y Y Y Y Y Y Y Y Y Y N N N 3 Y N N N N Y N N Y Y Y Y Y ; run;   Final Dataset is shown below   data want; input ID (var1-var13)($) Consecutive_Y_from_Var13; cards; 1 Y Y N N Y Y Y N Y Y Y N Y 1 2 Y Y Y Y Y Y Y Y Y Y N N N 0 3 Y N N N N Y N N Y Y Y Y Y 5 ; run;   Any help would be great, Thank you. ... View more

I have a data set and I am trying to count how often this repeats consecutively across a particular volume of variables.   I have shown an example of what I have in the below dataset which has 13 variables, but i am looking at seeing how many Consecutive "Y"'s happen within a particular section. E.g. The example is from Var1-10 but this may change to look at between Var2-8 depending on requirements etc.   data have; input (var1-var13)($); cards; Y Y N N Y Y Y N Y Y Y N N Y Y Y Y Y Y Y Y Y Y N N N Y N N N N Y N N Y Y Y N N ; run;   Below you can see this count conservative Y's and output the largest volume the between var 1-10 giving the largest consecutive outcome between them in the final column. Is this possible to do?   data Want; input (var1-var13)($) Total_Consecutive_Y_10vars; cards; Y Y N N Y Y Y N Y Y Y N N 3 Y Y Y Y Y Y Y Y Y Y N N N 10 Y N N N N Y N N N Y Y N N 1 ; run; ... View more

Hello,   I have Ids which go across time and i want to get them on to one line, but first i need to rename the data. This is where the issues is.  I have an Id which appears multple times, and has over lapping data. E.g. ID 1 but period 1 and 2. Both come with data for Z1 - Z13 however Z2-13 for period 1 and Z1-12 period 2 are the same. I have split the data up into different time frames, so unquie IDS and all i want to do is rename the Z variables to reflect the same time periods. Period 2 would now be names Z2-14 rather than 1-13.  I have put a quick example of what I am after below. Can someone tell me why the macro is not working for the rename.   The issues is the Do loop continues to go round when the criteria doesnt match this and i do not know why.   data original_ALL; input ID Year_period $ Period Year Z1 Z2 Z3 ;   datalines; 1 2019_01 1 2019 100 101 102 1 2019_02 2 2019 200 201 202 3 2019_01 1 2019 1 2 3 ; run;   data original1; input ID Year_period $ Period Year Z1 Z2 Z3 ;   datalines; 1 2019_01 1 2019 100 101 102 3 2019_01 1 2019 1 2 3 ; run;   data WANT1; input ID Year_period $ Start_period Year Period1 Period2 Period3 ;   datalines; 1 2019_01 1 2019 100 101 102 3 2019_01 1 2019 1 2 3 ; run;   data original2; input ID Year_period $ Period Year Z1 Z2 Z3 ;   datalines; 1 2019_02 2 2019 101 102 103 ; run;   data WANT2; input ID Year_period $ start_period year Period2 Period3 Period4 ;   datalines; 1 2019_02 2 2019 101 102 103 ; run;   data all_group (keep = id Period1              Period2 Period3 Period4) a_only b_only; merge want1 (in=a) want2 (in=b); by id; if a and b then output all_group; if a and not b then output a_only; if b and not a then output b_only; run;   %macro rename; Z1 = Period%eval(&j.) Z2 = Period%eval(&j.+1) Z3 = Period%eval(&j.+2) %mend;     %MACRO RENAME_DS;                 DATA WORK.test; SET WORK.original1;   %let PERIOD = PERIOD;   %do year = 2019 %to 2020;                                          %IF &YEAR = 2019 %THEN %DO;                                                 %DO j = 1 %TO 13;                                                                 IF &PERIOD. = &j. THEN DO;                                                                                 RENAME                                                                                 %RENAME;                                                                 END;                                                 %END;                                 %END;  %end;                                                   ELSE IF YEAR = 2020 THEN DO;                                                 %DO j = 14 %TO 26;                                                                 RENAME                                                                 %RENAME;                                                 %END;                                                  END;   RUN; %MEND RENAME_DS;   %RENAME_DS; ... View more