You can't use the JSON libname engine to read just part of a JSON file. JSON format uses nested constructs, so the entire file must be processed to ensure the integrity of the data.
However, once the data is accessible in the SAS library, you can use PROC SQL or DATA step to subset the fields/tables to keep just what you need for your reports/analysis.
... View more