topic Transforming a " . " into "missing" in SAS Data Management

Transforming a " . " into "missing"

ilikesas — Thu, 18 Dec 2014 00:33:53 GMT

Hi,

Suppose I have the following SAS code:

data numbers;

input id name$;

datalines;

1 A

2 B

3 A

4 .

5 B

6 .

7 B

8 A

9 A

10 .

;

run;

Some names are missing and I have the dot "." that signifies that these names are missing, but is it possible to have instead of the dot the actual word "Missing"?

Thank you

Re: Transforming a " . " into "missing"

stat_sas — Thu, 18 Dec 2014 00:41:38 GMT

data numbers;

input id name$;

if name=' ' then name='Missing';

datalines;

1 A

2 B

3 A

4 .

5 B

6 .

7 B

8 A

9 A

10 .

;

run;

Re: Transforming a " . " into "missing"

ilikesas — Thu, 18 Dec 2014 00:47:06 GMT

Thanks a lot stat@sas!

Re: Transforming a " . " into "missing"

Jagadishkatam — Thu, 18 Dec 2014 00:48:43 GMT

Alternatively by ifc function

data numbers;

input id name$;

name=ifc(name='','Missing',name);

datalines;

1 A

2 B

3 A

4 .

5 B

6 .

7 B

8 A

9 A

10 .

;

run;

Thanks,

Jag

Re: Transforming a " . " into "missing"

ilikesas — Thu, 18 Dec 2014 01:16:16 GMT

thanks Jagadishkatam, you taught me a new function!

Re: Transforming a " . " into "missing"

DBailey — Thu, 18 Dec 2014 12:47:37 GMT

Isn't the value for name going to be a period? Shouldn't it be

if name='.' then name='Missing';

Re: Transforming a " . " into "missing"

data_null__ — Thu, 18 Dec 2014 13:15:47 GMT

DBailey wrote:

Isn't the value for name going to be a period? Shouldn't it be
if name='.' then name='Missing';

No the $ INFORMAT (variables A and C) reads dot as missing to accommodate list input which needs place holder.

data dot_or_not;
   input a $ @1 @;
   input b $char2. @1 @;
   input c $2. @1 @;
   w=2; 
   input d $varying2. w; 
   cards; 
.  x
.  y
;;;;
   run; 
proc print; 
   run;

Re: Transforming a " . " into "missing"

DBailey — Thu, 18 Dec 2014 13:18:40 GMT

nice to know. I'm figured that STAT wouldn't have made an error like that..but had to ask.

Re: Transforming a " . " into "missing"

stat_sas — Thu, 18 Dec 2014 20:48:07 GMT

Hi DBailey,

Thanks for highlighting this. I also learned as a result of your question from master data_null_.

Regards,

Naeem