I am working in SAS EG and am trying to edit a dataset so that if a character variable is not equal to 'XYZ' then it should be set to ' ' (which is 3 blank spaces). However when I do this, it is actually set to missing which is ''. Is there a way to set an observation to be a certain amount of blank spaces? Example code: data new; set old; if AccountCode ^= 'XYZ' then AccountCode = ' '; run;
... View more