Desktop productivity for business analysts and programmers

Proc SQL

Reply
Contributor
Posts: 22

Proc SQL

Hi -

I have a lot of code that I migrated from SQL to SAS.  When I first migrated it, it ran fine.  However, now it will not work and nothing major was changed.  I have attached the code and a copy of the error messages I am getting in the log, can someone please take a look at this and let me know what to do?  This is driving me crazy!

Thanks!

John


Error Log.jpg
Attachment
Super User
Posts: 5,378

Re: Proc SQL

Quite some code youä'va attached...

It would been helpful to get the SAS log instead of the status window.

"Nothing major has changed". Thing is with IT stuff, computers doesn't really distinguish between minor or major changes, if it doesn't work, it doesn't... So, what minor changes are there?

Data never sleeps
Contributor
Posts: 22

Re: Proc SQL

Hi Linus -

I think I have got it to work!  It was a bad alias in the code......it is running now.

Contributor
Posts: 22

Re: Proc SQL

WOOHOOO.....

it did work......

Ask a Question
Discussion stats
  • 3 replies
  • 263 views
  • 1 like
  • 2 in conversation