Efficiency Analysis: Run analysis by region and year

[RobPratt]

That error message means that you have not started a CAS session.  You will also need to convert the SAS data sets to CAS tables, as shown in the three DATA steps I provided.

For a successful run, the resulting efficiency_data table will have two extra columns for the BY variables (year and region):

Obs	garage_name	year	region	staff	showroom	alpha_sales	beta_sales	profit	garage
1	Winchest	2020	A	7	8.0	10	12	8.5	1
2	Andover	2020	A	6	6.0	20	30	9.0	2
3	Basingst	2020	B	2	3.0	40	40	2.0	3
4	Poole	2020	B	14	9.0	20	25	10.0	4
5	Winchest	2021	A	10	9.0	10	10	11.0	5
6	Andover	2021	A	24	15.0	15	13	25.0	6
7	Basingst	2021	B	6	7.0	50	40	8.5	7
8	Poole	2021	B	8	7.5	5	8	9.0	8

[shawnchen0321]

I got it. After I searched the related info, I found that unfortunately my school didn't provide the SAS Viya software. Thus, that's reason I can't connect to the server.

Thank you for your generous help.