About SandSand

SandSand · ‎05-17-2013

Hi Cynthia Thanks for the reply. I have tested the solutions you proposed. 1. Yes it works if you want text in the first column header, which I don't. Inserting blanks gives me the same result as initially; the header row height does not change based on the 'super' headers. I then tried to use some style formatting to change the color of the text in the first header column (would have been a nice hack). But style formatting apparently does not work in the Add-In. 2. This works. But it doesn't really look that good with the header cells divided like that. I guess I will have to settle with option 2. or just live with they way it initially looked in the AMO. Thank you.

SandSand · ‎04-23-2013

Hello I am writing a proc report in a stored process to be opened via Add-in for MS Office in excel. However can't get the split= option to work properly in the AMO. It works fine in the output when using EG. But when opened in EG the rowis not expanding to the desired three lines of row height, only two are shown. As if the blank line in the first row is discarded, and it seems that it is the first column that "sets the standard" so to speak. Code example: title1 "this is the report title"; proc report data=sashelp.class style(header)=[background=white] split='*'; column ( ' *line2*line3'( sex)) ( ( name)) ('Stats super' ('Stats *sub *extra sub' age height weight ) ); define sex / group 'NAME' style(header)=[just=l]; define name / group 'SEX' style(header)=[just=l]; define age / analysis 'AGE'; define height / analysis 'HEIGHT'; define weight / analysis 'WEIGHT'; break after sex / summarize style=[font_weight=bold font_style=roman]; compute after sex; sex = ""; name = "Total"; endcomp; rbreak after / summarize style=[font_weight=bold font_style=roman]; compute after; sex = "Total"; endcomp; run;

SandSand · ‎08-02-2012

It turns out it might have nothing to do with SAS, but rather windows server setup. Referring to: http://support.sas.com/kb/41/477.html "Authorization errors can occur in SAS® Enterprise Guide® when you use Integrated Windows Authentication". It is a setting in the windows server. I have not had this change to our server setup testet yet. But as a workaround I have set up a connection profile in EG and not selecting IWA, but instead filled in my credentials manually in the connection profile. Accessing the network folders now works!

SandSand · ‎07-26-2012

Hi again.. Yes I have permission issues, but I don't know where to go to solve them. The problem is that our corporate policies prohibit use of machine accounts for the fileshares / network folders I want to save to/read from. So the point is that since I am actively running the stored process myself, through EG, the SAS server should attempt to read/save my files using credentials from my personal windows account, since that is the account that has the access to these folders. I hope my problem is more clear now, and would like any advise.

SandSand · ‎05-25-2012

Thanks ! That also works as intended. Br.

SandSand · ‎05-25-2012

Ksharp, thanks. Didn't seem to work as I wanted though. But found out: data test; set sashelp.class; age_text = put(age,10.); run; ods listing close ; ods html; proc report data=test nowd; column sex age_text height; define sex / group noprint ; compute before sex / style=[just=l fontweight=bold]; text1=sex; line text1 $; endcomp; define age_text / group missing ; define height / analysis SUM ; break after sex / summarize ; compute after sex; age_text = "subtotal"; endcomp; rbreak after / summarize; run; quit; ods html close; Run ;

SandSand · ‎05-23-2012

Hi How do I display a text "Subtotal of [sex]" in the age column in this example; ods listing close ; ods html; proc report data=sashelp.class nowd; column sex age height; define sex / group noprint ; compute before sex / style=[just=l fontweight=bold]; text1=sex; line text1 $; endcomp; define age / group ; compute age; if _break_='_RBREAK_' then do; call define("age", 'style', 'style=[pretext="Total "]'); end; endcomp; define height / analysis SUM ; break after sex / summarize ; rbreak after / summarize; run; ods html close; Run ;

SandSand · ‎10-07-2011

Thanks Nick However it does not seem to work either. I still get "ERROR: Insufficient authorization to access" /Martin

SandSand · ‎10-07-2011

Hello clever folks. I have a SAS server and I run some stp's on the server through EG 4.3. In many cases I would like the stp to access corporate fileshares / network folders. Primarily to import and export excel files. However I need to run the stp on the server as my personal windows account, and not some system account. How do I do this? /Martin

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: Proc report behavior in Add-in for Office

Proc report behavior in Add-in for Office

Re: Run STP on server as "yourself"

Re: Run STP on server as "yourself"

Re: proc report, subtotal when using group/noprint

Re: proc report, subtotal when using group/noprint

proc report, subtotal when using group/noprint

Run STP on server as "yourself"

Run STP on server as "yourself"

Re: Proc report behavior in Add-in for Office

Proc report behavior in Add-in for Office

Re: Run STP on server as "yourself"

Re: Run STP on server as "yourself"

Re: proc report, subtotal when using group/noprint

Re: proc report, subtotal when using group/noprint

proc report, subtotal when using group/noprint

Run STP on server as "yourself"

Run STP on server as "yourself"