topic How to evalue a formula in data step in SAS Programming

topic How to evalue a formula in data step in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-evalue-a-formula-in-data-step/m-p/517197#M139772 <P>How SAS gurus,</P><P> </P><P>I have a simple question but couldn't figure it out. Not sure if it is doable but your help will be appreciated.</P><P>If a data set has two columns, one is the value, the other is the format, how can I created a third Column using the value of the two?</P><P> </P><P>proc format  ;</P><P>value go</P><P>0='no' 1='yes';</P><P>value to</P><P>0='missing' 1='present';</P><P>run;</P><P> </P><P></P><DIV class="lia-page"><CENTER><DIV class="MinimumWidthContainer"><DIV class="min-width-wrapper"><DIV class="min-width"><DIV class="lia-content"><DIV class="lia-quilt lia-quilt-forum-topic-page lia-quilt-layout-two-column-main-side lia-top-quilt"><DIV class="lia-quilt-row lia-quilt-row-header"><DIV class="lia-quilt-row lia-quilt-row-main"><DIV class="lia-quilt-column lia-quilt-column-18 lia-quilt-column-left lia-quilt-column-main-content"><DIV class="lia-quilt-column-alley lia-quilt-column-alley-left"><DIV class="lia-component-message-list"><DIV class="linear-message-list message-list"><DIV class="lia-linear-display-message-view"><DIV><DIV class="lia-message-view message-uid-68127"><DIV><DIV class="lia-js-resize-images lia-component-forums-widget-board-message-view"><DIV><DIV class="accepted-solution lia-message-board lia-panel-message lia-js-data-messageUid-68127"><DIV class="lia-panel-message-content"><DIV class="lia-decoration-border"><DIV class="lia-decoration-border-content"><DIV><DIV><DIV class="lia-quilt lia-quilt-forum-message lia-quilt-layout-forum-message"><DIV class="lia-quilt-row lia-quilt-row-forum-message-main"><DIV class="lia-quilt-column lia-quilt-column-20 lia-quilt-column-right lia-quilt-column-main-right"><DIV class="lia-quilt-column-alley lia-quilt-column-alley-right"><DIV class="lia-component-body"><DIV class="lia-message-body"><DIV class="lia-message-body-content"><PRE class=" language-sas"><CODE class=" language-sas"><SPAN class="token procnames">DATA</SPAN> temp<SPAN class="token punctuation">;</SPAN> <SPAN class="token keyword">INPUT</SPAN> value variable $ <SPAN class="token punctuation">;</SPAN> <SPAN class="token datalines"><SPAN class="token keyword">DATALINES</SPAN><SPAN class="token punctuation">;</SPAN><SPAN class="token data string">1 go<BR />1 to</SPAN><SPAN class="token punctuation">;</SPAN></SPAN> </CODE></PRE></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></CENTER></DIV><P>My goal is to crate a third variable new using put(value,variable.) as a formula.  </P><P> </P><P>I have tried using sql to created a formula, in this example, put(1.go.) and put(1, to.)  and how can I made data looks like:</P><P> </P><DIV class="lia-page"><CENTER><DIV class="MinimumWidthContainer"><DIV class="min-width-wrapper"><DIV class="min-width"><DIV class="lia-content"><DIV class="lia-quilt lia-quilt-forum-topic-page lia-quilt-layout-two-column-main-side lia-top-quilt"><DIV class="lia-quilt-row lia-quilt-row-header"><DIV class="lia-quilt-row lia-quilt-row-main"><DIV class="lia-quilt-column lia-quilt-column-18 lia-quilt-column-left lia-quilt-column-main-content"><DIV class="lia-quilt-column-alley lia-quilt-column-alley-left"><DIV class="lia-component-message-list"><DIV class="linear-message-list message-list"><DIV class="lia-linear-display-message-view"><DIV><DIV class="lia-message-view message-uid-68127"><DIV><DIV class="lia-js-resize-images lia-component-forums-widget-board-message-view"><DIV><DIV class="accepted-solution lia-message-board lia-panel-message lia-js-data-messageUid-68127"><DIV class="lia-panel-message-content"><DIV class="lia-decoration-border"><DIV class="lia-decoration-border-content"><DIV><DIV><DIV class="lia-quilt lia-quilt-forum-message lia-quilt-layout-forum-message"><DIV class="lia-quilt-row lia-quilt-row-forum-message-main"><DIV class="lia-quilt-column lia-quilt-column-20 lia-quilt-column-right lia-quilt-column-main-right"><DIV class="lia-quilt-column-alley lia-quilt-column-alley-right"><DIV class="lia-component-body"><DIV class="lia-message-body"><DIV class="lia-message-body-content"><PRE class=" language-sas"><CODE class=" language-sas"><SPAN class="token procnames">value variable new <BR /></SPAN><SPAN class="token datalines"><SPAN class="token data string">1 go yes<BR />1 to present </SPAN><SPAN class="token punctuation">;</SPAN></SPAN> </CODE></PRE></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></CENTER></DIV><P>Thanks!</P><P> </P> Thu, 29 Nov 2018 19:10:42 GMT songlh15 2018-11-29T19:10:42Z How to evalue a formula in data step https://communities.sas.com/t5/SAS-Programming/How-to-evalue-a-formula-in-data-step/m-p/517197#M139772 <P>How SAS gurus,</P><P> </P><P>I have a simple question but couldn't figure it out. Not sure if it is doable but your help will be appreciated.</P><P>If a data set has two columns, one is the value, the other is the format, how can I created a third Column using the value of the two?</P><P> </P><P>proc format  ;</P><P>value go</P><P>0='no' 1='yes';</P><P>value to</P><P>0='missing' 1='present';</P><P>run;</P><P> </P><P></P><DIV class="lia-page"><CENTER><DIV class="MinimumWidthContainer"><DIV class="min-width-wrapper"><DIV class="min-width"><DIV class="lia-content"><DIV class="lia-quilt lia-quilt-forum-topic-page lia-quilt-layout-two-column-main-side lia-top-quilt"><DIV class="lia-quilt-row lia-quilt-row-header"><DIV class="lia-quilt-row lia-quilt-row-main"><DIV class="lia-quilt-column lia-quilt-column-18 lia-quilt-column-left lia-quilt-column-main-content"><DIV class="lia-quilt-column-alley lia-quilt-column-alley-left"><DIV class="lia-component-message-list"><DIV class="linear-message-list message-list"><DIV class="lia-linear-display-message-view"><DIV><DIV class="lia-message-view message-uid-68127"><DIV><DIV class="lia-js-resize-images lia-component-forums-widget-board-message-view"><DIV><DIV class="accepted-solution lia-message-board lia-panel-message lia-js-data-messageUid-68127"><DIV class="lia-panel-message-content"><DIV class="lia-decoration-border"><DIV class="lia-decoration-border-content"><DIV><DIV><DIV class="lia-quilt lia-quilt-forum-message lia-quilt-layout-forum-message"><DIV class="lia-quilt-row lia-quilt-row-forum-message-main"><DIV class="lia-quilt-column lia-quilt-column-20 lia-quilt-column-right lia-quilt-column-main-right"><DIV class="lia-quilt-column-alley lia-quilt-column-alley-right"><DIV class="lia-component-body"><DIV class="lia-message-body"><DIV class="lia-message-body-content"><PRE class=" language-sas"><CODE class=" language-sas"><SPAN class="token procnames">DATA</SPAN> temp<SPAN class="token punctuation">;</SPAN> <SPAN class="token keyword">INPUT</SPAN> value variable $ <SPAN class="token punctuation">;</SPAN> <SPAN class="token datalines"><SPAN class="token keyword">DATALINES</SPAN><SPAN class="token punctuation">;</SPAN><SPAN class="token data string">1 go<BR />1 to</SPAN><SPAN class="token punctuation">;</SPAN></SPAN> </CODE></PRE></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></CENTER></DIV><P>My goal is to crate a third variable new using put(value,variable.) as a formula.  </P><P> </P><P>I have tried using sql to created a formula, in this example, put(1.go.) and put(1, to.)  and how can I made data looks like:</P><P> </P><DIV class="lia-page"><CENTER><DIV class="MinimumWidthContainer"><DIV class="min-width-wrapper"><DIV class="min-width"><DIV class="lia-content"><DIV class="lia-quilt lia-quilt-forum-topic-page lia-quilt-layout-two-column-main-side lia-top-quilt"><DIV class="lia-quilt-row lia-quilt-row-header"><DIV class="lia-quilt-row lia-quilt-row-main"><DIV class="lia-quilt-column lia-quilt-column-18 lia-quilt-column-left lia-quilt-column-main-content"><DIV class="lia-quilt-column-alley lia-quilt-column-alley-left"><DIV class="lia-component-message-list"><DIV class="linear-message-list message-list"><DIV class="lia-linear-display-message-view"><DIV><DIV class="lia-message-view message-uid-68127"><DIV><DIV class="lia-js-resize-images lia-component-forums-widget-board-message-view"><DIV><DIV class="accepted-solution lia-message-board lia-panel-message lia-js-data-messageUid-68127"><DIV class="lia-panel-message-content"><DIV class="lia-decoration-border"><DIV class="lia-decoration-border-content"><DIV><DIV><DIV class="lia-quilt lia-quilt-forum-message lia-quilt-layout-forum-message"><DIV class="lia-quilt-row lia-quilt-row-forum-message-main"><DIV class="lia-quilt-column lia-quilt-column-20 lia-quilt-column-right lia-quilt-column-main-right"><DIV class="lia-quilt-column-alley lia-quilt-column-alley-right"><DIV class="lia-component-body"><DIV class="lia-message-body"><DIV class="lia-message-body-content"><PRE class=" language-sas"><CODE class=" language-sas"><SPAN class="token procnames">value variable new <BR /></SPAN><SPAN class="token datalines"><SPAN class="token data string">1 go yes<BR />1 to present </SPAN><SPAN class="token punctuation">;</SPAN></SPAN> </CODE></PRE></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></CENTER></DIV><P>Thanks!</P><P> </P> Thu, 29 Nov 2018 19:10:42 GMT https://communities.sas.com/t5/SAS-Programming/How-to-evalue-a-formula-in-data-step/m-p/517197#M139772 songlh15 2018-11-29T19:10:42Z Re: How to evalue a formula in data step https://communities.sas.com/t5/SAS-Programming/How-to-evalue-a-formula-in-data-step/m-p/517198#M139773 <P>Hi,</P> <P> </P> <P>Welcome to SAS Community. </P> <P> </P> <P>Can you be more specific, it is not so clear what your trying to do here. Simply present the data you have and what is the output your expecting.</P> Thu, 29 Nov 2018 19:17:44 GMT https://communities.sas.com/t5/SAS-Programming/How-to-evalue-a-formula-in-data-step/m-p/517198#M139773 SuryaKiran 2018-11-29T19:17:44Z Re: How to evalue a formula in data step https://communities.sas.com/t5/SAS-Programming/How-to-evalue-a-formula-in-data-step/m-p/517217#M139784 <P>Thanks for your quick response!</P><P>I received a data set with two separated variables as my example shown above,.  I'm trying to create one new variable using values existing two existing variables.  </P><P>current data:</P><P>Variable Value</P><P>go  1</P><P>to 1</P><P>I wanted to create a new variable called new using values from Variable and Value, the output should be</P><P>Variable Value New</P><P>go  1 yes</P><P>to 1 present</P><P> </P><P>Thanks again.</P><P> </P><P> </P><P> </P><P> </P><P> </P> Thu, 29 Nov 2018 20:07:13 GMT https://communities.sas.com/t5/SAS-Programming/How-to-evalue-a-formula-in-data-step/m-p/517217#M139784 songlh15 2018-11-29T20:07:13Z Re: How to evalue a formula in data step https://communities.sas.com/t5/SAS-Programming/How-to-evalue-a-formula-in-data-step/m-p/517225#M139787 <P>The PUTN() and PUTC() functions can use an expression for the name of the format.</P> <P>First let's make your formats using names that are more descriptive of what they do.  Let's also make a format we can use to associate which format is used for which variable name.</P> <PRE><CODE class=" language-sas">proc format ; value yesno 1='yes' other='no'; value present 1='present' other='missing'; value $format 'GO'='YESNO.' 'TO'='PRESENT.' ; run;</CODE></PRE> <P>Now let's make some test data:</P> <PRE><CODE class=" language-sas">data temp; length variable $32 value 8; do variable='go','to'; do value=0,1; output; end; end; run;</CODE></PRE> <P>And now let's figure out what decode to generate for each value/variable pair.</P> <PRE><CODE class=" language-sas">data want ; set temp; length decode $50 ; decode = putn(value,put(upcase(variable),$format.)); run;</CODE></PRE> <PRE>Obs variable value decode 1 go 0 no 2 go 1 yes 3 to 0 missing 4 to 1 present</PRE> Thu, 29 Nov 2018 20:29:38 GMT https://communities.sas.com/t5/SAS-Programming/How-to-evalue-a-formula-in-data-step/m-p/517225#M139787 Tom 2018-11-29T20:29:38Z Re: How to evalue a formula in data step https://communities.sas.com/t5/SAS-Programming/How-to-evalue-a-formula-in-data-step/m-p/517643#M140003 <P>Thanks so much, your code works for that task!</P><P> </P><P>One step further, if  put(value,variable.) string have been generated  in third variable, how can we retrieve the value? in other words, how can we make the third variable run? Taking the same data as an example, if a table is given below, how can we let decode run and get the correct format?</P><P> </P><P>Thanks!</P><P> </P><DIV class="lia-page"><CENTER><DIV class="MinimumWidthContainer"><DIV class="min-width-wrapper"><DIV class="min-width"><DIV class="lia-content"><DIV class="lia-quilt lia-quilt-reply-page lia-quilt-layout-one-column lia-top-quilt"><DIV class="lia-quilt-row lia-quilt-row-header"><DIV class="lia-quilt-row lia-quilt-row-main"><DIV class="lia-quilt-column lia-quilt-column-24 lia-quilt-column-single lia-quilt-column-main-content"><DIV class="lia-quilt-column-alley lia-quilt-column-alley-single"><DIV class="lia-panel lia-panel-section lia-component-editor"><DIV class="lia-decoration-border"><DIV class="lia-decoration-border-content"><DIV><DIV class="lia-panel-content-wrapper"><DIV class="lia-panel-content"><DIV class="lia-message-view message-uid-517225"><DIV><DIV class="lia-js-resize-images lia-component-forums-widget-board-message-view"><DIV><DIV class="lia-message-board lia-panel-message lia-js-data-messageUid-517225"><DIV class="lia-panel-message-content"><DIV class="lia-decoration-border"><DIV class="lia-decoration-border-content"><DIV><DIV><DIV class="lia-quilt lia-quilt-forum-message lia-quilt-layout-forum-message"><DIV class="lia-quilt-row lia-quilt-row-forum-message-main"><DIV class="lia-quilt-column lia-quilt-column-20 lia-quilt-column-right lia-quilt-column-main-right"><DIV class="lia-quilt-column-alley lia-quilt-column-alley-right"><DIV class="lia-message-body lia-component-body"><DIV class="lia-message-body-content"><PRE>Obs variable value decode 1 go 0 put(0,go.) <BR /> 2 go 1 put(1,go.) 3 to 0 put(0,to.) 4 to 1 put(1,to.)</PRE></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></CENTER></DIV> Fri, 30 Nov 2018 20:24:01 GMT https://communities.sas.com/t5/SAS-Programming/How-to-evalue-a-formula-in-data-step/m-p/517643#M140003 songlh15 2018-11-30T20:24:01Z Re: How to evalue a formula in data step https://communities.sas.com/t5/SAS-Programming/How-to-evalue-a-formula-in-data-step/m-p/517648#M140006 <P>SAS needs to compile the data step before it starts running. If you have CODE in DATA then you will need to first run a step to generate a complete data step.  Then SAS can compile it and run it.  You can use CALL EXECUTE( ) or write the code to a file and use %INCLUDE to run it.</P> <P> </P> <PRE><CODE class=" language-sas">data have; input variable $ value decode $20.; cards; go 0 put(0,go.) go 1 put(1,go.) to 0 put(0,to.) to 1 put(1,to.) ; proc format ; value go 1='Go' other='Stay'; value to 1='There' other='Here'; run; filename code temp; data _null_; set have ; file code ; put 'if ' _n_ = ' then new=' decode ';' ; run; data want; set have ; length new $20. ; %include code/source2; run;</CODE></PRE> <PRE>Obs variable value decode new 1 go 0 put(0,go.) Stay 2 go 1 put(1,go.) Go 3 to 0 put(0,to.) Here 4 to 1 put(1,to.) There</PRE> <P> Log</P> <PRE>1450 data want; 1451 set have ; 1452 length new $20. ; 1453 %include code/source2; NOTE: %INCLUDE (level 1) file CODE is file .../#LN00047. 1454 +if _N_=1 then new=put(0,go.) ; 1455 +if _N_=2 then new=put(1,go.) ; 1456 +if _N_=3 then new=put(0,to.) ; 1457 +if _N_=4 then new=put(1,to.) ; NOTE: %INCLUDE (level 1) ending. 1458 run; NOTE: There were 4 observations read from the data set WORK.HAVE. NOTE: The data set WORK.WANT has 4 observations and 4 variables.</PRE> Fri, 30 Nov 2018 20:41:17 GMT https://communities.sas.com/t5/SAS-Programming/How-to-evalue-a-formula-in-data-step/m-p/517648#M140006 Tom 2018-11-30T20:41:17Z Re: How to evalue a formula in data step https://communities.sas.com/t5/SAS-Programming/How-to-evalue-a-formula-in-data-step/m-p/517653#M140009 <P>Awesome! This is so helpful! </P><P> </P> Fri, 30 Nov 2018 20:41:53 GMT https://communities.sas.com/t5/SAS-Programming/How-to-evalue-a-formula-in-data-step/m-p/517653#M140009 songlh15 2018-11-30T20:41:53Z