Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Reading non-standard data


From   "Rio, Martin" <[email protected]>
To   "'[email protected]'" <[email protected]>
Subject   st: Reading non-standard data
Date   Mon, 15 Mar 2004 11:35:55 -0500

I need to read a climate dataset into Stata. My problem is that the dataset
in not 1-observation per row, but the information in each row depends on a
previous row. The dataset contains monthly measurements for each cell on a
grid from 1901-2000. The grid is big, but for the purpose of illustration
suppose it is 10x10 (10 cells wide by 10 cells tall). 

Each cell of the grid is identified by a header observation that states its
x, y coordinated and is followed by rows that contain the data corresponding
to that grid, which are 100 rows (years 1901-2000) and 12 columns (months
Jan-Dec). The format is fixed in the sense that there is always a header row
followed by 100 rows with 12 columns sepparated by a space (missing values
are coded -999, so that there are always values for columns)

This is an example of how the dataset looks:

Grid-ref=   1, 1
   40   73  139   97   66  338  523  265  172   57   96   72
   86   87  125  106   74  233  275  419   89   37   67   72
 			  ...
   60  112   58   22  145  273  576  451   82   91  194   61
Grid-ref=   1, 2
   32  103  108   68  126  312  565  486  213   54   76   29
   13  106   42   93  112  344  244  422   88  104   59   73
 			 ...
  101  104   57   46   91  165  601  107  163   60  161   59
		   [and so on, until]
Grid-ref=   10, 10
   13  102   19   98   58  309  247  303  181   48   68   81
   123   60  133  107  107  208  321  502   48  107   80  103
    ...
   101   89  187   74  201  515  509  490  102   86  100   52

I would like to read these data into a Stata dataset with columns:
x-coordinate, y-coordinate, year, jan, feb, ..., dec.

I've been trying for a while, but I am really at a loss and would appreciate
any help. If someone wants to help me and finds this email confusing, please
e-mail me for clarification.

Thanks in advance,

Mart�n Rio
Charles River Associates
Washington, DC 
phone:	(202) 662-3957
fax:	(202) 662-3910


*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index