BookmarkSubscribeRSS Feed
VALLY
Fluorite | Level 6

am running the below code, however am getting this error message on the log..

%INCLUDE "&PATH./TRANSFORM_BRACC_CARD.sas";

Log:

ERROR 73-322: Expecting an ON.

ERROR 200-322: The symbol is not recognized and will be ignored.

 

8 REPLIES 8
maguiremq
SAS Super FREQ
You need to examine the original program that you're submitting with the %INCLUDE statement. It seems as though a PROC SQL query within that script doesn't have a JOIN condition. I would search the script for any PROC SQL queries, and look for those missing an ON or a WHERE statement that joins the two or more tables together.
PaigeMiller
Diamond | Level 26

Show us the entire log, please, in order, with nothing chopped out. It doesn't help us to see the ERROR message separated from the code that caused the ERROR as you have provided it.


Please format the log properly, so we can read it effectively. To do this, copy the log as text and paste it into the window that appears when you click on the </> icon — do not skip this step or we will just ask again for properly formatted log.

--
Paige Miller
Reeza
Super User
Run it with the SOURCE2 option so the log indicates the error in the correct place and post only the code up to the first set of errors.
PaigeMiller
Diamond | Level 26

Please follow @Reeza's advice and use 

 

%INCLUDE "&PATH./TRANSFORM_BRACC_CARD.sas" /SOURCE2;

and then show us the properly formatted log, as requested earlier: "Please format the log properly, so we can read it effectively. To do this, copy the log as text and paste it into the window that appears when you click on the </> icon — do not skip this step or we will just ask again for properly formatted log."

 

 

--
Paige Miller
Reeza
Super User

Are you sure you should be sharing this information publicly????


VALLY
Fluorite | Level 6
No, can you please delete this post, please
Reeza
Super User
I cannot delete your post - it's too much text and my browser keeps freezing. You should be able to click the three dots beside your previous post and delete it.
The answer is still the same anyways, add source2 run the full code and post up to the error in the log, hiding any proprietary information as needed. In general, never a good idea to dump your full log and code as you've done here. No offense, but very few people are going to slog through a log that size on a user supported forum.
If you need help still, I would advise you to work with SAS Tech Support instead.
Reeza
Super User

FYI - I've formatted your question. Please use the code blocks for code, not spoilers unless your code is really long and do not nest spoilers.

You need to show the actual code. You can add the SOURCE2 option in the %INCLUDE so that the full log is generated to help with debugging.

%INCLUDE "&PATH./TRANSFORM_BRACC_CARD.sas" /SOURCE2;



Doc reference:
https://documentation.sas.com/doc/en/vdmmlcdc/1.0/lestmtsref/p1s3uhhqtscz2sn1otiatbovfn1t.htm

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 8 replies
  • 947 views
  • 0 likes
  • 4 in conversation