Hi Everyone,
Please let me know the techniques for this exporting data from PC SAS into Excel. Thanks
Regards
Click on your dataset in explorer window, select menu File - Export... Follow instructions.
Any error message?
Fail proof (almost): Export as TAB separated text file and import data in Excel.
SAS 9.3
As mentioned above there are many ways of getting data to Excel:
-> Export from explorer window in SAS
-> Proc export
-> ods tagsets.excelp
-> libname excel
-> output to CSV
-> DDE
-> Copy and paste
Your question is too vague. What have you tried, what errors do you get. Post your code.
Did any of the options I posted work for you, if not please explain why.
Here's a blog post detailing several methods:
http://blogs.sas.com/content/sasdummy/2012/02/11/export-excel-methods/
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.