BookmarkSubscribeRSS Feed
adent
Calcite | Level 5

I am trying to add formats to existing variables and I keep getting this error. Can anyone let me know why this is?

 

 

ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,
a datetime constant, a missing value, ;, (, LOW, OTHER.
ERROR 76-322: Syntax error, statement will be ignored.

 

1 REPLY 1
Tom
Super User Tom
Super User

SAS does a good job of pointing you at the problem.

1     proc format library= work.User_Formatsexam;
2
3     value Trial Type
                  ----
                  22
                  76
ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant,
              a missing value, ;, (, LOW, OTHER.
ERROR 76-322: Syntax error, statement will be ignored.
4     S='Single'
5     M= 'Mixed'
6     P= 'Parallel';
NOTE: The previous statement has been deleted.
7
8     run;

Pick a single name for the format.

Are you trying to define a format named TRIAL or one named TYPE?

 

Once you fix that you also need to add a $ to the front of the name to let PROC FORMAT know that you want to create CHARACTER format and not a NUMERIC format.

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
  • 1 reply
  • 519 views
  • 2 likes
  • 2 in conversation