self-resolved

[ChaoticSweets]

i resolved this sorry 

[ChaoticSweets]

To make the last part more clear, i ran it again to double check.
I confirm I get an error that the Physical File does not exist and then the attempted path to the file.
Other times i get:
ERROR: Export unsuccessful. See SAS Log for details.
Which still leaves me confused.

[Reeza]

Well you deleted the question so not sure if any of this is valid but I think you're not supposed to assign PG1 to the same path, that should be your input path. The path you were creating was for output files.

[SASKiwi]

@ChaoticSweets  - Please don't remove your initial post. If you want to resolve your problem just mark your post as answered by you.

[ChaoticSweets]

oh my im sorry! i couldnt delete the post, so i didnt know what to do
because i found the issue directly after. With the macro variable libname
statement i removed the quotation marks and that essentially allowed me to
see my tables under output.

[SASKiwi]

@ChaoticSweets  - That's OK. Just remember we are all learners together. It's just that some of us know a bit more than others 😀