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: 
NUmsf
‎05-03-2018
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: How to open .sas7bdat in SAS and export to excel?

by Calcite | Level 5 in SAS Programming
‎05-03-2018 06:02 AM
‎05-03-2018 06:02 AM
Thanks. If you had read my first question completely, there you could read, "So, What I want to do it randomly pick (say 10,000 or 20,000) data and export only this randomly picked data to excel.". Any thoughts? ... View more

Re: How to open .sas7bdat in SAS and export to excel?

by Calcite | Level 5 in SAS Programming
‎05-03-2018 05:34 AM
‎05-03-2018 05:34 AM
But, if I have 2 million rows in that SAS file, how can I export to excel which allows only around 1 millions rows in a tab? ... View more

How to open .sas7bdat in SAS and export to excel?

by Calcite | Level 5 in SAS Programming
‎05-03-2018 04:58 AM
‎05-03-2018 04:58 AM
I am quite new to SAS. I have got a file with file extension .sas7bdat which contains daily stocks prices and percentage changes. It has almost 2 million line items. I know that I can simply double click the file and open it with SAS 9.4. But, I am looking for codes which I can type in Editor and open this file. Please help me.   After I open this file, I need to export it to excel. Since it has 2 million data, I can not export everything in a single excel tab. So, What I want to do it randomly pick (say 10,000 or 20,000) data and export only this randomly picked data to excel. My .sas7bdat file is on desktop. Please help. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-03-2018 07:22 AM
Quick links