topic Re: solve error 180-322 in New SAS User

Re: solve error 180-322

beaubrunmrmr — Mon, 30 Mar 2020 22:52:08 GMT

Can someone help with this,

PROC IMPORT OUT=salesByProductByDate DATAFILE= "/home/emilymoore20/EPG194/output/myTestFolder/BSA570v4_Week3_assignment_data.xlsx"
DBMS=xlsx REPLACE;
GETNAMES=YES;
RUN;
DATA salesByProductByDate;
SET salesByProductByDate;
year = YEAR(date);
month = YEAR(date);
RUN;
PROC REPORT DATA=salesByProductByDate NOWD;
COLUMN ('Sales' year month) product,(sales);
DEFINE year / GROUP STYLE (header)={background=lightgreen};
DEFINE month / GROUP STYLE (header)={background=lightgreen};
DEFINE product / ACROSS ' ' STYLE(header)={background=lightyellow};
DEFINE sales / SUM STYLE(header)={background=lightyellow} FORMAT=DOLLAR15.2;
BREAK AFTER year /SUMMARIZE DOL DUL;
RBREAK AFTER/SUMMARIZE;
COMPUTE AFTER year;
CALL DEFINE('year','style','style=Header{pretext="SubTotal " tagattr="Type:String"}');
ENDCOMP;
COMPUTE AFTER;
CALL DEFINE('year','style','style=Header{pretext="Grand Total " tagattr="Type:String"}');
ENDCOMP;
RUN
TITLE '2015 Sales By Product';
PROC SGPLOT DATA=salesByProcudtByDate(WHERE=(year = 2015));
VBAR product / RESPONSE=sales GROUP=month GROUPDISPLAY=cluster
STAT=sum DATASKIN=gloss;
XAXIS DISPLAY=(nolabel noticks);
YAXIS GRID;
RUN;
TITLE '2016 Sales By Product';
PROC SGPLOT DATA=salesByProductByDate(WHERE=(year = 2016));
VBAR product / RESPONSE=sales GROUP=month GROUPDISPLAY=cluster
STAT=sum DATASKIN=gloss;
XAXIS DISPLAY=(nolabel noticks);
YAXIS GRID;
RUN;
TITLE '2017 Sales By Product';
PROC SGPLOT DATA=salesByProductByDate(WHERE=(year = 2017));
VBAR product / RESPONSE=sales GROUP=month GROUPDISPLAY=cluster
STAT=sum DATASKIN=gloss;
XAXIS DISPLAY=(nolabel noticks);
YAXIS GRID;
RUN;
TITLE '2018 Sales By Product';
PROC SGPLOT DATA=salesByProductByDate(WHERE=(year = 2018));
VBAR product / RESPONSE=sales GROUP=month GROUPDISPLAY=cluster
STAT=sum DATASKIN=gloss;
XAXIS DISPLAY=(nolabel noticks);
YAXIS GRID;
RUN;

Re: solve error 180-322

Tom — Tue, 31 Mar 2020 00:41:58 GMT

What is the actual question? Did you try to run it? Show the lines from the SAS log.

Re: solve error 180-322

beaubrunmrmr — Tue, 31 Mar 2020 01:06:27 GMT

1.PROC IMPORT OUT=salesByProductByDate DATAFILE=

180

71 ! "/home/emilymoore20/EPG194/output/myTestFolder/BSA570v4_Week3_assignment_data.xlsx"

ERROR 180-322: Statement is not valid or it is used out of proper order.

72 2.DBMS=xlsx REPLACE

73 3.GETNAMES=YES

74 6.DATA salesByProductByDate

75 7.SET salesByProductByDate

76 8.year = YEAR(date)

77 9.month = YEAR(date)

78 12.PROC REPORT DATA=salesByProductByDate NOWD

79 13.COLUMN ('Sales' year month) product,(sales)

80 14.DEFINE year / GROUP STYLE (header)={background=lightgreen}

81 15.DEFINE month / GROUP STYLE (header)={background=lightgreen}

82 16.DEFINE product / ACROSS ' ' STYLE(header)={background=lightyellow}

83 17.DEFINE sales / SUM STYLE(header)={background=lightyellow} FORMAT=DOLLAR15.2

84 18.BREAK AFTER year /SUMMARIZE DOL DUL

85 19.RBREAK AFTER/SUMMARIZE

86 20.COMPUTE AFTER year

87 21.CALL DEFINE('year','style','style=Header{pretext="SubTotal " tagattr="Type:String"}')

88 22.ENDCOMP

89 23.COMPUTE AFTER

90 24.CALL DEFINE('year','style','style=Header{pretext="Grand Total " tagattr="Type:String"}');

91 25.ENDCOMP

___

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

Re: solve error 180-322

Tom — Tue, 31 Mar 2020 01:27:19 GMT

Do not include the line number in your code.

Re: solve error 180-322

beaubrunmrmr — Tue, 31 Mar 2020 01:38:45 GMT

what do you mean by line numbers?

Re: solve error 180-322

Tom — Tue, 31 Mar 2020 02:06:43 GMT

The SAS log show line numbers and the text of the line of code. So in your logs the SAS generate line numbers are the numbers like 71, 72, etc. at the left margin. But the actual code that you submitted also has numbers at the beginning of the lines. Numbers like 1,2,3 with periods after them. Remove that stuff and just have the CODE in the program.

The start of your program should look something like this:

PROC IMPORT OUT=salesByProductByDate DATAFILE=
 "/home/emilymoore20/EPG194/output/myTestFolder/BSA570v4_Week3_assignment_data.xlsx"
 DBMS=xlsx REPLACE
;
 GETNAMES=YES;
run;

DATA salesByProductByDate ;
 SET salesByProductByDate ;

etc.