topic Re: SAS is reading but not loading Boolean values in SAS Programming

SAS is reading but not loading Boolean values

kajal_30 — Wed, 22 Jun 2022 12:49:31 GMT

Hi Team ,

In the database table I have a column qr_sac which is defined as Boolean while creation.In sas table I have values for this column like 'N','Y','N','N' ...... I am appending sas table to the database table. I am not seeing any errors while appending but the final database table is showing values like screenshot below.Can anyone please help. I am expecting to see same values like SAS 'Y' or 'N'.

Regards

Kajal

Re: SAS is reading but not loading Boolean values

Tom — Wed, 22 Jun 2022 13:18:02 GMT

What do you mean by "database table"? Do you mean some non SAS database? What database? How did you load the values from the SAS dataset into that external database? Are you using SAS to do the loading? How?

If the field is BOOLEAN there is no way to store character strings like Y or N. Just boolean TRUE or FALSE values. It looks like in whatever GUI tool you are using to look at the data they are displaying the boolean value as either a filled or empty box. I assume the TRUE values are being displayed as filled box.

Perhaps whatever tool you are using to generate the image you posted has an option to display boolean values as Y or N?

Re: SAS is reading but not loading Boolean values

kajal_30 — Wed, 22 Jun 2022 13:46:43 GMT

Hi @Tom

I am loading it to Netezza database. I am using base sas to load it. Yeah I also read the same and now I am creating the database table column type as char so that I can store values 'Y' or 'N' . so changed the type from Boolean to char worked fine.

Thanks

Kajal