topic Re: sas reading variables in SAS Programming

sas reading variables

GeraldKoye — Wed, 17 Jun 2020 09:21:27 GMT

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?

Re: sas reading variables

Kurt_Bremser — Wed, 17 Jun 2020 09:26:58 GMT

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

Re: sas reading variables

GeraldKoye — Wed, 17 Jun 2020 09:28:58 GMT

yes! exactly

Re: sas reading variables

Kurt_Bremser — Wed, 17 Jun 2020 09:34:12 GMT

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.

Re: sas reading variables

GeraldKoye — Wed, 17 Jun 2020 10:12:23 GMT

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;

Re: sas reading variables

Kurt_Bremser — Wed, 17 Jun 2020 10:20:59 GMT

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.

Re: sas reading variables

GeraldKoye — Wed, 17 Jun 2020 10:36:09 GMT

It work! Thanks!