Search results for query: *

Thank you so much, Chris. As it turned out, the data I had was not quite that way, and I had to use NOTSORTED to resolve it. As always,your help is greatly appreciated!

Hi everyone, I need some help to roll up the following dataset by ID and FAC (facility). As you can see in the output dataset below, I want to keep the first record, then roll-up as to when facility switches. Then stamp the appropriate times to the record, and that is START_TM (start time) of...

Hi Chris, I am running SAS V8 now so can't try your ExcelXP tagsets. Will run it tomorrow on the different computer then. I really appreciate your help !

Thank you for your help,Chris. I have read some papers on Proc Template and actually modified the PARENT style to get rid of the lines as the following code [code] PROC TEMPLATE ; DEFINE STYLE SMALLFONTS...

Hi everyone, I am using STYLE=RTF in the following program and encounter a problem: I need to get rid of the horizontal lines (not all) every time the variable NAME changes the value(in this case it goes from FACID to LTYPE). Here is my code: data test; infile datalines dsd; input name $...

Thanks Sarav for your help! But it still does not work with the THOUSANDS_SEPARATOR. However, I used TAGATTR like this: ODS TAGSET.EXCELXP options(....); Proc print data=test; var price / style={tagattr='format:#,##0'} ; run; ODS _all_ CLOSE; And IT WORKS !!! thanks,

Hi everyone, I am using ODS ExcelXP on Mainframe to send a proc print output to Excel, however the format in the ODS output does not seem to agree with the format comma10. I specified in the proc print For example: Proc print data=test; var Price; format Price comma10. ; run; My SAS...

Thanks for the tips Kosa13. I wonder if we could get rid of the missing values still using PROC REPORT. My intention is the use ODS with the PROC REPORT, and avoid using PROC TEMPLATE.

Hi, I am running the following program and producing the below output. data p2005; input fac_id $ year month pd ; date=mdy(month,01,year); format date mmddyy10. ; datalines; FRE 2005 1 21 FRE 2005 2 12 FRE 2005 3 3 FRE 2005 4 24 FRE 2006 1 14 FRE 2006 2 6 FRE 2006 3 25 OAK 2005 1 20 OAK 2005...