Informat - Corporate ID

[Abud]

Hi, all

I have a text file with a field like this 00.000.000/0001-00 and I'd like to import like a number.

Question: Does anyone know how to import this kind of field ?

I mean, which kind of informat should I make to import a field with this format 00.000.000/0001-00

Is it possible make my own informat ?

tk's in advanced !!!

[DBailey]

What number would your example translate to?

[Abud]

Hi DBailey,

I've been importing the field like a string like "00.000.000/0001-00".

If the text data has this format "00.000.000/0001-00". How can I convert this text in a number like this 00000000000100 when I'm importing to a SAS table.

[Haikuo · Accepted solution]

I am not aware of any informat is capable of doing that, but you can always read in it as Char, process it as char, and convert it to number if needed:

data have;

  input var $50.;

  var_new=compress(var,,'kd');

  var_number=input(var_new,best32.);

  cards;

  00.000.000/0001-00

  ;

Haikuo

[DBailey]

If you need it to be numeric with leading zeroes, you can apply the Z14. format.

[Abud]

Tk's man!!