topic Re: Creating dummy data to show on report with no data in SAS Programming

Creating dummy data to show on report with no data

Stalk — Wed, 17 Feb 2021 01:18:08 GMT

How can I create date as well as unit for all the combinations. What's wrong with this code?

Data dummy;
date="&start."d;
do while (date<="&enddt."d);

output;
date=intnx('day', date, 1, 's');
end;
format date date9.;
array unit[3] $ '45' '55' '65';
do i=1 to 3;
unit = unit[i];
end;

Re: Creating dummy data to show on report with no data

ChrisNZ — Wed, 17 Feb 2021 01:24:54 GMT

> What's wrong with this code?

Its formatting for sure.

Also we don't know what result you expect. the second loop does nothing as no output statement is provided.

I suppose you might want to put the second loop inside the first one maybe?

data DUMMY;
  array UNITS[3] $ '45' '55' '65';
  do DATE="&startdt"d to "&enddt"d;
    do I=1 to dim(UNITS);
      UNIT= UNITS[I];
      output;
    end;
  end;
  format DATE date9.;
run;

Re: Creating dummy data to show on report with no data

Stalk — Wed, 17 Feb 2021 02:52:45 GMT

Thank you. It worked with parenthesis

data DUMMY; array UNITS[3] $ ('45' '55' '65'); do DATE="&startdt"d to "&enddt"d; do I=1 to dim(UNITS); UNIT= UNITS[I]; output; end; end; format DATE date9.; run;