topic Re: Error on sas code in SAS Studio

Error on sas code

eduar78 — Mon, 15 Apr 2019 18:40:17 GMT

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.

Re: Error on sas code

PaigeMiller — Mon, 15 Apr 2019 18:44:41 GMT

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.

Re: Error on sas code

ballardw — Mon, 15 Apr 2019 19:35:00 GMT

@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.