topic Re: Viewing SAS catalog entries and formats within SAS Enterprise Guide in SAS Programming

Viewing SAS catalog entries and formats within SAS Enterprise Guide

SASAna — Tue, 27 Feb 2018 02:39:53 GMT

Hi SAs users,

I needed some help with loading the Claim_id field in Oracle database(character field of 20 byte length) . Claim_id was numericin the source data and i used put statement to convert into character with length & format of 20 bytes.

FINAL dataset is looking fine (7 byte claimid ), but ORacle load has shrinked to 5 byte. what i am missing?

PROC SQL;
                 create table FINAL as
          select a.*,
                   put(CLM_ID ,22.) as CLM_ID1 format = $20. ,

;

quit;

Thanks,

Ana

Re: Viewing SAS catalog entries and formats within SAS Enterprise Guide

ChrisNZ — Tue, 27 Feb 2018 03:26:20 GMT

I don't understand what you are doing.

In any case, in case this helps:

1. SAS can only store 16-digit integers (on PC/unix) before losing precision and distorting the values, when using numeric variables

so put(CLM_ID ,22.) is bound to produce bad results if you have that many digits.

You should never use numeric variables for such a long series of digits.

2. If you have that many digits or more always use a string

3. If you have large integers stored as numeric variables, always use a length of 8 bytes for that variable

Re: Viewing SAS catalog entries and formats within SAS Enterprise Guide

SASAna — Tue, 27 Feb 2018 03:52:39 GMT

Thanks for the help. I changed it to 8 byte and it worked fine loading the data to Oracle tables.

Thanks again,
Ana

Re: Viewing SAS catalog entries and formats within SAS Enterprise Guide

ChrisNZ — Tue, 27 Feb 2018 04:48:54 GMT

The title has no link whatsoever with the question asked.