Thanks, But now description column is showing (- .) Please find the below screenshot   ... View more

Thanks for your response,  But when i am submiting below program with your guidance then i am getting below error. data have; retain ID Description '201201'n '201202'n '201203'n 0; run;   One of my column name id automatically renamed as (- .) , but it should named id only ... View more

Thanks, It is great, works for fine for me ... View more

Hi, Actually i want to do in actual data set But you can guide me in both the way if possible ... View more

Thanks, Superb, it works for me ... View more

Hi, My dataset  looks like as below ID Description 201201  201202  201203  201204  201205  201301  201302  201303  201304  201305 Instead of defining multiple columns in define statement i want only one define statement for 201201 to 201305   Basically my code should be   proc report data=test; column id description  here it should be one macro variable only from that multiple columns; define id; define description; define multiple columns; run; ... View more

Hi, Basically my code should be     proc report data=test; column id description  here it should be one macro variable only from that multiple columns; define id; define description; define multiple columns; run; ... View more

Thanks, Its works for me ... View more

Yup it's ok, I can understand Thanks for your help ... View more

Thanks for your help, I will apply this logic. It will definitely work ... View more

I have already accepted the solution And next time don't say that ask your grandpa, I know you are a born decade expert and a experienced guy but don't be rude and arrogant. If you can't do help then simply tell that this is not possible ... View more

Hi, I have not written any contradictory statement, I have just asked for help and when I got solution I have just thanks to those who has given me solution, So don't say any contradictory statement Be professional ... View more

Hi, I got a solution, Thanks, ... View more