About JavierBlanco

JavierBlanco · ‎11-28-2022

Thanks for your answer, but cod_acometida has many rows, not just the few ones that I put as an example. I'm trying to handle it as a SQL query within a PROC SQL; *** QUIT; Actually I need to use that cod_acometida (but 'zeroless') in a JOIN clause; it appears without zeros in the other table. Thanks in advance.

JavierBlanco · ‎11-28-2022

I need to remove some initial zeros from a field (it appears as an alphanumeric one in the DB) like this: cod_acometida 000000000003391901 000000000008271401 000000000007696901 000000000005504701 000000000002298401 000000000000332701 000000000013942801 etc. It's a variable number of characters but they are always zeros at the beginning of the string. I'm new at SAS, not sure if RegEx is applicable. I'm using Enterprise Guide 7.15. Thanks in advance.

Online Status	Offline
Date Last Visited	‎04-10-2023 08:32 AM

Re: PROC SQL: Remove initial zeros from an alphanumeric field

PROC SQL: Remove initial zeros from an alphanumeric field

Re: PROC SQL: Remove initial zeros from an alphanumeric field

Re: PROC SQL: Remove initial zeros from an alphanumeric field

Re: PROC SQL: Remove initial zeros from an alphanumeric field

Re: PROC SQL: Remove initial zeros from an alphanumeric field

PROC SQL: Remove initial zeros from an alphanumeric field