Variable creation

Reply
N/A
Posts: 1

Variable creation

Hi all,

I'm creating a new variable and not quite sure how to tackle it.

Essentially, this is what I want to do:

Data new_dataset;

Set old_dataset;

If confine_date between start_date and end_date then match = 'yes' else match = 'no';

Run;

The problem is that the dates aren't fixed. Any help/direction would be appreciated.

Thanks.

Super User
Posts: 9,875

Re: Variable creation

You mixed up IF and WHERE statement.

If start_date <= confine_date  <= end_date then match = 'yes' else match = 'no';

Contributor
Posts: 65

Re: Variable creation

place a semicolon before else in Xia code

If start_date <= confine_date  <= end_date then match = 'yes';

else match = 'no';

Ask a Question
Discussion stats
  • 2 replies
  • 148 views
  • 1 like
  • 3 in conversation