LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (April 2006, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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? > >


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