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: 
xd9813
‎10-20-2020
  • 5 Posts
  • 5 Likes Given
  • 0 Solutions
  • 0 Likes Received
This widget could not be displayed.

Re: ODS csv

by Fluorite | Level 6 in ODS and Base Reporting
‎04-27-2020 07:22 PM
‎04-27-2020 07:22 PM
I tried ODS Excel with PROC Print. End user gets this error.  tried PROC Export next... same issue.    ... View more

Re: ODS csv

by Fluorite | Level 6 in ODS and Base Reporting
‎04-27-2020 07:10 PM
‎04-27-2020 07:10 PM
Quotes work, I tested. Excel does not truncate data if surrounded by quotes. Thanks ... View more

Re: ODS csv

by Fluorite | Level 6 in ODS and Base Reporting
‎04-27-2020 06:57 PM
‎04-27-2020 06:57 PM
Some users in the org open these CSV files in MS Excel. As a result, the fields that have leading zeros or card numbers get truncated. Additionally, importing the same dataset to Excel has caused file corruption with that Excel needs to repair message while opening the workbook.   I am looking for a way to replicate db2csv which is a SAS system macro.   Thank you.  ... View more

Re: ODS csv

by Fluorite | Level 6 in ODS and Base Reporting
‎04-27-2020 06:22 PM
‎04-27-2020 06:22 PM
Is there a way to produce the same output as the %ds2csv macro using ODS? I am looking for double quotes around values and only the %ds2csv SAS macro seems to do it. Thanks ... View more

Re: Calculate difference between two dates in the same column conditio...

by Fluorite | Level 6 in SAS Procedures
‎04-18-2019 01:56 PM
‎04-18-2019 01:56 PM
For a newbie it is a bit difficult to understand LAG=LAG(TimeStamp) why not pick var names that a different from SAS function names at these forums? Add a simple _ before the name at the very least. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-20-2020 01:50 PM
Likes given to
Quick links