```Date: Mon, 17 Apr 2006 18:35:49 +0800 Reply-To: =?UTF-8?B?6IuX54Kz56Wl?= <032015214@FUDAN.EDU.CN> Sender: "SAS(r) Discussion" From: =?UTF-8?B?6IuX54Kz56Wl?= <032015214@FUDAN.EDU.CN> Subject: Re: Reading Data Comments: To: SUM 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? > > ```

Back to: Top of message | Previous page | Main SAS-L page