Hello, I'm brand new to SAS and am struggling with syntax. I have two datasets: one 100x5 table called QUANTITIES, and one 2x12 table called COEFFICIENTS. I need to multiply all values in QUANTITIES column called "Weight" by the scalar value found in the COEFFICIENTS column called "Wheat". I'm able to manipulate QUANTITIES as long as I don't have to bring in any values from other datasets. For the life of me, I can't figure out how to pull in a number from COEFFICIENTS. data work.QUANTITIES;
input Name $ Weight Density Units@@;
datalines;
Prod1 69.0 112.5 14
Prod2 62.8 102.5 14
Prod3 59.8 84.5 12
Prod4 59.0 99.5 12
;
data work.COEFFICIENTS;
input Copper Iron Wheat Barley Glass Water@@;
datalines;
11 22 33 44 55 66
; Thanks in advance
... View more
