BookmarkSubscribeRSS Feed
QLi
Fluorite | Level 6 QLi
Fluorite | Level 6

To get the order  in the report table, I defined the format with option NOTSORTED.

proc format library=fmt.catalog fmtlib ;

value $Cov_fmt (notsorted)

'$0'='$0'

'$50'= '$50'

'$75'='$75'

'$100'= '$100'

'$200'= '$200'

'$250' ='$250'

'$500' ='$500'

'$1,000' ='$1,000'

'$30/day ($900 max)'='$30/day ($900 max)'

'$40/day ($1,200 max)'='$40/day ($1,200 max)'

'$50/day ($1,500 max)'='$50/day ($1,500 max)'

'$900 max'='$900 max'

'$1,500 max'='$1,500 max'

'$2,000' ='$2,000'

'$2,500' ='$2,500'

'$5,000'='$5,000'

'$10,000'= '$10,000'

'$12,000' ='$12,000'

'$20,000' ='$20,000'

'$25,000'= '$25,000'

'$30,000' ='$30,000'

'$40,000' ='$40,000'

'$50,000' ='$50,000'

'$60,000' ='$60,000'

'$75,000' ='$75,000'

'$100,000' ='$100,000'

'$250,000' ='$250,000'

'$300,000' ='$300,000'

'$100/week'='$100/week'

'$10,000 | $0 Deductible'='$10,000 | $0 Deductible'

'$10,000 | $250 Deductible'='$10,000 | $250 Deductible'

'$10,000 | $500 Deductible'='$10,000 | $500 Deductible'

'$10,000 | $1,000 Deductible'='$10,000 | $1,000 Deductible'

'$50,000/$100,000'='$50,000/$100,000'

'$100,000/$300,000'='$100,000/$300,000'

'$250,000/$500,000'='$250,000/$500,000'

'$300,000/$300,000'='$300,000/$300,000'

'$500,000/$500,000'='$500,000/$500,000'

'100% Medical Coverage Only'='100% Medical Coverage Only'

'100% Medical Coverage | 80% Income Replacement'='100% Medical Coverage | 80% Income Replacement'

'80% Medical Coverage Only'='80% Medical Coverage Only'

'80% Medical Coverage | 60% Income Replacement'='80% Medical Coverage | 60% Income Replacement'

'Added On#$50,000/$100,000'='Added On#$50,000/$100,000'

'Added On#$100,000/$300,000'='Added On#$100,000/$300,000'

'Added On#$250,000/$500,000'='Added On#$250,000/$500,000'

'Added On#$300,000/$300,000'='Added On#$300,000/$300,000'

'Added On#$500,000/$500,000'='Added On#$500,000/$500,000'

'Added On#$25,000'='Added On#$25,000'

'Added On#$50,000'='Added On#$50,000'

'Added On#$100,000'='Added On#$100,000'

'Added On#$200,000'='Added On#$200,000'

'Added On#Decline'='Added On#Decline'

'Decline'='Decline'

'No'='No'

'Yes'='Yes'

'Nonstacked'='Nonstacked'

'Stacked'='Stacked'

'Reduced By#$50,000/$100,000'='Reduced By#$50,000/$100,000'

'Reduced By#$100,000/$300,000'='Reduced By#$100,000/$300,000'

'Reduced By#$250,000/$500,000'='Reduced By#$250,000/$500,000'

'Reduced By#$25,000'='Reduced By#$25,000'

'Reduced By#$50,000'='Reduced By#$50,000'

'Reduced By#$100,000'='Reduced By#$100,000'

'Reduced By#Decline'='Reduced By#Decline' ;

run;

When I used it in the Proc Tabulate, it showed Warning" Cann't Preloaded "

        proc tabulate data = Reqtd_Cov order = data   ;

            class requested_limit /preloadfmt;

            class coverage_code state ;

             format requested_limit $Cov_fmt.;         

        table (coverage_code='' )* (requested_limit=''  ) all, state=''*n=''*f=comma6.0 ;* all*f=comma6.0;                  run ;

Could you help me check it whether or not I missed something?

Thanks in advance.

2 REPLIES 2
Doc_Duke
Rhodochrosite | Level 12

Your typed warning message appears to have one or more typos.  Can you show the exact message that was in the SAS log.  Then you can search support.sas.com for something relevant.

Reeza
Super User

SASDocs:

Requirement:PRELOADFMT has no effect unless you specify EXCLUSIVE, ORDER=DATA, or PRINTMISS and you assign formats to the class variables.

Note:   If you specify PRELOADFMT without also specifying EXCLUSIVE, ORDER=DATA, or PRINTMISS, then SAS writes a warning message to the SAS log.

I don't see any of those specified in your code so you probably need to decide which option is best for your data and go from there is my guess.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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
  • 2 replies
  • 978 views
  • 6 likes
  • 3 in conversation