sas reading variables

[GeraldKoye]

Is it possible to use an excel file of parameters (allowance tax, expense fee ...) that sas can read and interpret as variables in the project?

[Kurt_Bremser]

Do you mean to treat the contents of the spreadsheet as name/value pairs for the creation of macro variables?

[GeraldKoye]

yes! exactly

[Kurt_Bremser · Accepted solution]

First, you need to make sure that the names are valid SAS names (contain only letters, digits and underscores - no blanks! - and start with a letter or underscore). Then you use CALL SYMPUT or CALL SYMPUTX in a data step:

data _null_;
set from_excel;
call symputx(name,value,'g');
run;

The 'g' is only there to make sure that the macro variables are put into the global symbol table, if the step is run in a macro.

[GeraldKoye]

Thanks for your answer.

I've tried but. I don't know how to print the variables.

data work.variables;
infile datalines4 dlm='7f'x 
missover dsd ;
input 
nom : $char5. 
valeur : best2. ; 
datalines4; 
taux1 50 
taux2 60 
;;;;  ok

data _null_; 
set variabledata;
call symputx(nom,valeur,'g');
 run;
%put taux1;
%put taux2;

[Kurt_Bremser]

To invoke the macro processor to resolve a macro variable, you need to use the macro trigger &:

%put &taux1.;

It is also good practice to terminate a macro variable reference with a dot, to prevent ambiguities if it is used in a word.

[GeraldKoye]

It work! Thanks!