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

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

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
  • 1187 views
  • 0 likes
  • 4 in conversation