BookmarkSubscribeRSS Feed
santhosh
Fluorite | Level 6

hi

i need to generate excel where one to six row should have 5 columns and seven to eleventh row last 3 columns should be merged into one column as shown in attachment


Excel output.jpg
3 REPLIES 3
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Hi,

As far as I am aware there is not method of doing this in tagsets.excelxp or libname excel.  What I would suggest, as you seem to want to use a lot of Excel functionality, is to create a template Excel file, which has the layout you want.  Export your data as CSV from SAS.  Now, in your Excel file write a small VBA macro which opens and reads in the CSV file, and processes the data into the template.

santhosh
Fluorite | Level 6

Is it possible to generate directly excel from sas ods

RW9
Diamond | Level 26 RW9
Diamond | Level 26

Yes, tagsets.excelxp, libname excel etc.  Many ways to generate an Excel file from SAS.  But they don't offer the functionality of cell merging. 

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!

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