|
Amar, In a perfect world you could code:
DATA _NULL_;
INFILE ONECOL;
FILE MATRIX;
INPUT H1-H24;
PUT H1-H24;
RUN;
As Roland mentioned, you may need OPTION FLOWOVER; You might want a delimiter
in the output file--a comma is traditional although tabs are better. If so, you
could change the PUT statement to:
PUT (H1-H24) ('05'X);
You might have to use fixed columns to read the data into some other package.
If so, you could replace '05'X with a SAS format like Z9.0, to print leading
zeros and always use 9 columns--this assumes you have integers.
At my site, this would be complicated by Daylight Saving Time. One Sunday in
April would have 23 hours, and one Sunday in the Fall (August?) would have 25
hours.
Tim Berryhill - Contract Programmer and General Wizard
TWB2@PGE.COM or http://www.aartwolf.com/twb.html
Frequently at Pacific Gas & Electric Co., San Francisco
The correlation coefficient between their views and
my postings is slightly less than 0
----------------------[Reply - Original Message]----------------------
Amar A. Khalifeh wrote:
>
> I would like to get some help with the following:
> I am reading in hourly values for an entire year with infile and data
> statments. The data are arranged in one column (8760 hourly
> observations). How can I output this single variable in a 365X24 matrix,
> showing hourly values across? I am using SAS solely for this
> vector-to-matrix conversion (to be fed into another application).
> Any tip would be appreciated.
> Amar
=====================================================================
| 
