Actual values and working through and example would be useful.
I can't tell what you expect for output.
How do you expect to provide the "Varx_y" value?
Did you mean to say " for each record(raw_name)" instead of " for each record(raw data)"?
Please be consistent about discussing values in terms of variable names. We have to guess what you mean when provide variable names that do not match terms discussed like " parameter name, parameter code and AVAL" when there are no variable actually with those names.
Maybe you want something like this:
Data want;
set source_info;
where raw_name ='raw1';
run;
Remember that computers are pretty literal and if your spelling of 'raw1' is different in the actual data set, such as "Raw1" or "raw 1" or "raw_1" then the where condition might not find what you want.
... View more