Data Prep Sheet

Action Principale : globalReconcile

Preparation Code

Script awaiting validation
Copied!
1DATA mycas.forecasts;
2 LENGTH date 8 region $10 product $10 actual predict error 8;
3 FORMAT date date9.;
4 DO date = '01JAN2023'd to '31DEC2023'd;
5 DO region = 'East', 'West';
6 DO product = 'A', 'B', 'Total';
7 actual = rand('Normal', 100, 10);
8 predict = actual + rand('Normal', 0, 5);
9 error = actual - predict;
10 OUTPUT;
11 END;
12 END;
13 END;
14RUN;
Actions using this script
  • tsReconcile globalReconcile En cours
  • No other action uses this exact script.