hello all, i'm new to using sas EG program. im searching for a solution to export/generate below data into multiple separate excel file depending on type (Car.xls, bus.xls bike.xls) separate file. can anyone suggest best approach it achevie the result. Input data Type month cost Car 01-01-2019 1000 Car 01-02-2019 2000 Car 01-03-2019 2000 Car 01-04-2019 2000 Car 01-05-2019 4000 Car 01-06-2019 2000 Car 01-07-2019 2000 Car 01-08-2019 6000 Car 01-09-2019 2000 Car 01-10-2019 7000 Car 01-11-2019 2000 Car 01-12-2019 2600 bike 01-01-2019 5000 bike 01-02-2019 5000 bike 01-03-2019 5000 bike 01-04-2019 5000 bike 01-05-2019 6333 bike 01-06-2019 5777 bike 01-07-2019 3000 bike 01-08-2019 2354 bike 01-09-2019 4300 bike 01-10-2019 5000 bike 01-11-2019 1222 bike 01-12-2019 9000 bus 01-01-2019 5000 bus 01-02-2019 5000 bus 01-03-2019 5000 bus 01-04-2019 5000 bus 01-05-2019 5000 bus 01-06-2019 5000 bus 01-07-2019 3000 bus 01-08-2019 4000 bus 01-09-2019 8000 bus 01-10-2019 2000 bus 01-11-2019 5000 bus 01-12-2019 5000 truck 01-01-2019 5000 truck 01-02-2019 5000 truck 01-03-2019 5000 truck 01-04-2019 5000 truck 01-05-2019 3000 truck 01-06-2019 2900 truck 01-07-2019 2900 truck 01-08-2019 2900 truck 01-09-2019 3999 truck 01-10-2019 4000 truck 01-11-2019 2000 truck 01-12-2019 4000 Output file sample separate file car excel file Type month cost Car 01-01-2019 1000 Car 01-02-2019 2000 Car 01-03-2019 2000 Car 01-04-2019 2000 Car 01-05-2019 4000 Car 01-06-2019 2000 Car 01-07-2019 2000 Car 01-08-2019 6000 Car 01-09-2019 2000 Car 01-10-2019 7000 Car 01-11-2019 2000 Car 01-12-2019 2600 bus excel file bus 01-01-2019 5000 bus 01-02-2019 5000 bus 01-03-2019 5000 bus 01-04-2019 5000 bus 01-05-2019 5000 bus 01-06-2019 5000 bus 01-07-2019 3000 bus 01-08-2019 4000 bus 01-09-2019 8000 bus 01-10-2019 2000 bus 01-11-2019 5000 bus 01-12-2019 5000
... View more
