Please help with SAS commands used for solving problem. Thank you :) :) Traditio

Question

Please help with SAS commands used for solving problem. Thank you :) :)

Traditionally, the quality of the Bordeaux vintage is first evaluated by experts in March of the next year. However, it turns out that these first ratings are rather unreliable. What about using a statistical approach that predicts the price of the vintage as a function of its age, rainfall, and temperature? Consider data on average temperature during the growing season (April through September, in degrees centigrade), rain during the harvest season (rain in Septem ous year to March of the current year, in total millimeters), age of the vintage, and age price for the Bordeaux vintage relative to the year 1961 (the response variable). Data for the years 1952 through 1980 are listed in the following table (the data for 19 1956 are missing; relative prices for these two vintages could not be established because they were poor vintages and very little wine is now sold from those two years): ber, in total millimeters), rain prior to the growing season (October of the previ- aver- 54 and Previous Relative Price 0.368 0.635 0.446 0.221 Rainfall Rainfall (1983-0) Year Temperature 1952 1953 1955 1957 1958 17.12 16.73 17.15 16.13 16.42 17.48 31 690 25 0.658 0.139 1.000 0.331 0.168 0.306 0.106 0.473 0.191 0.105 1960 290 763 23 1961 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 17.33 16.30 15.72 17.27 155 19 267 16.53 16.23 16.20 16.55 610 575 15 13 0.404 0.272 0.101 16.77 14.98 17.07 16.30 551 536 376 158 123 1973 1974 1975 572 0.301

Explanation / Answer

In case dataset is not a sas dataset (please specify location in infile statement)

DATA temp;

INFILE 'temp.csv';

INPUT Year Temperature Rainfall Previous_Rainfall Age Relative_Price DLM=',' DSD MISSOVER FIRSTOBS=2;

logprice = log(Relative_Price);

RUN;

proc reg data = temp;

model logprice = Temperature Rainfall Previous_Rainfall Age;

run;

In case dataset is a sas dataset (please specify location in set statement)

DATA temp;

SET b;

logprice = log(Relative_Price);

RUN;

proc reg data = temp;

model logprice = Temperature Rainfall Previous_Rainfall Age;

run;

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.