Thank you, that is what I ended up doing. I had to concatenate the variables and then use the input function to create a numeric value. data ex;set ex.exall; ID_all = cats(HHID,PN); run; data ex2; set ex.exall; ID= input(ID_all, 8.); run; Just posting what I found so others might be able to search and find it. Thanks for the replies!
... View more