topic Re: Input for numeric values in SAS Programming

Input for numeric values

SASdevAnneMarie — Tue, 17 Jan 2023 16:34:26 GMT

Hello Experts,

I would like to transform the character values to numeric, but my code doesn't work for all observcations (row 17) :

My code is :

numeric_var = input(PX_LAST, comma9.);

Thank you for your help !

Re: Input for numeric values

PaigeMiller — Tue, 17 Jan 2023 16:39:49 GMT

Obviously, the process for generating this data is broken, it should be creating variable PX_LAST as numeric, and if possible that's the fix you want.

Otherwise, use informat comma32.

Re: Input for numeric values

SASdevAnneMarie — Tue, 17 Jan 2023 16:53:54 GMT

Thank you !
With comma32. that works !