Thank you so much for helping me. However what exactly I need is. Here is the problem: Input name $ status ; Cards; Aa active Aa active Aa active Aa active Aa active Bb deactivated Bb deactivated Bb deactivated Dd deactivated Dd deactivated Ee active Ee active Ee active Cc active Cc active ; Run; O/p should be like this Aa active Aa active Aa active Aa active Aa active Cc active Cc active Cc active Ee active Ee active Ee active Ee active Ee active Cc active Cc active How do we do that? ##- Please type your reply above this line. Simple formatting, no attachments. -## ... View more

Yes thank so you much for your prompt response ....I'll definitely implement those steps in my program ... ... View more