Hi Dear, Here is my coding. I want to add background colour blue for the row when the value of x = 'b' . My coding seems running without error but I don't see the background color. Can you please let me know how I do it. I am using SAS 9.2 and on Windows XP. data temp1; input @1 x $1. @2 y $1. @3 z $1.; cards; abc abd abf abc abw acw acq bcd ; run; ODS LISTING CLOSE; ods tagsets.excelXP path='c:\' file="mytest.XLS" style=newstyle rs= none; TITLE " my title " ; ods tagsets.excelXP options( Sheet_Name="mytes" Absolute_Column_Width='30,30,10' ); run; proc report data=temp1 nowd ; column x y z; define x / order ' x'; define y / order 'y'; define z / 'z'; compute after x; if x='b' then ; call define (_row_ ,'style','style={background=blue}'); endcomp; run; ods _all_ close; ods LISTING; ... View more

Hi Dear, Here is my coding. I am expecting s value of var x and missing value of y in the report. When I run the below codiing , I get value 'a' of x but the value 's' of x. can you please let me if there any options that I can put to get this value in my proc report. I am using SAS 9.2 in Windows XP data temp; input @1 x $1. @2 y $1. @3 z 1.; cards; ab1 ab2 ac1 ac2 s 3 ; run; options missing; proc report data=temp nowd; column x y z; define x / order; define y / order; define z / analysis; run; here is my output; x y z a b 1 2 c 1 2 Thanks for your help in advance. Inp ... View more

Hi Dear, Here is my coding: data temp; input r $2. x $1. y $2. z 1.; cards; r1aa11 r1aa21 r1ba11 r1ba21 r2ca11 r2ca22 r2da11 r2da22 r3ee11 ; run; proc report data=temp nowd nocenter; column r x y z; define r / group; define x / group; define y / 'y'; define z / analysis; break after x/summarize DOL DUL ; break after r /summarize DOL DUL ; rbreak after / summarize DOL DUL ; run; How do I get the expeced below output: r x y z r1 a a1 1 a2 1 == = ========= r1 a 2 == = ========= b a1 1 a2 1 == = ========= r1 b 2 == = ========= == ========= r1 4 == ========= r2 c a1 1 a2 2 == = ========= r2 c 3 == = ========= d a1 1 a2 2 == = ========= r2 d 3 == = ========= == ========= r2 6 == ========= r3 e e1 1 == = ========= ========= 11 ========= but I am getting the below r x y z r1 a a1 1 a2 1 == = ========= r1 a 2 == = ========= b a1 1 a2 1 == = ========= r1 b 2 == = ========= == ========= r1 4 == ========= r2 c a1 1 a2 2 == = ========= r2 c 3 == = ========= d a1 1 a2 2 == = ========= r2 d 3 == = ========= == ========= r2 6 == ========= r3 e e1 1 == = ========= r3 e 1 == = ========= == ========= r3 1 == ========= ========= 11 ========= I don't want repeat r3 three times. I need this to appear only one time in the report Thanks so much for help in advance. Thanks Inp ... View more

Hi Dear, Here is my coding. When I run the below coding I am able create MYTEST.xls but when I open the xls sheet, and try to use the custom filter, then I try to use ' is greatter than' or 'is less than' from the drop down panel , it doesn't work. Basically it seems, it doesn't recognize the date format. Can any one help to me fix this problem. I am using SAS 9.2 on Windows XP service pack 3. Do I have install any SAS patch to fix this issue? DATA TEMP; X='23MAR2009'D; OUTPUT; X='22APR2007'D; OUTPUT; X='22MAR2010'D; OUTPUT; RUN; ods listing close; ods tagsets.excelXP path='C:\' file='MYTEST.xls' style=newstyle rs= none; ods tagsets.excelXP options( Sheet_Name='TEST' Embedded_Titles='YES' Embedded_Footnotes = 'YES' Embed_Titles_Once='YES' Suppress_Bylines='YES' Sheet_Interval='NONE' Frozen_Headers='2' Autofilter='ALL' Absolute_Column_Width='10' ); run; PROC PRINT DATA=TEMP; FORMAT X DATE9.; RUN; ods _all_ close; ods listing; options noxwait noxsync; x '"C:\Program Files\Microsoft Office\OFFICE11\excel.exe" /e'; data _null_; x=sleep(3); run; filename cmds dde 'excel|system' ; data _null_; file cmds; put '[app.minimize]'; put '[open("C:\MYTEST.xls")]'; put '[error("false")]'; put '[SAVE.AS("C:\MYTEST.xls",1)]'; put '[close("false")]'; put '[quit()]'; run; ... View more

Hi See my below coding. I have a question regarding title statment. If you look up my title statment. I have added few spaces(added 16 spaces for some reason it is shrinked in this posting) between text1 and text2. If I want to put around 180 space between text1 and text 2, is there any simpler way to do this rather than putting 180 spaces between text1 and text2. Your help is more appriciated. Thanks for your help in advance. data temp; input x $1.; cards; 1 2 3 3 3 ; run; proc print data=temp; title 'test1 test2'; run; ... View more

Hi Dear, I am trying to connect to Sql server , the coding and log are below. According to the below log, should I have to installed ODBC driver for SQL server. It seems, I am not able to connect to the server. Password and Userid works when I connect from sql server to sqlserver. For securty reason, I have replace them.If I have to install, can any one please let me know where I can get the odbc driver and how to do it. Thanks so much in advance. 1 proc sql noprint; 2 connect to oledb as idr 3 (init="Provider=SQLOLEDB.1; 4 Password=password; 5 Persist Security Info=True; 6 User ID=userid; 7 Initial Catalog=Anguilla; 8 Data Source=xxxxxx" 9 ); ERROR: The OLEDB engine cannot be found. ERROR: A Connection to the oledb DBMS is not currently supported, or is not installed at your site. 10 11 create table work.sample as 12 select 13 * 14 from connection to idr 15 ( 16 select * 17 from mytabel 18 where period = '2009-10-31' 19 ) 20 ; ERROR: The IDR engine cannot be found. ERROR: A Connection to the idr DBMS is not currently supported, or is not installed at your site. 21 %PUT &SQLXMSG; ERROR: A Connection to the idr DBMS is not currently supported, or is not installed at your site. 22 23 disconnect from idr; ERROR: Connection to the idr DBMS does not exist. 24 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.25 seconds cpu time 0.01 seconds 25 run; ... View more

Hi According to my below coding. It doesn' t create macro var numrec. but if I place 'put numrec' instead of 'call symput('num', numrec)' it output the value 5; Please note that I am using version 8.2. thanks so much in advance for your help. data temp; input x 1.; cards; 1 2 3 4 5 ; run; data _null_; call symput('numrec', numrec); stop; set temp nobs=numrec; run; %put 'value ' &numrec; Thanks Inp ... View more

Hi Is it possible to use proc export to create MS access db in MVS operating system? Thanks in advance. regards Inp ... View more

Hi When I run below coding , the column header is truncated to 'this is testing more than thirty' but my acutal column header is 'this is testing more than thirty two charaters'. Can any one help to fix this problem. Thanks so much for your help in advance. data temp; input x $50.; label x = 'this is testing more than thirty two charaters'; cards; aaaaaaaaaabbbbbbbbbbccccccccccddddddddddeeeeeeeeee ; proc print data=temp label; run; PROC EXPORT DATA=temp OUTFILE='C:\PROJECTS\TPA_Current\OCT2009\testing.csv' DBMS=csv REPLACE LABEL; RUN; ... View more