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 !!!
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
What number would your example translate to?
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.
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
If you need it to be numeric with leading zeroes, you can apply the Z14. format.
Tk's man!!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.