Here is the solution but in R programming. So can you please change it to SAS programming.   Block <- c("Badlapur","Barsathi","Bhitargaon","Bilhaur","Chaubepur","Dharampur", "Dobhi","Ghatampur","Kakwan","Kalyanpur","Karanjakala","KHUTHAN", "Mahrajganj","Mariahu","Rampur","Shahganj","Shivrajpur","Sikrara", "Sirkoni","SUITHAKALA") NoA <- c(6,7,15,26,20,27,10,15,17,20,80,8,34,18,7,66,20,19,30,12) NoV <- c(3,6,30,63,45,66,15,30,36,45,225,9,87,39,6,183,45,42,75,21) for(m in 1:20){ a <- NoA[m] b <- NoV[m] for(j in 1:a){ for(i in 1:b){ print(paste0(Block[m],j,"_",i)) } } } HTH ... View more

Hi Patrick, Apologies, I am uploading the solution in R programming can you convert it in SAS. ... View more

Thank you sir, but It's not working . ... View more

For Example Block Name= Barsathi No. of auditors Required = 7 No. of Villages = 6 No. of IDs required = 42. So the IDs will be Generate like Barasathi1_1 Barasathi1_2 Barasathi1_3 Barasathi1_4 Barasathi1_5 Barasathi1_6 Barasathi2_1 Barasathi2_2 Barasathi2_3 Barasathi2_4 Barasathi2_5 Barasathi2_6 . . . . . . . . . Barasathi7_1 Barasathi7_2 Barasathi7_3 Barasathi7_4 Barasathi7_5 Barasathi7_6 So total IDs genertaed 42 Where is the problem Sir. ... View more