Hi All,
Could anybody please help me to solve these errors. This query was running properly without an error but don't why it has started giving errors.
The log and query is attached.
Regards
Anand
Hi,
Well I had a quick glance at those files, however I don't have time to debug all that. It could be any number of things i.e. change in database (you are connecting to database) - password expired, user accounts etc. It could be access to the area your working on access rights, maybe some data is missing somewhere along the line etc. As mentioned numerous possible issues, and you are the only one with access to all the parts.
I would recommend going through each individual part, i.e. stepping through the code taking it out of macros if necessary, to identify exactly which part is not working. Once you identify what part is not working, assess what inputs there are, for instance if it is the step with the database, then check through other methods that you can access and extract the data. If you find you can't access the data then check with your DB guys, if you can then check you have SAS/Access installed. Etc.
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 25. 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.