topic Re: Creating if then column based on if cell is blank in SAS Programming

Creating if then column based on if cell is blank

sasprogramming — Wed, 28 Jul 2021 00:50:19 GMT

I would like to create a new column called 'Indicator' which is equal to "NOT_BLANK" if 'field' is not blank and "BLANK" if 'field' is blank.

How I would do this in excel is:

How can I do this in SAS? Thanks.

Current data:

Field

A001_B001

A001

C002

C002_A001

B002

Desired data:

Field	Indicator
A001_B001	NOTBLANK
A001	NOTBLANK
	BLANK
C002	NOTBLANK
C002_A001	NOTBLANK

B002	NOTBLANK

Re: Creating if then column based on if cell is blank

ChrisNZ — Wed, 28 Jul 2021 01:36:18 GMT

Like this?

INDICATOR = ifc(missing(FIELD),'BLANK','NOTBLANK');

Don't forget the set the length of INDICATOR or it will default to a length of 200.

Re: Creating if then column based on if cell is blank

ballardw — Wed, 28 Jul 2021 14:32:30 GMT

Can you describe how you will use that indicator?

You may not need a new variable. When value is based on a single variable often a simple format can be used to display desired text.

proc format;
value $blank
' '='BLANK'
other='NOTBLANK'
;
run;

Then use the format to display the existing character variable. Or use Newvar=put(var,$blank.); Formatted values can be used by most procedures though may need to explicitly allow use of missing values depending on procedure.

Similar can be done with numeric values and numeric format.