If both aren't working is your library assigned at the moment and can you access it?
Did it work before, I was under the impression that my code was working previously, minus the data export portion. If that was true you have an issue with your system.
@Nancy05 wrote:
Yes. It did work before. Our test environment had a clean-up last night. All datasets I am interested disappeared.
Ok. So its your system and we can't help you with that.
You'll need to figure out how to get your library and datasets back. That sucks.
The code will work otherwise.
Look at your proc export code.
proc export data=sashelp.vtable (where=(libname="ELTML" and upper(memname) like "MLT%"))
1. Why are you exporting that specific datasets? What's in that table?
2. What is your where clause filtering?
@Reeza: I did notice that there is logic error in
proc export data=sashelp.vtable (where=(libname="ELTML" and upper(memname) like "MLT%"))
@ChrisNZ version no syntax error, but logic error.
Your version make sense to me, but I keep getting error message.
By the way, I do read log message everytime after run. I can't see the value after running put str3;
All I can see is
@Nancy05 The logic error is that you're referencing the wrong table with the wrong WHERE clause. Review the code from my initial solution and notice what is in the Data= and Where clauses. Or Chris's solution.
The SASHELP.VTABLE is a table that contains information on all the tables in your SAS System. It can be used, for example, to identify all the tables in a specific library that start with a specified prefix. However, that information isn't what you want to export. You want to export the actual tables.
You are really difficult to help Nancy. Please follow the instructions.
Mine are:
1-The code you should use is in message #19.
2-You are not using it afaics. Why?
3-If it fails please post full code and log.
Or follow Reeza's instructions.
If you do not do this, no one will bother replying much longer.
You should be doing most of the work, not us. Please try harder.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: