Hi, I am working in a very limited environment, I must use PCFILES because SAS is running on a Unix 64bit machine, and my PC uses Windows 7 32bit. I want to write for instance a single value in a single excel cell. Therefore I prepare a template excel file, where I create e.g. in the cell F2 a named range "TEST". Then I do: data THETITLE;      x = "This is a title"; run; libname xlsout pcfiles server ='xxx' path = 'yyy.xls'; proc sql;      drop table xlsout.TEST; quit; data xlsout.TEST;      set TITOLI; run; libname clear xlsout; After this, in the F2 cell I get the columnname 'x' and in F3 the value "This is a title". Is there a way to suppress columns header to export direcly the values in the named range? Thanks a lot Regards ... View more

Hi everybody, I'm running a scheduled sas job on a sas unix server: I would like to produce an xlsx report, where datas are written on specific cells on an xlsx pre-colored template. I tried doing it with proc export dbms=xls, but I got a xls instead of an xlsx and only a plain export of datas (not in specific cells). Considering that it is a unix server, and that there are no other servers available (eg a windows pc files server), how can I do what I'm trying to do? Thanks a lot Regards ... View more

Hi, I've got SAS 9.3, and I'm writing a job data step which will be scheduled at some time, and I'd like to send a report email at the end of the process. I'm trying using a gmail account, but as far as I read there is no way to do it because of the gmail ssl protocol. Is there no way at all? I read that two solutions are upgrading to sas 9.4 (unfortunately we can't) or use the email feature from sas EG (but I need to do it in a data step since the job is scheduled and it is independent of the EG). Should I give up? Are there other solutions? Thank you very much in advance. Regards ... View more

Hi everybody, I have a dataset which contains a list of IDs, each of which belongs to at least a target (let's name them TGT1, ... TGTN). I can present this dataset in two ways, e.g.: A) as a list ID    TGT 100    1 100    4 101    1 102    2 102    3 ... where ID 100 belongs to targets 1 and 4, 101 only to target 1, 102 to targets 2 and 3, and so on. B) as a matrix TGT_name TGT1 TGT2 TGT3 TGT4 TGT1                 2         0        0        1     TGT2                 0         1        1        0 TGT3                 0         1        1        0 TGT4                 1         0        0        1 ... where on the diagonal there is the frequency of distinct IDs in each single target, and on the non-diagonal elements (i,j) there is the frequency of the overlapping IDs in targets i and j. Now, I would like to present graphically the overlapping situation among targets, to immediately identify which targets overlap most, instead of looking at the matrix data. Which kind of graph would you recommend me? I didn't find a kind of graph which suits this dataset, maybe should I rearrange it in a different way? I'm using mostly Enterprise Guide, but I can write a macro as well if needed. Thank you very much! Regards ... View more