@stacy_not_robot wrote:
I have a column of data(visited_store) which have a mix of numeric, character and missing values.
Example: "Yes", "No", 99,100, .
I would like to create another column, and assign Yes to 1 and all other values to 0.
I tried the following code:
data clean_data; set original_data;
if visited_store in ( . , 99, 999, 9999) then visited_store_clean = 0;
if visited_store = "No" then visited_store_clean = 0;
if visited_store = "Yes" then visited_store_clean = 1;
RUN;
Does not seem to work.
Any help on how i can select rows with "No", missing value ( . ) and numeric values to 0, while "Yes" to 1?
Doesn't work is awful vague. Are there errors in the log?: Post the code and log in a code box opened with the <> to maintain formatting of error messages. No output? Post any log in a code box. Unexpected output? Provide input data in the form of data step code pasted into a code box, the actual results and the expected results. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the <> icon or attached as text to show exactly what you have and that we can test code against.
... View more