In SAS DI, for some transformation you will see work table represented by a green rectangular box. Is it possible to create the work table just like registered table? so instead of seeing rectangular box as work table, I want to see physical table feature for work table.
Not 100% sure what you want, but I think you want to right click on the green square and chose Register Table...?
You want it to reside in the work....why?
Since the table is avaible only in that job, I can't see any reason for registering it into metadata...?
But you can create a metadata libref for WORK, and register your table there. Not best practice, but possible.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.