BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
carlykuehl
Calcite | Level 5

Hello, 

I am trying to put a format on a variable. When I do it it does not show an error or a warning but this is in my log. I am not sure where I set this format, but it does not seem to mess up my data at all or my results. 

 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User

Please do not post code, logs or data in pictures. Just copy/paste the log text into a window opened with the </> button.

Since you try to assign a custom format to your variable, you have to define/create that format first.

View solution in original post

3 REPLIES 3
Kurt_Bremser
Super User

Please do not post code, logs or data in pictures. Just copy/paste the log text into a window opened with the </> button.

Since you try to assign a custom format to your variable, you have to define/create that format first.

ballardw
Super User

Or if you created the format in a location other than the WORK.Formats catalog you need to set the system option FMTSEARCH to include the location in the search path.

NikitaTovey
Fluorite | Level 6

Try adding this code to the beginning of your program:
OPTIONS FMTSEARCH = (Tabulations.Formats WORK LIBRARY)
NOFMTERR;

sas-innovate-white.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.

 

Early bird rate extended! Save $200 when you sign up by March 31.

Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1117 views
  • 0 likes
  • 4 in conversation