https://communities.sas.com/t5/SAS-Programming/How-to-list-all-the-text-answers-in-the-one-column/m-p/621527#M182702 <P>No, I only the 20 different answers, not the full list of 500 rows.&nbsp;&nbsp;</P> Fri, 31 Jan 2020 19:05:13 GMT ybz12003 2020-01-31T19:05:13Z https://communities.sas.com/t5/SAS-Programming/How-to-list-all-the-text-answers-in-the-one-column/m-p/621525#M182700 <P>Hello,</P> <P>&nbsp;</P> <P>I have around twenty&nbsp;different answers in one column 'A'.&nbsp;&nbsp; Column A&nbsp;is in text format.&nbsp; &nbsp;I would like to get a full list for all of them.&nbsp;&nbsp; Any idea how?&nbsp; Basely, I would like to use the method to apply for the other ten variables.&nbsp;&nbsp; Thanks!</P> Fri, 31 Jan 2020 18:54:06 GMT https://communities.sas.com/t5/SAS-Programming/How-to-list-all-the-text-answers-in-the-one-column/m-p/621525#M182700 ybz12003 2020-01-31T18:54:06Z https://communities.sas.com/t5/SAS-Programming/How-to-list-all-the-text-answers-in-the-one-column/m-p/621526#M182701 <P>The simple answer is that PROC PRINT will create such a list.</P> <P>&nbsp;</P> <P>Can you be more specific about what you mean by "a full list"?</P> Fri, 31 Jan 2020 18:57:05 GMT https://communities.sas.com/t5/SAS-Programming/How-to-list-all-the-text-answers-in-the-one-column/m-p/621526#M182701 PaigeMiller 2020-01-31T18:57:05Z https://communities.sas.com/t5/SAS-Programming/How-to-list-all-the-text-answers-in-the-one-column/m-p/621527#M182702 <P>No, I only the 20 different answers, not the full list of 500 rows.&nbsp;&nbsp;</P> Fri, 31 Jan 2020 19:05:13 GMT https://communities.sas.com/t5/SAS-Programming/How-to-list-all-the-text-answers-in-the-one-column/m-p/621527#M182702 ybz12003 2020-01-31T19:05:13Z https://communities.sas.com/t5/SAS-Programming/How-to-list-all-the-text-answers-in-the-one-column/m-p/621529#M182703 <P>How about this:</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">proc sql; select distinct a from mydataset; quit;</CODE></PRE> Fri, 31 Jan 2020 19:13:01 GMT https://communities.sas.com/t5/SAS-Programming/How-to-list-all-the-text-answers-in-the-one-column/m-p/621529#M182703 PaigeMiller 2020-01-31T19:13:01Z https://communities.sas.com/t5/SAS-Programming/How-to-list-all-the-text-answers-in-the-one-column/m-p/621531#M182704 <P>Awesome!!<img id="womanvery-happy" class="emoticon emoticon-womanvery-happy" src="https://communities.sas.com/i/smilies/16x16_woman-very-happy.png" alt="Woman Very Happy" title="Woman Very Happy" /></P> Fri, 31 Jan 2020 19:20:06 GMT https://communities.sas.com/t5/SAS-Programming/How-to-list-all-the-text-answers-in-the-one-column/m-p/621531#M182704 ybz12003 2020-01-31T19:20:06Z