BookmarkSubscribeRSS Feed
SuryaKiran
Meteorite | Level 14

Hi All!

 

I want to remove the BOX in proc tabulate. I want all in one line beacuse I will export to excel. Capture11.PNG

 

 

I need Excel like this :

Capture1.PNG

 

 

 

 

Thanks,
Suryakiran
3 REPLIES 3
ballardw
Super User

The box is going to remain, better would be to actually use it. Or move to Proc report.

You don't give any variable names but it looks like you may be using the sashelp.cars data set.

 

Please look at this code as an example:

proc tabulate data=sashelp.cars;
   class origin make type;
   table origin=""*make="",
         type=""*n=""
         /box = "Origin     Make" misstext="0";
run;

Of course the question could be what will be done after this is in Excel...

 

SuryaKiran
Meteorite | Level 14

Yes I used SASHELP.CLASS as example. I need to create report in excel and send to markets. So that then can create pivot tables from this excel. I need 1st row with column names and from 2nd row data starts.

Thanks,
Suryakiran
ballardw
Super User

You want to switch to Proc Report to get the individual columns.

Or possibly summarize data, transpose and use proc print.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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