https://communities.sas.com/t5/SAS-Programming/Data-Cleaning/m-p/498901#M132662 <P>Hi everyone.</P><P>&nbsp;</P><P>I need help with data cleaning.</P><P>&nbsp;</P><P>I have attached a sample data set with the following variables:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>OBS</TD><TD>LN_LOC_P1_1</TD><TD>LN_LOC_P1_2</TD><TD>LN_LOC_P1_3</TD><TD>LN_LOC_P1_4</TD><TD>LN_TREAT_P1_1</TD><TD>LN_TREAT_P1_2</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE><TBODY><TR><TD>LN_TREAT_P1_3</TD><TD>LN_TREAT_P1_4</TD><TD>LN_LENGTH_P1_1</TD><TD>LN_LENGTH_P1_2</TD><TD>LN_LENGTH_P1_3</TD><TD>LN_LENGTH_P1_4</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P><BR />LN_LOC variables have 6 choices (1 - 6).</P><P>LN_TREAT variables have 4 choices (1 - 4).</P><P>&nbsp;</P><P>LN_LENGTH variables represent dimensions.</P><P>&nbsp;</P><P>From this data set, I just need the LENGTHS of OBSERVATIONS&nbsp;with LN_LOC = 6 AND LN_TREAT = 4.</P><P>&nbsp;</P><P>Thank you for your help.</P><P>&nbsp;</P> Wed, 26 Sep 2018 01:00:36 GMT yoyong 2018-09-26T01:00:36Z https://communities.sas.com/t5/SAS-Programming/Data-Cleaning/m-p/498901#M132662 <P>Hi everyone.</P><P>&nbsp;</P><P>I need help with data cleaning.</P><P>&nbsp;</P><P>I have attached a sample data set with the following variables:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>OBS</TD><TD>LN_LOC_P1_1</TD><TD>LN_LOC_P1_2</TD><TD>LN_LOC_P1_3</TD><TD>LN_LOC_P1_4</TD><TD>LN_TREAT_P1_1</TD><TD>LN_TREAT_P1_2</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE><TBODY><TR><TD>LN_TREAT_P1_3</TD><TD>LN_TREAT_P1_4</TD><TD>LN_LENGTH_P1_1</TD><TD>LN_LENGTH_P1_2</TD><TD>LN_LENGTH_P1_3</TD><TD>LN_LENGTH_P1_4</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P><BR />LN_LOC variables have 6 choices (1 - 6).</P><P>LN_TREAT variables have 4 choices (1 - 4).</P><P>&nbsp;</P><P>LN_LENGTH variables represent dimensions.</P><P>&nbsp;</P><P>From this data set, I just need the LENGTHS of OBSERVATIONS&nbsp;with LN_LOC = 6 AND LN_TREAT = 4.</P><P>&nbsp;</P><P>Thank you for your help.</P><P>&nbsp;</P> Wed, 26 Sep 2018 01:00:36 GMT https://communities.sas.com/t5/SAS-Programming/Data-Cleaning/m-p/498901#M132662 yoyong 2018-09-26T01:00:36Z https://communities.sas.com/t5/SAS-Programming/Data-Cleaning/m-p/498925#M132676 <P>1. Many people (including myself) will NOT download Microsoft files.</P> <P>Please provide your data as part of your post:</P> <P><A href="https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712" target="_blank">How to convert datasets to data steps</A><BR /><A href="https://communities.sas.com/t5/help/faqpage/faq-category-id/posting#posting" target="_blank">How to post code</A></P> <P>&nbsp;</P> <P>2. Please also provide the expected output.</P> <P>&nbsp;</P> Wed, 26 Sep 2018 02:41:59 GMT https://communities.sas.com/t5/SAS-Programming/Data-Cleaning/m-p/498925#M132676 ChrisNZ 2018-09-26T02:41:59Z