topic Re: create a parameter of a date value in SAS Programming

create a parameter of a date value

Ronein — Mon, 16 Apr 2018 10:32:19 GMT

Hello

I am trying to create a parameter of a date value and use it to take all rows with date higher than 01Apr2017.

Can anyone please explain why it is not working and what is the correct code?

Thanks a lot

data aaa;
length LOC_ID $8 Date Demand 8;
LOC_ID = "C1";
demand = 0;
do Date = '01JAN2017'd to '30JUN2017'd;
output;
end;
run;

Re: create a parameter of a date value

Ronein — Mon, 16 Apr 2018 10:33:04 GMT

sorry.Here is the code.Why is it no working?

data aaa;
length LOC_ID $8 Date Demand 8;
LOC_ID = "C1";
demand = 0;
do Date = '01JAN2017'd to '30JUN2017'd;
output;
end;
run;

data bbb;
set aaa;
format Date date9.;
run;

%let monParam='01Apr2017'd;
Data Want;
SET bbb;
IF Date>&monParam.;
Run;

Re: create a parameter of a date value

PeterClemmensen — Mon, 16 Apr 2018 10:35:07 GMT

I get no errors from running the code.

Please post your log and what yoy consider "not working".

Re: create a parameter of a date value

PeterClemmensen — Mon, 16 Apr 2018 10:37:58 GMT

Also, your second data step is redundant. Simple use the FORMAT Statement in your first data step.

Re: create a parameter of a date value

RW9 — Mon, 16 Apr 2018 10:39:58 GMT

Please define "not working". After tidying up your code and dropping the unnecessary datastep the code works perfectly:

data aaa;
  length loc_id $8 date demand 8;
  loc_id="C1";
  demand=0;
  do date='01JAN2017'd to '30JUN2017'd;
    output;
  end;
  format date date9.;
run;

%let monparam='01Apr2017'd;
data want;
  set aaa;
  if date > &monParam.;
run;

Re: create a parameter of a date value

Ronein — Mon, 16 Apr 2018 10:47:41 GMT

Sorry.You are right. I run it again and it is working.Thank you anyway