Hi all, Here is my current data with ten columns: co1 col2 col3 col4 col5 col6 col7 col8 col9 col10 PM  MM  JM  MM PM   PB  PM  MM  JM  MM PM   PB   JM  PM  MM  JM  MM PM  MB   PM  JM  PM  MM  JM  MM PM  PM   MM  MB  Goal: I want to flag all records which end with either 'PB' or 'MB' value and there are no values after them across columns and flag if there are values after 'PB' or 'MB' Any help is appreciated. Thanks! ... View more

Hello SAS Community,   I want to find and flag rows if either the first column value 'Yes' or if the value 'Yes' is in sequence across the columns like below. It should either be that first column starts with 'Yes' or be all 'Yes' without any other value in between or no missing. Thank you for your time. Have: T1 T2 T3 T4 T5 T6 T7 T8 T9 T10 Yes No Yes Yes Yes No Yes . . . Yes Yes Yes Yes Yes . . . . . Yes Yes Yes . . . . . . . No No No No No Yes No Yes Yes No   Want: T1  T2  T3  T4  T5  T6  T7  T8  T9  T10   Flag Yes No Yes Yes Yes No Yes  .    .         .     1 Yes Yes Yes Yes Yes . . .                .      .    1 Yes Yes Yes . . . . . . .                                  1 No No No No No Yes No Yes Yes  No        0 ... View more

Hello SAS community,   I have a problem where I would appreciate your time and help.   Let's say I have data A with group ID 'A' and the total sum of the group ID 'A' is 11. I have another data B with the same group ID 'A' and the total sum of the group ID 'A' is 20. Now the difference is 9, I want to expand this difference of 9 into 9 rows by that group ID 'A' and /append/insert into data A. I have put the tables for your reference. data A   Group Sum A 1 A 3 A 4 A 1 A 2 Total 11 data b  Group Sum A 5 A 2 A 3 A 5 A 5 Total 20 expand the difference of 9 into rows  Group Count A 1 A 1 A 1 A 1 A 1 A 1 A 1 A 1 A 1 data want  Group Sum A 1 A 3 A 4 A 1 A 2 Total 11 A 1 A 1 A 1 A 1 A 1 A 1 A 1 A 1 SAS peeps, I really appreciate and thank you for your time and help on this. ... View more

Hello SAS Community,   I have a problem where I would appreciate your help.   My working dataset A has the following information. I am just adding few rows so that you know the issue.   Working dataset A (165 rows) Gender Race  Ethnicity          County M         Black  Non-hispanic    Lincoln M         Black  Non-hispanic    Lincoln M         Black  Non-hispanic    Lincoln M         Black  Non-hispanic    Lincoln   Census dataset B (265 rows, will need to insert 100 rows from this to above dataset to balance to 265) Gender Race  Ethnicity          County M         Black  Non-hispanic    Lincoln M         Black  Non-hispanic    Lincoln M         Black  Non-hispanic    Lincoln M         Black  Non-hispanic    Lincoln Lets say I have 165 rows with this combination in working dataset.   From our dataset B which is our census population, we have 265 rows with the above combination. So, to balance and insert population into the dataset A, I need to add 100 rows with this combination from dataset B to  dataset A.    I have create IDs for rows using gender, race, ethnicity, county and the same thing in census population and tried to join them on these combinations. But it didn't work.   I am not sure how to move forward, please help.   Thank you! ... View more