Some ideas on making a table in STATA17

[Eddie Brighton]

Dear Statalist,

I'm trying to make a table that looks something like this:

		year
Agency	Type of job	2017	...	2022
DD	STEM jobs	# (%)
	Total number of jobs	# (100%)
AG	STEM jobs
	Total number of jobs
...	...	...	...	...

I'd like to show the 6-year trend of agencies' (agy) number of STEM jobs posted by agency-year (stem_number_yearagy) along with the total number of jobs posted by agency-year (number_y).
Anyone have an idea how to make this table without manually formatting in excel?

Here's how my data looks like:

* Example generated by -dataex-. For more info, type help dataex
clear
input int year str2 agy float(number_y stem_number_yearagy)
2018 "DD" 111807 21971
2018 "VA"  64695  4397
2018 "DD"  22842  4695
2018 "VA"  64695  4397
2018 "DD" 111807 21971
2018 "DD" 111807 21971
2018 "DD" 111807 21971
2018 "VA"  64695  4397
2018 "VA"  64695  4397
2018 "HE"   7466  1453
2018 "DD" 111807 21971
2018 "DD" 111807 21971
2018 "DD" 111807 21971
2018 "DD" 111807 21971
2018 "VA"  64695  4397
2018 "HE"   7466  1453
2018 "OM"    424    32
2018 "VA"  64695  4397
2018 "DD" 111807 21971
2018 "DD" 111807 21971
2018 "VA"  64695  4397
2018 "HE"   7466  1453
2018 "DD"  22842  4695
2018 "VA"  64695  4397
2018 "DD" 111807 21971
2018 "VA"   7147   466
2018 "VA"  64695  4397
2018 "DD" 111807 21971
2018 "DD"  22842  4695
2018 "DD" 111807 21971
2018 "DD" 111807 21971
2018 "VA"   7147   466
2018 "DD"  22842  4695
2018 "DD"  22842  4695
2018 "DD" 111807 21971
2018 "VA"  64695  4397
2018 "VA"  64695  4397
2018 "DD" 111807 21971
2018 "DD"  22842  4695
2018 "DD"  22842  4695
2018 "DD" 111807 21971
2018 "DD" 111807 21971
2018 "IN"   5487  1107
2018 "DD" 111807 21971
2018 "VA"  64695  4397
2018 "VA"  64695  4397
2018 "VA"  64695  4397
2018 "DD" 111807 21971
2018 "IN"   1186   140
2018 "VA"  64695  4397
2018 "VA"  64695  4397
2018 "VA"  64695  4397
2018 "DD"  22842  4695
2018 "DD" 111807 21971
2018 "DD"  22842  4695
2018 "DD" 111807 21971
2018 "VA"  64695  4397
2018 "HE"   7466  1453
2018 "DD"  22842  4695
2018 "DD" 111807 21971
2018 "DD" 111807 21971
2018 "DD" 111807 21971
2018 "DD" 111807 21971
2018 "DD" 111807 21971
2018 "DD" 111807 21971
2018 "DD" 111807 21971
2018 "DD" 111807 21971
2018 "DD"  22842  4695
2018 "DD" 111807 21971
2018 "DD" 111807 21971
2018 "DD" 111807 21971
2018 "DD" 111807 21971
2018 "VA"  64695  4397
2018 "VA"  64695  4397
2018 "DD"  22842  4695
2018 "DD" 111807 21971
2018 "VA"  64695  4397
2018 "DD" 111807 21971
2018 "DD" 111807 21971
2018 "DJ"   2917   313
2018 "DD"  22842  4695
2018 "HS"   6548   591
2018 "DD" 111807 21971
2018 "DD" 111807 21971
2018 "VA"  64695  4397
2018 "DD"  22842  4695
2018 "VA"  64695  4397
2018 "DD"  22842  4695
2018 "VA"  64695  4397
2018 "VA"   7147   466
2018 "HE"    925   166
2018 "DD" 111807 21971
2018 "DD"  22842  4695
2018 "VA"  64695  4397
2018 "VA"  64695  4397
2018 "DD" 111807 21971
2018 "DD" 111807 21971
2018 "DD" 111807 21971
2018 "IN"   5487  1107
2018 "VA"  64695  4397
end

Thanks.

[George Ford]

  https://www.youtube.com/watch?v=ug0LihyIzvM

[Eddie Brighton]

Thanks, George.