Data Cleaning

[yoyong]

Hi everyone.

I need help with data cleaning.

I have attached a sample data set with the following variables:

OBS

LN_LOC_P1_1

LN_LOC_P1_2

LN_LOC_P1_3

LN_LOC_P1_4

LN_TREAT_P1_1

LN_TREAT_P1_2

LN_TREAT_P1_3

LN_TREAT_P1_4

LN_LENGTH_P1_1

LN_LENGTH_P1_2

LN_LENGTH_P1_3

LN_LENGTH_P1_4

LN_LOC variables have 6 choices (1 - 6).

LN_TREAT variables have 4 choices (1 - 4).

LN_LENGTH variables represent dimensions.

From this data set, I just need the LENGTHS of OBSERVATIONS with LN_LOC = 6 AND LN_TREAT = 4.

Thank you for your help.

[ChrisNZ]

1. Many people (including myself) will NOT download Microsoft files.

Please provide your data as part of your post:

How to convert datasets to data steps
How to post code

2. Please also provide the expected output.