Date:         Mon, 17 Apr 2006 18:35:49 +0800
Reply-To:     =?UTF-8?B?6IuX54Kz56Wl?= <032015214@FUDAN.EDU.CN>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         =?UTF-8?B?6IuX54Kz56Wl?= <032015214@FUDAN.EDU.CN>
Subject:      Re: Reading Data
Comments: To: SUM <sumanta24@GMAIL.COM>
In-Reply-To:  <1145265787.012916.60900@v46g2000cwv.googlegroups.com>
Content-type: text/plain; charset=UTF-8; format=flowed

hi sum,

You can use 'firstobs' when you import data form ascii.txt:

data rose;
infile 'c:\ascii.txt' firstobs=14;
input  YEAR Y X2 X3 X4 X5;
run;
> Hi All,
> Suppose i have a data file with descriptions of the variables like
> this:
> Table 7.6
> Demand for Roses
>
>   YEAR = Year and Quarter
>   Y    = Quantity of Roses Sold, Dozens
>   X2   = Average Wholesale Price of Roses, $ Per Dozen
>   X3   = Average Wholesale Price of Carnations, $ Per Dozen
>   X4   = Average Weekly Family Disposable Income, $ Per Week
>   X5   = Trend Variable Taking Values of 1, 2, and so on, for the
> Period
>          1971.3 to 1975.3 in the Detroit Metropolitan Area
>
>    YEAR       Y       X2      X3       X4      X5
>   1971.3    11484    2.26    3.49    158.11     1
>   1971.4     9348    2.54    2.85    173.36     2
>   1972.1     8429    3.07    4.06    165.26     3
>   1972.2    10079    2.91    3.64    172.92     4
>   1972.3     9240    2.73    3.21    178.46     5
>   1972.4     8862    2.77    3.66    198.62     6
>   1973.1     6216    3.59    3.76    186.28     7
>
>
> How can i read this data set stored as ASCII .txt file in C: drive so
> that SAS will read relevant portions of the data only for analysis?
>
>