HI PGStats Thanks for that! Very helpful! Playing around with the code I would like to embed instead of the random values some values from another table in correspondence to the dates. This is what I tried data test;
set PART2;
do sesdate_DATE = '01JAN2018'd to '31DEC2018'd;
if weekday(sesdate_DATE) in (1, 7) then call missing(enratt);
else value = enratt;
month = intnx("month", sesdate_DATE, 0);
day = day(sesdate_DATE);
output;
end;
format month mmyys7.;
run; With "enratt" being the name of the column with the actual values and sesdate_DATE actual dates. The problem with the above is that I receive lots of 0s and . instead of the actual values from the table called Part2 in the Value column. Any tips? Many thanks
... View more