Is there a way in SAS EG 8.2 to change on which server all programs in a project should run?   When I'm connected to the Internet I prefer to run on SASApp server but when I'm not connected I prefer to run ont local server installed on my laptop. Of course I could go and switch between server in each and every program, but it would be very covenient if this could be done in just one place.   Does anyone know if it's possible?  ... View more

ODS Excel and Proc Report is a powerful combination that let us enjoy also our SAS formattade values in Excel. However, I still wonder if there is a way to preserve the data type numeric as number when I send the formatted data from SAS to Excel.    For illustration please see code below. In the code the Swedish locale is used to allow for national formatting, NLNUM12.2, with decimal comma and space as thousand delimiter. The result looks wonderful in Excel. However, the values in the column Invoice are not numbers and can't be used for calculations.    Can I send formatted values from SAS to Excel and also tell Excel to interpret them as numbers? (In the Swedish version of Excel it's possible to format values with decimal comma and space as thousand delimiter, while at the same time maintaining the data type number.)   options locale= sv_se; goptions device= png; ods excel file= "C:\Temp\Cars.xlsx" ; proc report data= sashelp.cars ; column origin invoice ; define origin / group ; define invoice / analysis format= NLNUM12.2 ; run ; ods excel close; goptions reset= goptions;       ... View more