Hello.   I am having difficulty recoding the first observation in a group. Basically I need it to recode the occupied variable to a Y when both conditions are met. What I'm getting is all variables recoded to Y where the first condition is met (occupied = 'N').   Please see the attachment.   Thank you very much for any help out there.     data op23a_04; set op23a_03; by locacde number count_date occupied; if (occupied = 'N' and first.occupied = 1) then do; occupied = 'Y'; end; else do; end; run; ... View more

Good afternoon.   I wonder if someone might be able to answer a question on a hash values? I am very new to this concept, sorry.   We are having a discussion on the security of hash values and I came up with a question.   The question is if I have a hashed value (and I know the original value) and a table of many other values (that does contain the original unhashed value someplace in the many table) can I then hash all values in the "many" table and then compare the original hash value with the hashed values from the "many" table to find the matched value?   For some reason I cannot get SAS to match the values an pull out the orignal variable value.   Thank you so much for any help.   Jeff     Example Code:   data test_code; format hash hash_copy hash_diff $hex64.; hash = sha256(ss_number); hash_copy = sha256("fox"); hash_diff = sha256("fox"); if(hash=hash_copy) then test_copy = 'T'; else test_copy = 'F'; if(hash=hash_diff) then test_diff = 'T'; else test_diff = 'F'; run;   Original value - fox Hash Value - 05A8475FEEBBFEA685ECE06045BE63722EDC61BB2ADE8060A9F03AED6D49F454 Hash Copy - 776CB326AB0CD5F0A974C1B9606044D8485201F2DB19CF8E3749BDEE5F36E2 Hash Diff - 776CB326AB0CD5F0A974C1B9606044D8485201F2DB19CF8E3749BDEE5F36E2   Many table hen - Hash Value - 05A8475FEEBBFEA685ECE06045BE63722EDC61BB2ADE8060A9F03AED6D49F454 Hash Copy - D44A08DE3981889DAE0F7BA3980EA9FD24768279FC4EC2FBBDBCF3BF9FE65C22 Hash Diff -  D44A08DE3981889DAE0F7BA3980EA9FD24768279FC4EC2FBBDBCF3BF9FE65C22   pig - Hash Value - 05A8475FEEBBFEA685ECE06045BE63722EDC61BB2ADE8060A9F03AED6D49F454 Hash Copy - F0B8C9D84DD2B877E0B952130B73E218106FEC04C23852271D390213A1FF96F4 Hash Diff -  F0B8C9D84DD2B877E0B952130B73E218106FEC04C23852271D390213A1FF96F4   fox - Hash Value - 05A8475FEEBBFEA685ECE06045BE63722EDC61BB2ADE8060A9F03AED6D49F454 Hash Copy - 776CB326AB0CD5F0A974C1B9606044D8485201F2DB19CF8E3749BDEE5F36E2 Hash Diff -  776CB326AB0CD5F0A974C1B9606044D8485201F2DB19CF8E3749BDEE5F36E2   horse - Hash Value - 05A8475FEEBBFEA685ECE06045BE63722EDC61BB2ADE8060A9F03AED6D49F454 Hash Copy - FD62862B6DC213BEE77C2BADD6311528253C6CB3107E03C16051AA15584ECA1C Hash Diff -  FD62862B6DC213BEE77C2BADD6311528253C6CB3107E03C16051AA15584ECA1C ... View more

I would be most appreciative for any help someone could give me.   I have date values in records where the data scanning process (for some reason) includes an asterisk within the date value. The date is converted to a string when it's scanned so the asterisk is allowed. I can convert the string date to a true date but I am faced with multiple errors because of the asterisks. I've tried various iterations of tranwrd and compress but I can't seem to get it right. I think, (perhaps mistakenly), that the asterisk is being treated as a wildcard in those functions?   Alternatively I could simple exclude anything that is not a valid date since the imperfect scanning process gives me results such as: 00/23/2009 04/2 /90 9   Thanks for any help you might be able to provide.   Sample data: *6/08/2009 5/*1/2009   ... View more