Convert CNPJ 14 for 8

[Rita2021]

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 

[ChrisNZ]

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.