BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
twildone
Pyrite | Level 9

Hi...I am trying to right justify the results in the table and I keep getting the results as left justified on the table. I only want the levels for the Status to be left justified. Any suggestions....Thanks,

 

 

proc tabulate data = List110;

    var StudentUID;
	class "Academic Year"n / style=[bordercolor=black borderwidth=0.5] order=unformatted missing;
	class Success /	style=[bordercolor=black borderwidth=0.5] order=unformatted missing;
	class "Registered Status"n / style=[bordercolor=black borderwidth=0.5] order=unformatted missing;
	class Status / style=[bordercolor=black borderwidth=0.5] order=unformatted missing;
    classlev Status / style=[just=L vjust=C bordercolor=black borderwidth=0.5 background=$sttsfmt.]; 
    classlev "Registered Status"n / style=<parent>; 
    classlev "Academic Year"n / style=[bordercolor=black borderwidth=0.5 background=CXAEADD9];
    classlev Success / style=[bordercolor=black borderwidth=0.5 background=CXAEADD9];

   table (Status=' ' * ("Registered Status"n=' ' all = 'Total' ) all={label='Grand Total' style=[bordercolor=black borderwidth=0.5 background=CXD3ADD9]}) * [style=<parent>] , 
        "Academic Year"n='' * Success='' * PCTN<Success>=''*f=mypct. / row=float box=[label=' ' style=[background=CXAEADD9 foreground=CXAEADD9 bordercolor=black borderwidth=0.5]];

keyword all / style=<parent>; 

run; 
quit;
1 ACCEPTED SOLUTION

Accepted Solutions
Ksharp
Super User

You need post some sample data to let us test your code.and better post a photo you want to see.

 

proc tabulate data=sashelp.heart style={just=r};
class status bp_status Weight_Status Smoking_Status;
classlev Weight_Status/style={just=l};
classlev bp_status status Smoking_Status/style={just=r};
table Weight_Status=''*(Smoking_Status='' all) all,
      status=''*bp_status=''*pctn<bp_status>='' ;
keyword all/style={just=r};
run;

Ksharp_0-1669260959424.png

 

View solution in original post

1 REPLY 1
Ksharp
Super User

You need post some sample data to let us test your code.and better post a photo you want to see.

 

proc tabulate data=sashelp.heart style={just=r};
class status bp_status Weight_Status Smoking_Status;
classlev Weight_Status/style={just=l};
classlev bp_status status Smoking_Status/style={just=r};
table Weight_Status=''*(Smoking_Status='' all) all,
      status=''*bp_status=''*pctn<bp_status>='' ;
keyword all/style={just=r};
run;

Ksharp_0-1669260959424.png

 

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 870 views
  • 0 likes
  • 2 in conversation