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/
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.