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