if your SAS EG is on local machine and not on any server, you can just put the desktop location in export. If it's on some server, you can put the server location in outfile statement and then you can copy the file to desktop from server
Using ODS, might turn out to be helpful, there are three videos on that and you can start with th-cam.com/video/wbzUMnYcQbk/w-d-xo.htmlsi=H3wHX9tf6yW_Qg99 worth noting, SAS has limited scope on excel formating.. you may use the VBA to automate the formating work.. that would be more effiecient
Thank you for giving it a watch and putting your point of view, by "second statement" if you mean the "outfile" statement then it's not required there.. if you put, it will give error.. happy to support further
Hi Dhanush, You can use the same process to achieve just replace xlsx with csv, see the example below: proc export data=mylib.trans1 outfile="/folders/myfolders/sasuser.v94/excel/trans1.csv" dbms=csv replace; run;
you should try ODS, here couple of videos - th-cam.com/video/wbzUMnYcQbk/w-d-xo.htmlsi=RI6L-yTjpdMXkTmv th-cam.com/video/e8BFO-7K0aI/w-d-xo.htmlsi=poisIAetmlOkMMl4 th-cam.com/video/L8-zu7NDfSk/w-d-xo.htmlsi=gmbgS0mRZ3zjYI04 th-cam.com/video/aXcIohyTryg/w-d-xo.htmlsi=mru9iEh6FD28D5KO
you r doing God`s work!!!!!!!!!!! thank you my friend
Glad you liked it
This is very good and so helpful. Thank you.
I'm glad that it helped you
Very useful for a beginner like me :) THX
Thank you Bleiz, good n happy learning
Can You please share the video of ODS using SAS On Demand. Thank you
Sure, will do so soon.
what if you want to just save it to your desktop. I use SAS Enterprise guide
if your SAS EG is on local machine and not on any server, you can just put the desktop location in export. If it's on some server, you can put the server location in outfile statement and then you can copy the file to desktop from server
Is it available at sas v.7 too?
Hi could you please explain how I can give colour red to customer2 sheet only while exporting all this three sheet together into one Excel?
Using ODS, might turn out to be helpful, there are three videos on that and you can start with
th-cam.com/video/wbzUMnYcQbk/w-d-xo.htmlsi=H3wHX9tf6yW_Qg99
worth noting, SAS has limited scope on excel formating.. you may use the VBA to automate the formating work.. that would be more effiecient
In second statement at last i think semicolam shd be mentioned am just asking
Thank you for giving it a watch and putting your point of view, by "second statement" if you mean the "outfile" statement then it's not required there.. if you put, it will give error..
happy to support further
very helpful, thanks sir
Glad you liked it
can you help me to download a offline sas studio to my desktop
You may like to watch this video -
th-cam.com/video/IV-iTcuZ12g/w-d-xo.html
is there a way to export our result as csv file?
Hi Dhanush,
You can use the same process to achieve just replace xlsx with csv, see the example below:
proc export data=mylib.trans1
outfile="/folders/myfolders/sasuser.v94/excel/trans1.csv"
dbms=csv replace;
run;
@@learnerea im working with existing table so can I still use this syntax ?
@@031dhanu Yes you can just change the required information like table name, file name and the location as you needed
@@learnerea thanks bro!
And if I wanna export a graph to JPEG. How can I do that ?
you should try ODS, here couple of videos -
th-cam.com/video/wbzUMnYcQbk/w-d-xo.htmlsi=RI6L-yTjpdMXkTmv
th-cam.com/video/e8BFO-7K0aI/w-d-xo.htmlsi=poisIAetmlOkMMl4
th-cam.com/video/L8-zu7NDfSk/w-d-xo.htmlsi=gmbgS0mRZ3zjYI04
th-cam.com/video/aXcIohyTryg/w-d-xo.htmlsi=mru9iEh6FD28D5KO
Open the csv and show it