topic Re: help in SAS Enterprise Guide

topic Re: help in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Help/m-p/550645#M33440 <P>Do not repeat posts with the same content. Keep the question in one thread, where it is much easier to follow the stream of questions and answers.</P> Fri, 12 Apr 2019 14:08:55 GMT Kurt_Bremser 2019-04-12T14:08:55Z Help https://communities.sas.com/t5/SAS-Enterprise-Guide/Help/m-p/550605#M33426 <P><BR />Could somebody kindly help me ?</P><P> </P><P>How do I correct?</P><P> </P><P>What is wrong in my code, I received the message:</P><P> </P><P>ERROR 22-322: Syntax error, expecting one of the following: a name, ;, (, *, -, /, :, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_.</P><P>ERROR 76-322: Syntax error, statement will be ignored.</P><P> </P><P>Code:</P><P>_______________________________________________</P><P>%let inset=dadosNOV18_mod_samp ; /* data set name */</P><P>%let target=FLAG_PORT_OUT; /* target variable (y) */</P><P>%let jorquec= d:/SAS/jorquec; /* designated folder for exporting outputs */</P><P>%let varall= pm_activity_level /* list of variables to be assessed*/</P><P>calling_circle_size</P><P>influencer_score</P><P>credit_band</P><P>data_allowance</P><P>mins_allowance</P><P>promo_data_allowance</P><P>texts_allowance</P><P>mins_utilsation</P><P>texts_utilsation</P><P>data_utilsation</P><P>rm.TENURE_MONTHS</P><P>rm.contract_flag</P><P>rm.contract_term_new</P><P>rm.pre_pri_accept_flag</P><P>;</P><P> </P><P><BR />%let tiermax=6; /* max number of bins to assign to variables */</P><P>%let ivthresh=0.1; /* set to 0 if you want to see output graphs for all variables */</P><P>%let outgraph=iv_woe_graph; /* pdf graph for top predictors */</P><P>%let ivout=iv_ranked; /* output file in txt for Information Value */</P><P>%let woeout=woe_ranked; /* output file in txt for Weight of Evidence */</P><P>%let libdata=jorquec; /* name of library where the data set is stored. */</P><P>%let outcome=pct_port_out; /* name of target for summary tables */</P><P>%let outname=% Customers Port_out; /* label of target for summary tables and graphs */</P><P>ods output nlevels=checkfreq;</P><P>proc freq data=&libdata..&inset nlevels;</P><P>tables &varall/noprint;</P><P>run;</P> Fri, 12 Apr 2019 12:59:21 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Help/m-p/550605#M33426 jorquec 2019-04-12T12:59:21Z Re: Help https://communities.sas.com/t5/SAS-Enterprise-Guide/Help/m-p/550612#M33427 <P>this line of code is missing a semicolon</P> <P>where is the ;</P> <P><SPAN style="display: inline !important; float: none; background-color: #f4f4f4; color: #333333; font-family: 'HelevticaNeue-light','Helvetica Neue',Helvetica,Arial,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; line-height: 150%; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;">%let varall= pm_activity_level /* list of variables to be assessed*/</SPAN></P> <P><SPAN style="display: inline !important; float: none; background-color: #f4f4f4; color: #333333; font-family: 'HelevticaNeue-light','Helvetica Neue',Helvetica,Arial,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; line-height: 150%; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;">it should be after the pm_activity_level like below</SPAN></P> <P><SPAN style="display: inline !important; float: none; background-color: #f4f4f4; color: #333333; font-family: 'HelevticaNeue-light','Helvetica Neue',Helvetica,Arial,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; line-height: 150%; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;">%let varall= pm_activity_level; /* list of variables to be assessed*/</SPAN></P> Fri, 12 Apr 2019 13:12:23 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Help/m-p/550612#M33427 VDD 2019-04-12T13:12:23Z Re: Help https://communities.sas.com/t5/SAS-Enterprise-Guide/Help/m-p/550616#M33429 <P>These four</P> <PRE>rm.TENURE_MONTHS rm.contract_flag rm.contract_term_new rm.pre_pri_accept_flag </PRE> <P>are not valid variable names for proc freq.</P> <P> </P> <P>If that does not fix it, post your <EM>whole</EM> log of the %let statements and the failing step, using the {I} button.</P> Fri, 12 Apr 2019 13:24:14 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Help/m-p/550616#M33429 Kurt_Bremser 2019-04-12T13:24:14Z Re: Help https://communities.sas.com/t5/SAS-Enterprise-Guide/Help/m-p/550619#M33430 <P>ok many thanks but why after  fix this this I can not see the output with the results ? Could you please tell me gow to print the information value table in the end?</P> Fri, 12 Apr 2019 13:28:38 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Help/m-p/550619#M33430 jorquec 2019-04-12T13:28:38Z help information value https://communities.sas.com/t5/SAS-Enterprise-Guide/Help/m-p/550627#M33437 <P><FONT color="#0000ff" face="Courier New" size="3">Hi</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">could someone kindly help me ?I am a SAS tarter,  I copied this code from web, but I dont know how tor print an output to see the information value results.</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">How do I correct?</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">Many thanks </FONT></P><P>____________________________________________________</P><P>CODE</P><P> </P><P><FONT color="#0000ff" face="Courier New" size="3">%let</FONT><FONT face="Courier New" size="3"> inset=dadosNOV18_mod_samp ; </FONT><FONT color="#008000" face="Courier New" size="3">/* data set name */</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">%let</FONT><FONT face="Courier New" size="3"> target=FLAG_PORT_OUT; </FONT><FONT color="#008000" face="Courier New" size="3">/* target variable (y) */</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">%let</FONT><FONT face="Courier New" size="3"> jorquec= d:/SAS/jorquec; </FONT><FONT color="#008000" face="Courier New" size="3">/* designated folder for exporting outputs */</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">%let</FONT><FONT face="Courier New" size="3"> varall= pm_activity_level </FONT><FONT color="#008000" face="Courier New" size="3">/* list of variables to be assessed*/</FONT></P><P> </P><P>calling_circle_size</P><P>influencer_score</P><P>credit_band</P><P>data_allowance</P><P>mins_allowance</P><P>promo_data_allowance</P><P>texts_allowance</P><P>mins_utilsation</P><P>texts_utilsation</P><P>data_utilsation</P><P>;</P><P><FONT color="#0000ff" face="Courier New" size="3">%let</FONT><FONT face="Courier New" size="3"> tiermax=6; </FONT><FONT color="#008000" face="Courier New" size="3">/* max number of bins to assign to variables */</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">%let</FONT><FONT face="Courier New" size="3"> ivthresh=0.1; </FONT><FONT color="#008000" face="Courier New" size="3">/* set to 0 if you want to see output graphs for all variables */</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">%let</FONT><FONT face="Courier New" size="3"> outgraph=iv_woe_graph; </FONT><FONT color="#008000" face="Courier New" size="3">/* pdf graph for top predictors */</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">%let</FONT><FONT face="Courier New" size="3"> ivout=iv_ranked; </FONT><FONT color="#008000" face="Courier New" size="3">/* output file in txt for Information Value */</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">%let</FONT><FONT face="Courier New" size="3"> woeout=woe_ranked; </FONT><FONT color="#008000" face="Courier New" size="3">/* output file in txt for Weight of Evidence */</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">%let</FONT><FONT face="Courier New" size="3"> libdata=jorquec; </FONT><FONT color="#008000" face="Courier New" size="3">/* name of library where the data set is stored. */</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">%let</FONT><FONT face="Courier New" size="3"> outcome=pct_port_out; </FONT><FONT color="#008000" face="Courier New" size="3">/* name of target for summary tables */</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">%let</FONT><FONT face="Courier New" size="3"> outname=% Customers Port_out; </FONT><FONT color="#008000" face="Courier New" size="3">/* label of target for summary tables and graphs */</FONT></P><P> </P> Fri, 12 Apr 2019 13:40:25 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Help/m-p/550627#M33437 jorquec 2019-04-12T13:40:25Z Re: Help https://communities.sas.com/t5/SAS-Enterprise-Guide/Help/m-p/550636#M33434 <P>Please read my post again, especially the last line.</P> <P> </P> <P>And tell us what you expect to see.</P> Fri, 12 Apr 2019 13:54:51 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Help/m-p/550636#M33434 Kurt_Bremser 2019-04-12T13:54:51Z help https://communities.sas.com/t5/SAS-Enterprise-Guide/Help/m-p/550641#M33439 <P><FONT color="#0000ff" face="Courier New">Please could someone kindly help me ?I am a SAS tarter,  I copied this code from web, but I dont know how tor print an output to see the information value results.</FONT></P><P><FONT color="#0000ff" face="Courier New">It said a txt but I would like to see in sas windown output.</FONT></P><P><FONT color="#0000ff" face="Courier New">Also txt file it doesnt appear.</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">How do I correct?</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">Many thanks </FONT></P><P>____________________________________________________</P><P>CODE</P><P> </P><P><FONT color="#0000ff" face="Courier New" size="3">%let</FONT><FONT face="Courier New" size="3"> inset=dadosNOV18_mod_samp ; </FONT><FONT color="#008000" face="Courier New" size="3">/* data set name */</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">%let</FONT><FONT face="Courier New" size="3"> target=FLAG_PORT_OUT; </FONT><FONT color="#008000" face="Courier New" size="3">/* target variable (y) */</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">%let</FONT><FONT face="Courier New" size="3"> jorquec= d:/SAS/jorquec; </FONT><FONT color="#008000" face="Courier New" size="3">/* designated folder for exporting outputs */</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">%let</FONT><FONT face="Courier New" size="3"> varall= pm_activity_level </FONT><FONT color="#008000" face="Courier New" size="3">/* list of variables to be assessed*/</FONT></P><P> </P><P>calling_circle_size</P><P>influencer_score</P><P>credit_band</P><P>data_allowance</P><P>mins_allowance</P><P>promo_data_allowance</P><P>texts_allowance</P><P>mins_utilsation</P><P>texts_utilsation</P><P>data_utilsation</P><P>;</P><P><FONT color="#0000ff" face="Courier New" size="3">%let</FONT><FONT face="Courier New" size="3"> tiermax=6; </FONT><FONT color="#008000" face="Courier New" size="3">/* max number of bins to assign to variables */</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">%let</FONT><FONT face="Courier New" size="3"> ivthresh=0.1; </FONT><FONT color="#008000" face="Courier New" size="3">/* set to 0 if you want to see output graphs for all variables */</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">%let</FONT><FONT face="Courier New" size="3"> outgraph=iv_woe_graph; </FONT><FONT color="#008000" face="Courier New" size="3">/* pdf graph for top predictors */</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">%let</FONT><FONT face="Courier New" size="3"> ivout=iv_ranked; </FONT><FONT color="#008000" face="Courier New" size="3">/* output file in txt for Information Value */</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">%let</FONT><FONT face="Courier New" size="3"> woeout=woe_ranked; </FONT><FONT color="#008000" face="Courier New" size="3">/* output file in txt for Weight of Evidence */</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">%let</FONT><FONT face="Courier New" size="3"> libdata=jorquec; </FONT><FONT color="#008000" face="Courier New" size="3">/* name of library where the data set is stored. */</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">%let</FONT><FONT face="Courier New" size="3"> outcome=pct_port_out; </FONT><FONT color="#008000" face="Courier New" size="3">/* name of target for summary tables */</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">%let</FONT><FONT face="Courier New" size="3"> outname=% Customers Port_out; </FONT><FONT color="#008000" face="Courier New" size="3">/* label of target for summary tables and graphs */</FONT></P> Fri, 12 Apr 2019 14:03:20 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Help/m-p/550641#M33439 jorquec 2019-04-12T14:03:20Z Re: help information value https://communities.sas.com/t5/SAS-Enterprise-Guide/Help/m-p/550644#M33438 <P>There is nothing there that would provide output.</P> <P> </P> <P>As a starter, I would <U><STRONG>STRONGLY</STRONG></U> recommend that you take the freely available online Programming 1 course instead of trying to run obscure code from the 'net. You will learn much better and quicker with the first.</P> Fri, 12 Apr 2019 14:05:40 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Help/m-p/550644#M33438 Kurt_Bremser 2019-04-12T14:05:40Z Re: help https://communities.sas.com/t5/SAS-Enterprise-Guide/Help/m-p/550645#M33440 <P>Do not repeat posts with the same content. Keep the question in one thread, where it is much easier to follow the stream of questions and answers.</P> Fri, 12 Apr 2019 14:08:55 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Help/m-p/550645#M33440 Kurt_Bremser 2019-04-12T14:08:55Z Re: help information value https://communities.sas.com/t5/SAS-Enterprise-Guide/Help/m-p/550646#M33441 <P>I would like to print  the table with the Information value reuslts.</P><P> </P><P> </P><P> </P><P><STRONG><FONT color="#000080" face="Courier New" size="3">proc</FONT></STRONG> <STRONG><FONT color="#000080" face="Courier New" size="3">hpbin</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="3">data</FONT><FONT face="Courier New" size="3">=&</FONT><FONT color="#008080" face="Courier New" size="3">libdata.<STRONG>.</STRONG></FONT><FONT face="Courier New" size="3">&inset </FONT><FONT color="#0000ff" face="Courier New" size="3">WOE</FONT> <FONT color="#0000ff" face="Courier New" size="3">BINS_META</FONT><FONT face="Courier New" size="3">=Mapping;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">target</FONT><FONT face="Courier New" size="3"> FLAG_PORT_OUT/</FONT><FONT color="#0000ff" face="Courier New" size="3">level</FONT><FONT face="Courier New" size="3">=nominal </FONT><FONT color="#0000ff" face="Courier New" size="3">order</FONT><FONT face="Courier New" size="3">=desc;</FONT></P><P> </P><P> </P><P><STRONG><FONT color="#000080" face="Courier New" size="3">run</FONT></STRONG><FONT face="Courier New" size="3">;</FONT></P><P> </P><P><FONT face="Courier New" size="3">I guess this should be fine. </FONT></P><P> </P> Fri, 12 Apr 2019 14:11:43 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Help/m-p/550646#M33441 jorquec 2019-04-12T14:11:43Z Re: Help https://communities.sas.com/t5/SAS-Enterprise-Guide/Help/m-p/550817#M33445 Assuming you fixed all the errors, your program would create a SAS data set named checkfreq. If you want to see what's in it, you have to add:<BR /><BR />proc print data=checkfreq;<BR />run;<BR /><BR />In the long run, there is no substitute for learning the basics of SAS. You can't learn enough by asking a question when you are stumped. That's a good thing to do, but it's not enough. Sat, 13 Apr 2019 00:48:08 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Help/m-p/550817#M33445 Astounding 2019-04-13T00:48:08Z