<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Get the values from another dataset column values in SAS Programming</title>
    <link>https://communities.sas.com/t5/SAS-Programming/Get-the-values-from-another-dataset-column-values/m-p/747753#M234756</link>
    <description>&lt;P&gt;Please show us examples of the datasets involved. A small portion of each data set ought to be sufficient. Please provide the data sets as DATA step code, as explained in &lt;A href="https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/" target="_self"&gt;these instructions&lt;/A&gt;. Do not provide the data as screen captures&amp;nbsp;or attachments.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Also please explain how we know what these steps should be, given the two data sets, especially the part of the code after THEN&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;PRE&gt;&lt;CODE class=" language-sas"&gt;if column_1= 'm' then delete ;
if column_1= 'nn' then clumn_1=plus ;&lt;/CODE&gt;&lt;/PRE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Mon, 14 Jun 2021 11:21:42 GMT</pubDate>
    <dc:creator>PaigeMiller</dc:creator>
    <dc:date>2021-06-14T11:21:42Z</dc:date>
    <item>
      <title>Get the values from another dataset column values</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Get-the-values-from-another-dataset-column-values/m-p/747734#M234744</link>
      <description>&lt;P&gt;Hi All,&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Need to run query based on another dataset column values.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Like&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;PRE&gt;&lt;CODE class=" language-sas"&gt;data a;

set b;

if column_1= 'm' then delete ;

if column_1= 'nn' then clumn_1=plus ;&lt;/CODE&gt;&lt;/PRE&gt;
&lt;P&gt;so&amp;nbsp; values(m,nn,etc) are in another X data set&lt;/P&gt;</description>
      <pubDate>Mon, 14 Jun 2021 10:28:25 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Get-the-values-from-another-dataset-column-values/m-p/747734#M234744</guid>
      <dc:creator>sathya66</dc:creator>
      <dc:date>2021-06-14T10:28:25Z</dc:date>
    </item>
    <item>
      <title>Re: Get the values from another dataset column values</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Get-the-values-from-another-dataset-column-values/m-p/747753#M234756</link>
      <description>&lt;P&gt;Please show us examples of the datasets involved. A small portion of each data set ought to be sufficient. Please provide the data sets as DATA step code, as explained in &lt;A href="https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/" target="_self"&gt;these instructions&lt;/A&gt;. Do not provide the data as screen captures&amp;nbsp;or attachments.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Also please explain how we know what these steps should be, given the two data sets, especially the part of the code after THEN&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;PRE&gt;&lt;CODE class=" language-sas"&gt;if column_1= 'm' then delete ;
if column_1= 'nn' then clumn_1=plus ;&lt;/CODE&gt;&lt;/PRE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 14 Jun 2021 11:21:42 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Get-the-values-from-another-dataset-column-values/m-p/747753#M234756</guid>
      <dc:creator>PaigeMiller</dc:creator>
      <dc:date>2021-06-14T11:21:42Z</dc:date>
    </item>
  </channel>
</rss>

