topic Re: If then remove data variable in SAS Programming

If then remove data variable

Gil_ — Wed, 10 Oct 2018 21:33:43 GMT

I have a dataset that if it. Matchs i would need another col to be null

The data looks
Id. Type. Sch
A1. Cd. Mon tue
Ab. Store. Tue wed
S1. Cd. Wed
A5. Store. Mon

When type eq Cd i would w want sch to be null

.id Type. Sch
A1. Cd.
Ab. Store. Tue wed
S1. Cd.
A5. Store. Mon

Re: If then remove data variable

novinosrin — Wed, 10 Oct 2018 21:40:18 GMT

if upcase(type)='CD' then call missing(sch);

Re: If then remove data variable

singhsahab — Thu, 11 Oct 2018 01:37:32 GMT

data want;
	set have;

	if upcase(type)='CD' then
		Sch='';
run;