Hi there,
I have imported some data into SAS and I need to change the setup in one of the variables. The variable data is called discharge_date and for those that have a double hyphen -- I need to put no, and those you have a date to say yes. There are more double hyphens then dates. Would this be an if/else statement? I am very new to SAS I don't know what I am doing half the time. It is a character and the informat and format is $9. Please help I am stumped.
My example:
DISCHARGE_DATE
--
--
--
--
22-Nov-16
22-Nov-16
22-Nov-16
22-Nov-16
22-Nov-16
--
--
--
--
--
3-Sep-15
3-Sep-15
3-Sep-15
3-Sep-15
--
--
--
--
--
Hi, yes an if/else will do if you are sure not going to use discharge_date for later analysis. If not, you are better to code them as a date variable. Otherwise the code is a follow:
* set new var to No if discharge_date is a character and strictly coded as double hyphen:
* else set to Yes;
if discharge_date eq "--" then new_var="No"; else new_var="Yes";
Hi, yes an if/else will do if you are sure not going to use discharge_date for later analysis. If not, you are better to code them as a date variable. Otherwise the code is a follow:
* set new var to No if discharge_date is a character and strictly coded as double hyphen:
* else set to Yes;
if discharge_date eq "--" then new_var="No"; else new_var="Yes";
Thank you so much! It worked!
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.