Re: Create a Macro Variable to Export Files

ChaoticSweets · Posted 05-06-2021 05:22 PM

i resolved this sorry

ChaoticSweets · Posted 05-06-2021 05:29 PM

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 · Posted 05-06-2021 05:46 PM

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 · Posted 05-06-2021 05:55 PM

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

ChaoticSweets · Posted 05-07-2021 02:55 AM

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 · Posted 05-07-2021 03:27 AM

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

self-resolved