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!!
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.