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

 

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