Convert CNPJ 14 for 8

Rita2021 — Thu, 09 Sep 2021 19:28:09 GMT

Hello,

I have a base that has cnpj and I want to take the cnpj14 field which is in number and transform it to 8

I have for example string below:

Remember that there may be a leading zero and it is not for counting

data one;

val=1234567;

val1=substr(left(val),1,4); run;

How can i proceed?

And another subject how can I convert where filter to text in sql server via sas??

Thank you very much.

Rita

Re: Convert CNPJ 14 for 8

ChrisNZ — Fri, 10 Sep 2021 00:35:05 GMT

Hi Rita,

You need is unclear, you might want to explain more. What's wrong with your code?

Also, please start a new thread for the second question (which is also unclear)

Also please use the appropriate icon when posting code to make it more legible.