BookmarkSubscribeRSS Feed
Ronein
Meteorite | Level 14

Hello

What is the purpose of writing "default=20" in this example of multilabel format?

 

What is the purpose of writing "notsorted"?

 

If I want that order of rows in summary report will be in same order as left side of proc format

('Strong approval','Weak Approval','Approval','Weak Decline','Strong Decline','Decline') then should I add the option "notsorted"?

 

proc format library=work;
value appr (default=20 multilabel notsorted)
1-2  = 'Strong approval'
3-6  = 'Weak Approval'
1-6  = 'Approval'
7-8  = 'Weak Decline'
9-10 = 'Strong Decline'
7-10 = 'Decline'
;
run;
3 REPLIES 3
PaigeMiller
Diamond | Level 26

This is the exact situation, when you want to know what a certain option does, where you should consult the documentation. SAS has done a great job of explaining every command and every option. Here is the PROC FORMAT documentation: https://documentation.sas.com/?docsetId=proc&docsetVersion=9.4&docsetTarget=p1upn25lbfo6mkn1wncu4dyh...

--
Paige Miller
Ronein
Meteorite | Level 14
Thank you.
What is the logic that in this example they
Choose default=20 and not default =30?
PaigeMiller
Diamond | Level 26

Because 20 is sufficient in this example

 

 
--
Paige Miller

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 454 views
  • 0 likes
  • 2 in conversation