BookmarkSubscribeRSS Feed
sasdev
Calcite | Level 5

Want to generate the attached proc report structure in excel.

 

Scenario: Have numeric data columns with date column(YYYY-MM-DD), Based on this date, need to place numeric data on respoective workday, days Week, Date

 

Could you please help me to generate the attached structure by using proc report


SAS Proc report layout.jpg
1 REPLY 1
Cynthia_sas
SAS Super FREQ

Hi:

  Thanks for posting a screen shot of your desired output. However, in order to really help you, we need some idea of how your data is structured. Assuming you have variables that can be across variables, you should be able to get a column for every day.

 

  What code have you tried? Can you post some sample data for testing? What are the problems with the code you've tried? It will help everyone help you if you post sample data (not in Excel) and the PROC REPORT program you've got so far. Otherwise, you are asking people to make fake data from scratch (that may or may not match the structure of the data you have) and to write code from scratch, that may be wrong if the structure they pick for their is not the structure you have for your data.

 

cynthia

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
  • 1 reply
  • 698 views
  • 0 likes
  • 2 in conversation