Possible? yes, good? Not so sure. This since you will dynamically create new columns. Perhaps if you create an end user table which is not be consumed using meta data registration directly. Look for the Transpose (!) transformation.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.