topic Re: Conversion of Numeric to Packed Decimal in using SAS in SAS Programming

Conversion of Numeric to Packed Decimal in using SAS

durgesh101 — Tue, 20 Jun 2017 20:27:34 GMT

Hi All,

I am trying to convert a Numeric value to packed decimal value and it is not getting converted. In output fle it is showing as zeros.

Below is my code.

In input file I have a below field defined as Numeric at position 100 and below conversion menthod I used.

@100 cnt_Mos_Deln $03 has value as 006

Cnt_Mos_Ddlpi = INPUT(Cnt_Mos_Deln,??PD3.)

in output file, it is defined as,

Cnt_Mos_Ddlpi PD3.

But above code gives zeros(in Hex) in this field.

So can I any one please help?

Re: Conversion of Numeric to Packed Decimal in using SAS

SASKiwi — Tue, 20 Jun 2017 20:32:37 GMT

Where are you running this code? If it's not being run on a mainframe you will probably need to use S370PD.

Re: Conversion of Numeric to Packed Decimal in using SAS

durgesh101 — Tue, 20 Jun 2017 20:33:29 GMT

Yes, I am executing code on Mainframe.

Re: Conversion of Numeric to Packed Decimal in using SAS

Kurt_Bremser — Tue, 20 Jun 2017 20:38:22 GMT

Don't use a pd informat in the input function when you have readable data in the string. Use a simple 3. instead.

When something unexpected happens, always look at the log.

Re: Conversion of Numeric to Packed Decimal in using SAS

durgesh101 — Tue, 20 Jun 2017 20:46:30 GMT

Code:

Data Mrtgfinl;
   Infile Mrtgfinl;
   Input @001 nbr_loan_midas $09.
            @273 Cnt_Mos_Deln $03

PUT 'Cnt_Mos_Deln ' Cnt_Mos_Deln= ;
Cnt_mos_ddlpi = INPUT(Cnt_Mos_Deln,??pd3.);
CALL SYMPUT('Cnt_mos_ddlpi ',Cnt_mos_ddlpi);
Put 'Cnt_mos_ddlpi ' Cnt_mos_ddlpi ;

Output:

Cnt_Mos_Deln Cnt_Mos_Deln=006
Cnt_mos_ddlpi . ,

Re: Conversion of Numeric to Packed Decimal in using SAS

Kurt_Bremser — Tue, 20 Jun 2017 20:52:51 GMT

You're still using the wrong informat in the input() function.

Re: Conversion of Numeric to Packed Decimal in using SAS

Astounding — Tue, 20 Jun 2017 21:35:43 GMT

I'm not sure whether I can trust the program you are showing, since it is missing at last one semicolon. But this would definitely be wrong:

@100 cnt_Mos_Deln $03

This gets the value from column 3, not from columns 100-102. You would have to use a dot instead as part of the informat: $3.

Re: Conversion of Numeric to Packed Decimal in using SAS

durgesh101 — Tue, 20 Jun 2017 21:37:57 GMT

Below code worked for me

Cnt_mos_ddlpi = INPUT(Cnt_Mos_Deln,??3.);