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

 

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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
  • 1 reply
  • 344 views
  • 0 likes
  • 2 in conversation