Error on sas code

[eduar78]

The code

PROC SGPLOT DATA=salesByProductByDate(WHERE=(year = 2015));
VBAR product / RESPONSE=sales GROUP=month GROUPDISPLAY=cluster
STAT=sum DATASKIN=gloss;
XAXIS DISPLAY=(nolabel noticks);
YAXIS GRID;
RUN;

And the error from above code

TITLE '2015 Sales By Product';
 96         PROC SGPLOT DATA=salesByProductByDate(WHERE=(year = 2015));
 97         VBAR product / RESPONSE=sales GROUP=month GROUPDISPLAY=cluster
 ERROR: Variable PRODUCT not found.
 ERROR: Variable SALES not found.

[PaigeMiller]

I think the error messages are clear. The variables PRODUCT and SALES are not in the data set SALESBYPRODUCTBYDATE.

You need to actually look at the data set with your own eyes to see what the problem is. You can use PROC PRINT or VIEWTABLE or even PROC CONTENTS.

[ballardw]

---

@eduar78 wrote:

The code

PROC SGPLOT DATA=salesByProductByDate(WHERE=(year = 2015));
VBAR product / RESPONSE=sales GROUP=month GROUPDISPLAY=cluster
STAT=sum DATASKIN=gloss;
XAXIS DISPLAY=(nolabel noticks);
YAXIS GRID;
RUN;

And the error from above code

TITLE '2015 Sales By Product';
 96         PROC SGPLOT DATA=salesByProductByDate(WHERE=(year = 2015));
 97         VBAR product / RESPONSE=sales GROUP=month GROUPDISPLAY=cluster
 ERROR: Variable PRODUCT not found.
 ERROR: Variable SALES not found.

---

This type of error sometimes comes from thinking that you want information about "product" but forget that the actual variable name is something like "product_number" "product_code" or something else with "product" in the variable name, or sometimes an abbreviations such as "prod". If you have labels assigned sometimes you get used to seeing "Product" and forget the actual variable name behind the label.