Hi All even thogh memid is having name as sasadministartors iam getting incorrect value as vv instead of SAS Administrators if i use nested if not=
syntax,please help
data t;
set work.groupmempersons_info(where=(memid='xxxxxxxxx'));
length desc $255;
call missing (desc);
if memName = "sasadm" or memname = "sasevs" or memname = "sastrust" then put "Account is sasadm, sasevs or sastrust, skipping.";
else
if Name= :'SASAdministrators' or Name= :'DI Developers' then desc='SAS Administrator';
if Name not= :'XXX' and Name not=:'YYY' then desc='vv';
;
rc=metadata_setattr("omsobj:person\"||memid,"Desc",desc);
put rc=;
run;
This statement:
if Name not= :'XXX' and Name not=:'YYY' then desc='vv';
Is always executed regardless of what happened with the earlier if.
I think you want:
data t;
set work.groupmempersons_info(where=(memid='xxxxxxxxx'));
length desc $255;
call missing (desc);
if memName = "sasadm" or memname = "sasevs" or memname = "sastrust" then put "Account is sasadm, sasevs or sastrust, skipping.";
else /* <= this else only effects the next statement*/
if Name= :'SASAdministrators' or Name= :'DI Developers' then desc='SAS Administrator';
ELSE if Name not= :'XXX' and Name not=:'YYY' then desc='vv';
;
rc=metadata_setattr("omsobj:person\"||memid,"Desc",desc);
put rc=;
run;
This statement:
if Name not= :'XXX' and Name not=:'YYY' then desc='vv';
Is always executed regardless of what happened with the earlier if.
I think you want:
data t;
set work.groupmempersons_info(where=(memid='xxxxxxxxx'));
length desc $255;
call missing (desc);
if memName = "sasadm" or memname = "sasevs" or memname = "sastrust" then put "Account is sasadm, sasevs or sastrust, skipping.";
else /* <= this else only effects the next statement*/
if Name= :'SASAdministrators' or Name= :'DI Developers' then desc='SAS Administrator';
ELSE if Name not= :'XXX' and Name not=:'YYY' then desc='vv';
;
rc=metadata_setattr("omsobj:person\"||memid,"Desc",desc);
put rc=;
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.