topic Need to check for the existence of a particular value in a character variable in SAS data set in SAS Enterprise Guide

Need to check for the existence of a particular value in a character variable in SAS data set

Sheeba — Fri, 10 May 2013 14:46:24 GMT

How to check for the existence of a particular value in a character variable in SAS data set?

I have a data set named tracker which has a character variable proj name.....How do I check if the current project name is existing in the tracker.

I have captured the project name using the macro variable, _clientprojectname.

How do i check whether that value exist on the tracker data set?

Regards,

Sheeba Swaminathan

PaigeMiller — Fri, 10 May 2013 15:59:09 GMT

%let value_exists=0;

data _null_;

set tracker;

if proj_name="&_clientprojectname" then call symputx('value_exists',1);

run;

Sheeba — Fri, 10 May 2013 19:00:24 GMT

Thank you ...