@andreas_lds Yes, there are observations where tp_2^= 0 in the data. ... View more

Another possibility is to read the dataset twice in the same data step, e.g.: data want; set have; by can_id; if first.can_id then do until(last.can_id2); set have(rename=(can_id=can_id2) drop=field_1-field_3); by can_id2; output; end; drop can_id2; run; ... View more

Here first ID both records dates l_date & m_Date have same days difference (28 days) , it means m_date should populate for both records ? ... View more

data expect; input (col1-col10) ($) ; cards; A B B C . D A . A . B A . C A D A B . . A B B D D D . . . . A . B C B D A . . . A B B C . D A . . . . . C D E F . . . . A B . . E F . . . . ; data want ; set expect; length temp $ 200; array x{*} $ col: ; do i=1 to dim(x); temp=cats(temp,coalescec(x{i},'.')); end; flag=ifn(prxmatch('/[^\.]+\.+[^\.]+/',strip(temp)),1,0); drop temp i; run; ... View more

Yes, this works. Thank you @Patrick  ... View more

data one; input col1 $ col2 $ col3 $ col4 $ col5 $ col6 $ col7 $ col8 $ col9 $ col10 $; cards; PM MM JM MM PM PB . . JM . PM MM JM MM PM PB JM . . . PM MM JM MM PM MB PM JM . . PM MM JM MM PM PM MM MB . PB PM MM JM MM PM PM MM DB . AB ; data new; set one; length temp $ 2000; temp=catx('|',of col:); if prxmatch('/(JM|PB)$/i',strip(temp)) then flag=1; else flag=0; drop temp; run; proc print; run; ... View more

If you are going to have a lot to questions about stuff like this, especially if you get to "at least X yes values", "at most" "more yes than no" or similar you may want to save yourself a lot of headaches and either convert the Yes/No to 1/0 (my choice) or reduce them to single character Y/N. If values are numeric 1/0 coded then you have the functions SUM, that would give a total number of 1's, N the number of variables with any value, Nmiss the number of missing, Range largest - smallest (1 as range tells you that there are some of both values and 0 that all populated values are 1), mean decimal percentage of 1's,   Or using the single letter you could combine them into one string and use Countc to get counts of Y and N.   Also if any of your actual values include MISSING between values you should include some in the examples. ... View more

Thank you! ... View more

A few things.   Why? You seem to have only 8 obs appended to your original data? Is that an error? Are there always 2 data sets or could there be more? And are there more than 1 group in your data sets? ... View more

Are there any variables that appear in B that do not appear in A? Are there any variables in A that do not appear in B? If not it appears that you just replace A with B to have the numbers match. So I suspect there are details you are leaving out.   I would suspect additional variables like age, or age group, as well to be somewhere from the Census data I have worked with.   "Didn't work" is awful vague. Are there errors in the log?: Post the code and log in a code box opened with the "</>" to maintain formatting of error messages. No output? Post any log in a code box. Unexpected output? Provide input data in the form of data step code pasted into a code box, the actual results and the expected results. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the "</>" icon or attached as text to show exactly what you have and that we can test code against. ... View more

I don't understand what you mean.  Why would need to create observations? If you have a count of 65 and another count of 100 to figure out that the difference is 35 you just need to subtract. proc sql; create table want as select category , a.count as CENSUS , b.count as PRESENT , a.count - b.count as NOT_PRESENT from census a inner join present b on a.category = b.category ; quit; ... View more

Thank you, Sir! This worked. Much appreciated. ... View more