topic Re: How to assign specific value from table to macro variable based on value from another variable? in SAS Programming

How to assign specific value from table to macro variable based on value from another variable?

wllm_fox — Sun, 05 Dec 2021 23:43:17 GMT

Hey guys,

This is my first post, just let me know if you need me to elaborate.

I've created a proc freq table that I've outputted to a work file, and it looks like the below:

Status	COUNT	PERCENT
Successful	200	0.769231
Unsuccessful	50	0.192308
Unknown	10	0.038462

I want to get the PERCENT value where the status was "Successful" and assign it to a macro variable that I can use at a later part of the programme.

Does anyone know how I can do this? Thank you in advance for you help.

Re: How to assign specific value from table to macro variable based on value from another variable?

wllm_fox — Mon, 06 Dec 2021 15:07:24 GMT

I also asked on StackOverflow and a solution was provider there:

https://stackoverflow.com/questions/70245993/sas-how-to-get-value-from-table-based-on-value-from-another-variable-and-assig

Re: How to assign specific value from table to macro variable based on value from another variable?

Tom — Mon, 06 Dec 2021 15:49:05 GMT

You can create a macro variable using CALL SYMPUTX() function.

%let percent=;
data _null_;
  set have;
  if status='Successfull" then call symputx('percent',percent');
run;

If you want to test whether the string in that macro variable is larger than some other floating point value make sure to use %SYSEVALF() as the normal %EVAL() macro function used in %IF will only handle integer arithmetic.

%if %sysevalf(&percent > 0.5 ) %then %do;
....
%end;