An interesting article, thanks for sharing.  I would point out two things however: With VBScripting, there are a few considerations.  Firstly you can seriously damage your system/filesystem etc. if things go wrong, this is one of the main reason why X command is sometimes denied bythe IT group.  I wouldn't want to see novice users writing scripts to do things when they either don't understand it, or don't follow appropriate procedures - testing, documentation etc.  It can be quite dangerous.  Also, I have had it before where a vendor sends through a project which includes scripts calling VBAscripts and they fail, different versions or missing components etc.  Robustness should be at the forefront of development.   Secondly need.  With the office applications they already have VBA embedded in them.  Often we have these questions of how to update a pre-existing file with new data.  My answer is always to write VBA code to import a CSV file and process it into the spreadsheet.  This is very simple code and can be stored in the same file.  Just reduces the number of technologies needed.  Of course in an ideal world you wouldn't be using office for anything anyways, use a proper report format or data transfer format and that solves all these issues straight away.  The reliance on Excel (in particular) is one of the biggest holes in technology worldwide.   ... View more

Ok sounds good Ill see what i can do  ... View more

That sounds great.  I would really appreciate it.  If you wouldn't mind, you can go here and subscribe, and I'll get you a copy of the first issue. http://www.codeitmagazine.com/subscribepg.php Then send me an email to chris@codeitmagazine.com, and we can talk about it.  I have a few articles written for the next issue, but I'm better at writing code than I am at writing or aesthetics, and I could probably use tips at all three. Thanks so much! Chris Johnson ... View more

  Chris, Let me follow up. ... View more

I produce the magazine in Adobe InDesign, so sending the articles in MS word is probably best, so I can cut and paste the text into InDesgin.  Otherwise, I am not particular about the format.  Thanks for asking. ... View more

For item 3, you can also use grouping analysis since you said you have a big data and it will take you some time to run the whole thing even though with the simple proc means. ... View more

Thanks.  I was not getting any error or warning message, so I was not aware.  I work toward getting the upgrade. ... View more

Sorry to come back to this, but I think I have found the source of my problems.  I run this code in VBScript using the SAS EG API.  The first time I run it, the code file has no datasets or results.  The second time I run it (and subsequent), it does.  If I open the project and delete the dataset and result shortcut, and I rerun the script, it has no results again.  I would seem that even though I am running the code and then trying to access the dataset and results, they aren't there until after the project is saved, and then they can be accessed by the shortcuts.  Any thoughts on this? ocode.UseApplicationOptions = False ocode.GenListing = True ocode.GenSasReport = False ocode.Log.SaveAs server & "Results\" & ocode.Name & ".log" ocode.Run ocode.SaveAs server & "Results\" & ocode.Name & ".sas" msgbox ocode.Name & ", OutputDatasets: " & ocode.OutputDatasets.Count msgbox ocode.Name & ", Results: " & ocode.Results.Count For n=0 to (ocode.OutputDatasets.Count -1)   dataName = ocode.OutputDatasets.Item(n).Name   ocode.OutputDatasets.Item(n).SaveAs server & "Results\" & dataName & ".xls" Next For n=0 to (ocode.Results.Count -1)   ocode.Results.Item(n).SaveAs server & "Results\" & WScript.ScriptName & n & ".lst" Next ... View more

Hi, Following code will show your's licences information: proc setinit; run; ... View more

You can modify almost everything about the output.  Take a look at: http://support.sas.com/resources/papers/freq92.pdf ... View more

You might check out the Autostart feature for PC Files - great for use on Windows 64-bit servers. http://support.sas.com/documentation/cdl/en/acpcref/63184/HTML/default/viewer.htm#a003353773.htm Note that there was a recent hotfix for this (PC Files Server) to improve how it works in workspaces (such as from EG), so you'll want to make sure you've got the latest. Chris ... View more

You can use the new custom task "Export Data to Microsoft Excel 2007/2010". Details are at http://blogs.sas.com/sasdummy/index.php?/archives/205-Export-to-Excel-20072010-using-SAS-Enterprise-Guide.html. ... View more

Thanks! My company is installing SAS 9.2 and EG 4.3 today. Is this installed by default, or will I need to ask for it specifically? ... View more