If your having difficulty with something, then you will need to post exact and complete test data which covers the issue.  Follow; https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712   I can't tell anything from what you have posted about the data.  There are a couple of typos in what you have posted though: rdummy{i}=nyc * dummy{i}; If nyc or dummy{i} is missing then multiplication wont work if dummy{i}=1 & nyc=1 then rdummy{i} This doesn't do anything, no assignment, missing semicolon, you also drop the =1 from both checks as if 1 is always true. logic{i}=ifn(nyc and dummy{i},1,0); ... View more

It works 🙂 Thank you. ... View more

@abhaykumar wrote: Thank You sir, I was trying this way but I was not knowing about "By -1" thing. and I guess we can increase or decrease by any value by using "by -/+n" step, right? Correct. You can even use values with fractions. Like data test; do i = 10 to 0 by -1.5; output; end; run; ... View more

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000212246.htm Basically the third parameter is for options.  So you could put A in ther to add all alphabetic characters to the list of complress characters.  In my case I use K to reverse the logic of the function, instead of dropping those in the list I keep them, so you could look at like compress the text Keeping Digits. ... View more