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: 
yaniv_daaata
‎03-27-2024
  • 7 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Export tables to an existing macro-enabled Excel file

by Calcite | Level 5 in SAS Programming
‎12-26-2023 05:36 PM
‎12-26-2023 05:36 PM
Which method would you use ? Proc export ? ODS ? ... View more

Export tables to an existing macro-enabled Excel file

by Calcite | Level 5 in SAS Programming
‎12-26-2023 09:16 AM
‎12-26-2023 09:16 AM
Hi,   I have an Excel file, xlsm, that has formulas to fill up reports.  I am trying to find a way, of running SAS programs, and then all the tables will be exported to that Excel. Ideally, the data will be sent to the cells that are linked already to the formulas.  Is it doable ?  If not, can I export to the file to another sheet ? of course without taking the risk of ruining anything in the file.    Thank you.    ... View more

Re: Transposing a table with two group levels

by Calcite | Level 5 in SAS Programming
‎12-25-2023 03:05 PM
‎12-25-2023 03:05 PM
Thank you so much ! Worked like a charm.   ... View more

Re: Transposing a table with two group levels

by Calcite | Level 5 in SAS Programming
‎12-25-2023 10:44 AM
‎12-25-2023 10:44 AM
My example was just an example. In reality, I have 10s of products.   Can we not ignore the product, and import it as well?  ... View more

Re: Transposing a table with two group levels

by Calcite | Level 5 in SAS Programming
‎12-25-2023 10:12 AM
‎12-25-2023 10:12 AM
This is the actual data:   It's in an excel file.   This is the SAS table that I need:     It will need to be run periodically. Not just once.    Thank you ... View more

Re: Transposing a table with two group levels

by Calcite | Level 5 in SAS Programming
‎12-25-2023 09:19 AM
‎12-25-2023 09:19 AM
I changed it to image. Hope it is ok now.  ... View more

Transposing a table with two group levels

by Calcite | Level 5 in SAS Programming
‎12-25-2023 08:58 AM
‎12-25-2023 08:58 AM
I have an excel table with values that depend on Product and Type.  The problem is that the first row is Product, second row is Type, and the next rows are values, depending on the first two rows.  How do I transpose it in SAS so that I can easily query on that?   Please see the example attached.    ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-27-2024 05:50 PM
Quick links