I found that when I turned on the option to manually select careers for non-control sims in StoryProgression Career, some skill careers and active careers were not in the form (such as nectar, singer, etc.). How should I set this up? I made sure to have self-employment turned on in the menu.

I think these special careers need to be assigned manually, are not standard careers, they are designed for active sims I guess.
Because inactive sims cannot do the career related opportunities, only actively played sims, means you