topic Where to convert variable when want to filter dates in SAS Programming

Where to convert variable when want to filter dates

jeremy4 — Tue, 01 Oct 2019 10:13:09 GMT

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;

Re: Where to convert variable when want to filter dates

PaigeMiller — Tue, 01 Oct 2019 11:02:22 GMT

@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;

Re: Where to convert variable when want to filter dates

yabwon — Tue, 01 Oct 2019 11:15:54 GMT

Why not to use WHERE clause?

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

All the best

Bart