Hello, I hope all is well. I've gone through and searched just about all the manuals, faqs, contribs available on the data import/export process and have not found any answer to a specific question. Hopefully, I will be able to fall back upon the valuable expertise in mailing list. Here goes: How can I import SPECIFIC columns of data in a fixed width file? E.g. I have a fwf with 40 variables ranging from 1 to 10 characters and at any given time, need only a few to analyze, like so: <age: 2 char ><sex: 1 char><morning: 1 char><location: 3 char>......<family: 9 char><tagged: date>.......<weight at capture: 4 char><length at capture: 7 char>etc. which looks something like: 02M1LOS...xxcanidae011289.....10001291412 In essence I am looking for functionality similar to the SAS pointer/informat method. I would appreciate any help anyone would be able to give! Thanks so much for your help. best, Ratnendra Sharma U Minn
R and SAS pointer/informat functionality
2 messages · Ratnendra Sharma, Marc Schwartz
On Tue, 2005-10-11 at 18:55 -0500, Ratnendra Sharma wrote:
Hello, I hope all is well. I've gone through and searched just about all the manuals, faqs, contribs available on the data import/export process and have not found any answer to a specific question. Hopefully, I will be able to fall back upon the valuable expertise in mailing list. Here goes: How can I import SPECIFIC columns of data in a fixed width file? E.g. I have a fwf with 40 variables ranging from 1 to 10 characters and at any given time, need only a few to analyze, like so: <age: 2 char ><sex: 1 char><morning: 1 char><location: 3 char>......<family: 9 char><tagged: date>.......<weight at capture: 4 char><length at capture: 7 char>etc. which looks something like: 02M1LOS...xxcanidae011289.....10001291412 In essence I am looking for functionality similar to the SAS pointer/informat method. I would appreciate any help anyone would be able to give! Thanks so much for your help. best, Ratnendra Sharma U Minn
You just about answered the question yourself in your second paragraph
('fwf')....
See ?read.fwf and note the Details section regarding the use of negative
numbers for the 'widths' argument to skip columns.
HTH,
Marc Schwartz
<Greetings from Eden Prairie>