Hi , Thanks for the response . Sorry for not stating things clear.. I have a Flat file(sequential) with data, as of now we are creating a report with that data. The MCD, a field in the Flat file is a 2 digit CODE , For Every Code in the File there is a TITLE Associated with it i.e if the Code is PP then the TITLE is "PROGRESSIVE PARTNER " . At present we have hardcoded these titles as a FORMAT, But the problem with this is we have to change the SAS module every time a new title is added. Inorder to prevent this I am trying to get the title details from a KSDS VSAM. The KSDS VSAM has the MCD as key. All i have to do is get the details (title ) from the VSAM for every record in the Input Data. So that i can remove the Hard coded values from the SAS Module. Hope i am clear with my requirements. Since these hardcoding is done in several SAS modules i thought that it would be appropriate to write as a MACRO. As of the code i have written all i am trying to read is for every record from the input i take the Code and pass it to the macro to get the title. In the Macro I am trying to get the Details(title) from the VSAM. Now the problem with this is i do not know how to get the title from the MACRO back to the Called pgm. And also i need to add the title to the existing Input Data without affecting any other details as it would mess up my Report. I am very new to SAS so Kindly excuse me if any of my query is primitive.

Thanks, Kiruba