Your column definition :
DEFINE SDCDESC / GROUP FORMAT=£40. 'NAME'
will name the column with a label of "NAME", not "DESCRIPTION". Be careful when copying or creating dummy code that you don't lose the sense.
The quoted value will label the column, and providing a definition for the N column will give you the column label you require.
Thanks Daniel. Please find the correct one below :
PROC REPORT DATA=MERGED NOCENTER NOWD HEADLINE HEADSKIP MISSING;
COLUMN ID NAME N;
DEFINE ID / GROUP FORMAT=£4. 'ID';
DEFINE NAME / GROUP FORMAT=£40. 'NAME';
Now when I define, N, it says N is not a part of the MERGED dataset ! So it doesnt work if I define N.