topic Re: Output contains missing character and numeric values which needs to converted in to 'No data at. in SAS Programming

Output contains missing character and numeric values which needs to converted in to 'No data at.....

Jinu302000 — Fri, 11 Jan 2019 10:09:25 GMT

Output contains missing character and numeric values which needs to converted in to 'No data at this time'.

Attached is a sample output where Name is a character field (length is 😎 and ID is a numeric field.

Any blank values in each columns (Name and ID), then the blank values should be changed to 'No data at this time'.

This should be checked for 10-15 outputs and need to change all blank values to ''No data at this time'.

Character length varies from field to field and all the blank values should be converted to the mentioned text with out truncation.

How this can be done for all the outputs (10 or more). What is the best way to deal with this? any suggestions on this, please

Re: Output contains missing character and numeric values which needs to converted in to 'No data at.

Jinu302000 — Fri, 11 Jan 2019 10:19:22 GMT

adding the output here. Thank you!

Re: Output contains missing character and numeric values which needs to converted in to 'No data at.

PeterClemmensen — Fri, 11 Jan 2019 11:24:53 GMT

When you sat ‘for all the outputs’, do you meab that you want to do this for all obsetvations or?

Re: Output contains missing character and numeric values which needs to converted in to 'No data at.

Kurt_Bremser — Fri, 11 Jan 2019 12:57:47 GMT

Assign a proper format:

data have;
infile cards dsd dlm=' ' truncover;
input name $ id;
cards;
KL 1
JL 2
KK
JK
 5
;
run;

proc format;
value $c_empty
  " " = "No data at this time"
;
value n_empty
  . = "No data at this time"
;
run;

data want;
set have;
format name $c_empty. id n_empty.;
run;

Re: Output contains missing character and numeric values which needs to converted in to 'No data at.

Jinu302000 — Wed, 16 Jan 2019 13:29:45 GMT

Thank you, Kurt Bremser for providing the solution for this. Appreciate your help.

also i just wanted to know if a date field is missing (along with other dates fields are having values with different format), can we use this procedure? then how can we display the same 'No data at this time' for blank date field. Is it doable? Any idea.

Thanks very much for your help and support!!

Re: Output contains missing character and numeric values which needs to converted in to 'No data at.

Kurt_Bremser — Wed, 16 Jan 2019 13:42:44 GMT

You can add a special date format in proc format that uses an existing date format for non-missing values:

value d_empty
  . = "No data at this time"
  other = [ddmmyy10.]
;

Re: Output contains missing character and numeric values which needs to converted in to 'No data at.

Jinu302000 — Sun, 27 Jan 2019 06:13:22 GMT

@ KurtBremser:- Thank you, Sir for your wonderful help and support. Thanks very much!!