Very depth explanation, Thank you. ... View more

Worked, Thanks ... View more

Use a double DO loop: data want; do until (last.item); set have; by id item; maxprice = max(maxprice,price); end; do until (last.item); set have; by id item; if price = maxprice then output; end; drop maxprice; run; ... View more

What number did you expect?   If you have binary string 0001 and you flip all of the zeros to ones you get 1110 which is the number 14.  You do not get 0.   If you want to limit it to fixed number of bits use the MOD() function. ndigits=1 ; bnotx=mod(bnot(x),2**ndigits);   Let's look at all 16 possible values of 4 binary digits. data test; do x=0 to 7; bnotx=bnot(x); bnot4=mod(bnotx,2**4); put / (3*x 3*bnotx 3*bnot4) ( binary4. +1 hex8. comma14. /); end; run; 0000 00000000 0 1111 FFFFFFFF 4,294,967,295 1111 0000000F 15 0001 00000001 1 1110 FFFFFFFE 4,294,967,294 1110 0000000E 14 0010 00000002 2 1101 FFFFFFFD 4,294,967,293 1101 0000000D 13 0011 00000003 3 1100 FFFFFFFC 4,294,967,292 1100 0000000C 12 0100 00000004 4 1011 FFFFFFFB 4,294,967,291 1011 0000000B 11 0101 00000005 5 1010 FFFFFFFA 4,294,967,290 1010 0000000A 10 0110 00000006 6 1001 FFFFFFF9 4,294,967,289 1001 00000009 9 0111 00000007 7 1000 FFFFFFF8 4,294,967,288 1000 00000008 8   ... View more

@jebjur , @kschott - Now waiting for the "freeze column" feature to be added back in too! ... View more

Thank you all for your interest and help. I ultimately found it easier to fix the columns in Excel and then re-import and merge them.   I appreciate your time. ... View more

I currently have a sas data set where each observation has 3 attributes. However, the text input has 5 per row with multiple rows. How do I tell sas to read the first 3 values in the row as an entry, then the next three, etc before moving to the next line? Basically, if one input row looks like this: 4 4 10 2 2 10 5 5 10 6 6 10 9 9 10 I want it to end up like this in the sas dataset: 4 4 10 2 2 10 5 5 10 6 6 10 9 9 10. ... View more

😂😂 ... View more

To get the desired result use the proc sort procedure, then use first.store to get the new_items else old_items.   Please refer to code- proc sort data=dt; by id year store; run; proc sort data=dt; by store; run; data dt1; set dt; by store; if first.store then old_new = "New"; else old_new= "old"; run; -Vijay ... View more

Could you please provide us with the sample data and explain with any example where the values are doubling up? ... View more

I believe you can achieve this by using proc sort and last.id-   Try this- proc sort data=test1; by id date; run; data tmp; set test1; by id; if sum(of rate_:) = 4; run; proc sort data=tmp; by id ; run; data tmp1; set tmp; by id; if last.id; run; -Vijay ... View more

Thanks all - very helpful. Was not aware of the minoperator. ... View more