David, In this link there is an excel file with the data dictionary ftp://www.ine.es/temas/epa/disereg_epa0509.zip If I understand the second part of the answer: do you mean to process the files, for example with MS Access, and then importing the result? (any examples?) Regards, Hug
--- On Mon, 2/1/10, David Winsemius <dwinsem...@comcast.net> wrote: > From: David Winsemius <dwinsem...@comcast.net> > Subject: Re: [R] Import fixed-format ascii file with mixed record types > To: "trece por ciento" <el13porcie...@yahoo.com> > Cc: r-help@r-project.org > Date: Monday, February 1, 2010, 1:54 PM > > On Feb 1, 2010, at 2:33 PM, trece por ciento wrote: > > > Thanks David, but can read.fwf cope with different > record types? > > I do not see any facility for that goal. > > > For example, if recordtype is the 4th character, I > could have: > > > > 011125678 ---> This is record Type 1 > > 011136779 ---> This is record Type 1 > > 011124943 ---> This is record Type 1 > > 011286711 ---> This is record Type 2 > > 011234872 ---> This is record Type 2 > > 011135628 ---> This is record Type 1 > > > > So, how can I tell read.fwf to take the correct type > into account? > > It would be easier on the readers of the list if you would > offer a more complete description of the problem. Problems > which are unfolded bit by bit are rather annoying to some. > Is there a website or document that describes this data > resource? Perhaps an alternate strategy that used a database > interface would be more appropriate? > > --David. > > > > Thanks again, > > Hug > > > > --- On Mon, 2/1/10, David Winsemius <dwinsem...@comcast.net> > wrote: > > > > From: David Winsemius <dwinsem...@comcast.net> > > Subject: Re: [R] Import fixed-format ascii file with > mixed record types > > To: "trece por ciento" <el13porcie...@yahoo.com> > > Cc: r-help@r-project.org > > Date: Monday, February 1, 2010, 12:01 PM > > > > > > On Feb 1, 2010, at 11:40 AM, trece por ciento wrote: > > > >> I need to import several ascii files in fixed > format with two different record types. The data comes from > European Labor Force Surveys, wich is a household survey. > The first record type is for people over 16 years, and the > second much sorter is for people aged 15 or less (this > record has a filler with several blanks to get the same > record length). > >> The files tipically have 160000 records, with 176 > characters per record, the data is numeric, corresponding to > 102 variables, mostly integers (seven variables have two > decimals). My opertating system is Windows XP. > >> My questions: > >> 1. Wich do you think is the best way to import the > files into R? > > > > > > ?read.fwf > > > >> 2. Could you give me any references or examples? > > > > There are examples in the help page. > > > >> Thanking you in advance, > >> Hug > >> > >> > >> > >> > >> [[alternative HTML version > deleted]] > >> > >> ______________________________________________ > >> R-help@r-project.org > mailing list > >> https://stat.ethz.ch/mailman/listinfo/r-help > >> PLEASE do read the posting guide > >> http://www.R-project.org/posting-guide.html > >> and provide commented, minimal, self-contained, > reproducible code. > > > > David Winsemius, MD > > Heritage Laboratories > > West Hartford, CT > > > > > > > > > > > > David Winsemius, MD > Heritage Laboratories > West Hartford, CT > > ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.