Hi,   Wonder if you can help. I'm trying to create a new variable which brings in variable names where they equal 1. For example Reason is the variable I want to create.   Application_number A B C Reason 5002 1 1 0 A,B 5003 1 1 1 A,B,C 5004 0 0 1 C 5005 1 1 1 A,B,C   I've tried a VNAME but could only get it to bring in 1 hit. My data source has 49 variables that could have a possible 1.   Thanks Dan ... View more

Hey there, Novice to SAS so bear with me. I have a large data set where I am trying to create a new data set of duplicates. I am using postcode as the duplicate but then I want to bring in if the date of birth field also matches on the row. I tried a proc sort nodupkey but I think it’s just give me a clean list and then a duplicates list. I just want to see the ones which have duplicated on both criteria in a data set. Any help would be greatly appreciated. Thanks ... View more