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
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
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