cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sworobec1
‎09-24-2020
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Reshaping dataset with dates as column names to panel

by Calcite | Level 5 in SAS Programming
‎09-24-2020 07:57 AM
‎09-24-2020 07:57 AM
Hello All, I have a dataset that has column names as dates and I'd like to convert it to a panel structure where those dates are all under one column called "date". I've attached what the data looks like and an desired version of the data. The actual data has a few years worth of months as column names. The 1 and 0s denote whether the car part was working or not. I don't think a simple proc transpose will solve this issue and I don't know where to start. Would appreciate your help.  Thank you.  ... View more

ods excel: "dynamic" row heights?

by Calcite | Level 5 in ODS and Base Reporting
‎07-22-2020 12:27 AM
‎07-22-2020 12:27 AM
Hello All, I'm using the below program to output to excel. I'm getting a lot of rows that are too high. I suspect this is because SAS is looking at the row that's the highest (there's one that has a lot more text in one column than the others) and setting all row heights to match it. How do I make it so the heights are dynamic for each row?     ODS LISTING CLOSE; ods excel file="folder\test.xlsx" style=htmlblue; ods excel options( flow='tables' sheet_name ='test' embedded_titles='yes' sheet_interval="none" orientation='landscape'); Title 'a title'; run; PROC PRINT DATA= test noobs; RUN; ODS _ALL_ CLOSE;   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-24-2020 01:12 PM
Quick links