Data Prep Sheet

Action Principale : catTrans

Preparation Code

Script awaiting validation
Copied!
1DATA casuser.sales_data;
2 INFILE DATALINES dlm=',';
3 INPUT CustomerID $ Product $ Region $ Purchased SaleCount SaleValue;
4 DATALINES;
5101,Laptop,East,1,1,1200
6102,Mouse,West,0,2,50
7103,Keyboard,West,1,1,75
8104,Laptop,East,0,1,1150
9105,Monitor,North,1,1,300
10106,Mouse,South,0,3,75
11107,Laptop,West,1,1,1300
12108,Webcam,East,0,5,250
13109,Monitor,South,1,2,600
14110,Keyboard,North,0,1,80
15111,Laptop,East,1,1,1250
16112,Mouse,West,1,1,25
17113,Headphones,South,0,4,300
18114,Laptop,North,1,1,1400
19115,Monitor,West,0,1,280
20116,Webcam,East,1,2,100
21117,Mouse,North,0,1,20
22118,Keyboard,South,1,1,90
23119,Laptop,West,0,1,1100
24120,Docking Station,East,1,1,150
25;
26RUN;
Actions using this script
  • dataPreprocess catTrans En cours
  • No other action uses this exact script.