topic Re: debugging code in SAS studio in SAS Studio

topic Re: debugging code in SAS studio in SAS Studio https://communities.sas.com/t5/SAS-Studio/debugging-code-in-SAS-studio/m-p/636368#M8966 <P>It looks like you have line numbers in your code, that is, you have </P> <P> </P> <PRE>1. PROC IMPORT</PRE> <P>instead of </P> <PRE>PROC IMPORT</PRE> Tue, 31 Mar 2020 20:55:50 GMT JackHamilton 2020-03-31T20:55:50Z debugging code in SAS studio https://communities.sas.com/t5/SAS-Studio/debugging-code-in-SAS-studio/m-p/635933#M8961 <P>Seeking help in debugging the error code below </P><P> </P><DIV class="dijitContentPane dijitBorderContainer-child dijitBorderContainer-dijitContentPane dijitBorderContainerPane dijitAlignCenter dijitContentPaneSingleChild"><DIV class="dijitBorderContainer dijitContainer row-fluid dijitLayoutContainer"><DIV class="dijitContentPane dijitAlignCenter dijitContentPaneSingleChild dijitBorderContainer-child dijitBorderContainer-dijitContentPane dijitBorderContainerPane"><DIV class="tabs dijitBorderContainer dijitContainer dojoDndTarget sasStudioTabsParentContainer dijitLayoutContainer dojoDndContainerOver"><DIV class="dijitTabContainer dijitTabContainerTop dijitContainer dijitLayoutContainer tabStrip-disabled sasStudioTabsTabContainer sasStudioTabsTabContainerVertical sasStudioTabsTop dijitBorderContainer-child dijitBorderContainer-dijitTabContainerTop dijitBorderContainerPane dijitAlignCenter"><DIV class="dijitTabPaneWrapper dijitTabContainerTop-container dijitAlignCenter"><DIV class="dijitTabContainerTopChildWrapper dijitVisible"><DIV class="dijitBorderContainer dijitContainer sasStudioTabsTabContainerChild dijitTabPane dijitTabContainerTop-child dijitTabContainerTop-dijitBorderContainer dijitLayoutContainer"><DIV class="dijitBorderContainer dijitContainer dojoDndTarget dijitBorderContainer-child dijitBorderContainer-dijitBorderContainer dijitBorderContainerPane dijitAlignCenter dijitLayoutContainer dojoDndContainerOver"><DIV class="dijitTabContainer dijitTabContainerTop dijitContainer dijitLayoutContainer tabStrip-disabled sasSuiteTabs dijitBorderContainer-child dijitBorderContainer-dijitTabContainerTop dijitBorderContainerPane dijitAlignCenter"><DIV class="dijitTabPaneWrapper dijitTabContainerTop-container dijitAlignCenter"><DIV class="dijitTabContainerTopChildWrapper dijitVisible"><DIV class="dijitBorderContainer dijitContainer dijitTabPane dijitTabContainerTop-child dijitTabContainerTop-dijitBorderContainer dijitLayoutContainer"><DIV class="dijitBorderContainer dijitContainer dijitBorderContainer-child dijitBorderContainer-dijitBorderContainer dijitBorderContainerPane dijitAlignCenter dijitLayoutContainer"><DIV class="dijitContentPane dijitBorderContainer-child dijitBorderContainer-dijitContentPane dijitBorderContainerPane dijitAlignCenter"><DIV><DIV><DIV class="sasSource">OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;</DIV><DIV class="sasSource">70</DIV><DIV class="sasSource">71 1.PROC IMPORT OUT=salesByProductByDate DATAFILE=</DIV><DIV class="sasError">__</DIV><DIV class="sasError">180</DIV><DIV class="sasSource">71 ! "/home/emilymoore20/EPG194/output/myTestFolder/BSA570v4_Week3_assignment_data.xlsx"</DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">72 2.DBMS=xlsx REPLACE;</DIV><DIV class="sasNote"> </DIV><DIV class="sasSource">73 3.GETNAMES=YES;</DIV><DIV class="sasError">__</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">74 4.RUN;</DIV><DIV class="sasError">__</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">75 5.</DIV><DIV class="sasError">__</DIV><DIV class="sasError">180</DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">76 6.DATA salesByProductByDate;</DIV><DIV class="sasNote"> </DIV><DIV class="sasSource">77 7.SET salesByProductByDate;</DIV><DIV class="sasError">__</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">78 8.year = YEAR(date);</DIV><DIV class="sasError">__</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">79 9.month = YEAR(date);</DIV><DIV class="sasError">__</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">80 10.RUN;</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">81 11.</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">82 12.PROC REPORT DATA=salesByProductByDate NOWD;</DIV><DIV class="sasNote"> </DIV><DIV class="sasSource">83 13.COLUMN ('Sales' year month) product,(sales);</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">84 14.DEFINE year / GROUP STYLE (header)={background=lightgreen};</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">85 15.DEFINE month / GROUP STYLE (header)={background=lightgreen};</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">86 16.DEFINE product / ACROSS ' ' STYLE(header)={background=lightyellow};</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">87 17.DEFINE sales / SUM STYLE(header)={background=lightyellow} FORMAT=DOLLAR15.2;</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">88 18.BREAK AFTER year /SUMMARIZE DOL DUL;</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">89 19.RBREAK AFTER/SUMMARIZE;</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">90 20.COMPUTE AFTER year;</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">91 21.CALL DEFINE('year','style','style=Header{pretext="SubTotal " tagattr="Type:String"}');</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">92 22.ENDCOMP;</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">93 23.COMPUTE AFTER;</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">94 24.CALL DEFINE('year','style','style=Header{pretext="Grand Total " tagattr="Type:String"}');</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">95 25.ENDCOMP;</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">96 26.RUN</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">97 27.</DIV><DIV class="sasSource">98 28.TITLE '2015 Sales By Product';</DIV><DIV class="sasNote"> </DIV><DIV class="sasSource">99 29.PROC SGPLOT DATA=salesByProcudtByDate(WHERE=(year = 2015));</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">100 30.VBAR product / RESPONSE=sales GROUP=month GROUPDISPLAY=cluster</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">101 31.STAT=sum DATASKIN=gloss;</DIV><DIV class="sasNote"> </DIV><DIV class="sasSource">102 32.XAXIS DISPLAY=(nolabel noticks);</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">103 33.YAXIS GRID;</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">104 34.RUN;</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">105 35.</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">106 36.TITLE '2016 Sales By Product';</DIV><DIV class="sasNote"> </DIV><DIV class="sasSource">107 37.PROC SGPLOT DATA=salesByProductByDate(WHERE=(year = 2016));</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">108 38.VBAR product / RESPONSE=sales GROUP=month GROUPDISPLAY=cluster</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">109 39.STAT=sum DATASKIN=gloss;</DIV><DIV class="sasNote"> </DIV><DIV class="sasSource">110 40.XAXIS DISPLAY=(nolabel noticks);</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">111 41.YAXIS GRID;</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">112 42.RUN;</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">113 43.</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">114 44.TITLE '2017 Sales By Product';</DIV><DIV class="sasNote"> </DIV><DIV class="sasSource">115 45.PROC SGPLOT DATA=salesByProductByDate(WHERE=(year = 2017));</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">116 46.VBAR product / RESPONSE=sales GROUP=month GROUPDISPLAY=cluster</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">117 47.STAT=sum DATASKIN=gloss;</DIV><DIV class="sasNote"> </DIV><DIV class="sasSource">118 48.XAXIS DISPLAY=(nolabel noticks);</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">119 49.YAXIS GRID;</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">120 50.RUN;</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">121 51.</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">122 52.TITLE '2018 Sales By Product';</DIV><DIV class="sasNote"> </DIV><DIV class="sasSource">123 53.PROC SGPLOT DATA=salesByProductByDate(WHERE=(year = 2018));</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">124 54.VBAR product / RESPONSE=sales GROUP=month GROUPDISPLAY=cluster</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">125 55.STAT=sum DATASKIN=gloss;</DIV><DIV class="sasNote"> </DIV><DIV class="sasSource">126 56.XAXIS DISPLAY=(nolabel noticks);</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">127 57.YAXIS GRID;</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">128 58.RUN;</DIV><DIV class="sasError">___</DIV><DIV class="sasError">180</DIV><DIV class="sasNote"> </DIV><DIV class="sasError">ERROR 180-322: Statement is not valid or it is used out of proper order.</DIV><DIV class="sasSource"> </DIV><DIV class="sasSource">129</DIV><DIV class="sasSource">130</DIV><DIV class="sasSource">131 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;</DIV><DIV class="sasSource">142</DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV><DIV class="dijitContentPane statusBar dijitBorderContainer-child dijitBorderContainer-dijitContentPane dijitBorderContainerPane dijitAlignBottom"> </DIV> Mon, 30 Mar 2020 19:07:35 GMT https://communities.sas.com/t5/SAS-Studio/debugging-code-in-SAS-studio/m-p/635933#M8961 beaubrunmrmr 2020-03-30T19:07:35Z Re: debugging code in SAS studio https://communities.sas.com/t5/SAS-Studio/debugging-code-in-SAS-studio/m-p/636368#M8966 <P>It looks like you have line numbers in your code, that is, you have </P> <P> </P> <PRE>1. PROC IMPORT</PRE> <P>instead of </P> <PRE>PROC IMPORT</PRE> Tue, 31 Mar 2020 20:55:50 GMT https://communities.sas.com/t5/SAS-Studio/debugging-code-in-SAS-studio/m-p/636368#M8966 JackHamilton 2020-03-31T20:55:50Z