How to use values from a raw table into a program as variables

msantosp — Thu, 11 Jul 2019 09:42:23 GMT

Dear all,

I am beginner in SAS and I am developing a program in which I have to use parameters from a raw_table to compute another variable.

I mean, I have the table "parametros" and my aim is to calculate for each mod_id the formula below:

new_score= Par_A*raw_score + Par_B + (Par_C+Par_D)/raw_score

I do not how to select values from parametros to use in the code below.

Can anybody help me? Thank you in advance

data parametros;                    
   input mod_id Par_A Par_B Par_C Par_D; 
   datalines;         
	8 1.5340 -0.6896 0.0214 0.0211
	9 0.6560 -0.7788 0.0169 0.0185
	10 1.8773 -0.4354 0.0216 0.0227
	11 0.8543 -0.8598 0.0258 0.0269
	12 -0.5137 -0.9571 0.0213 0.0231
	13 0.0979 -0.9629 0.0239 0.0258
	14 0.8889 -0.7801 0.0136 0.0146
run;                           


data mapping_table;
mod_id=8;
Do while (mod_id<15);
	raw_score=1600;
	Do while (raw_score<2201);
	new_score= Par_A*raw_score + Par_B + (Par_C+Par_D)/raw_score;	
output;
		raw_score+1;
end;
mod_id + 1;
end;

run;

Re: How to use values from a raw table into a program as variables

gamotte — Thu, 11 Jul 2019 10:02:29 GMT

Hello,

Use the set statement to read the parametros dataset row by row.

data mapping_table;
    set parametros;
    do raw_score=1600 to 2200;
        new_score= Par_A*raw_score + Par_B + (Par_C+Par_D)/raw_score;	
        output;
    end;
run;

topic Re: How to use values from a raw table into a program as variables in SAS Programming

How to use values from a raw table into a program as variables

Re: How to use values from a raw table into a program as variables