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/
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.