Where to convert variable when want to filter dates

[jeremy4]

Hi,

I am looking to convert a character variable (YEAR_MONTH) to a numeric variable, which has been written in the code below. Please can someone change the line of code so that the dataset converts the variable and filter my dataset so that only observations are kept when the newly converted YEAR_MONTH numeric variable is less than or equal to 30 June 2018? Would it be possible to do this in one DATA step, or does it have to be done in two datasets (convert variable in first DATA step and then subset dataset in second DATA step)?

Code:

Where to include?

YEAR_MONTH = input(YEAR_MONTH,6.);

data test;
   set test2;
   if YEAR_MONTH le '30Jun2018'd;
run;

[PaigeMiller]

---

@jeremy4 wrote:

I am looking to convert a character variable (YEAR_MONTH) to a numeric variable,

---

Is that 2018_06 (for example) or 201806?

If the latter, then

data test;
   set test2;
   ym=input(year_month,yymmn6.);
   if ym le '30Jun2018'd;
run;

[yabwon · Accepted solution]

Why not to use WHERE clause?

data test;
   set test2;
   where input(year_month,yymmn6.) le '30Jun2018'd;
run;

All the best

Bart