Hi.Art Carpenter. Perhaps you need to talk to Technical Group. I also think these both are identical. Regards. Ksharp ... View more

Hi.Cynthia@sas 's code is great. So that you need to change background color.The traffic light would be a good choice. [pre] proc format; value $color 'Actual'='pink' 'Forecast'='green' ; run; ods html file='span_example.html' style=sasweb; proc report data=sashelp.class nowd style(header)={background=$color.}; column('Actual' sex age) ('Forecast' height weight); define sex/display; run; ods html close; [/pre] Ksharp ... View more

Hi. Art Carpenter is right. Remember SAS syntax is very flexible. To incorporate Arc's view,you can use modify input or list input ,Such as [pre] select a: b: art1-art100; [/pre] a: stand for any name of data set which start with alphabetical ' a '; Ksharp ... View more

Obviously. You need another style of sum function. [pre] _sum=sum( of weight height age); [/pre] Ksharp ... View more

Hi. Without view all of your code, It is hard to say something. But I guess you can make an index variable to get the order you need. Ksharp ... View more

Hi. I think SAS have some proper format can read it. Hope Someone can point it out.I have another curve way after lookup documentation for a long time. [pre] data temp; input date : ddmmyy10. time anydttme11.; datetime=input(catx('/',put(date,date9.),put(time,timeampm11.)),datetime22.); format datetime dateampm22.; datalines; 26/01/2009 9:45:51 AM 26/01/2009 10:02:08 PM ;run; proc print noobs;run; [/pre] Ksharp ... View more

Hi . Maybe you need build a ODBC connection for that xls file,because SAS treat Excel file as a library,but it is too troubled.Or recommend you to use password to open that Excel file and File-> Save as->xls file to make a xls file without password. Ksharp ... View more

Hi. Is there FTP service in your primary SAS server. If it has ,you can use ftp command. Start-> run -> command-> ftp 10.1.2.1->binary 80 -> get test.sas7bdat Ksharp ... View more

Emmmm.Maybe the founction is your best companion. [pre] data temp; input id invitedate ddmmyy10.; monyy=substr(put(invitedate,date7.),notdigit(put(invitedate,date7.))); cards; 1 01/01/2010 1 12/01/2010 1 15/05/2010 2 01/01/2010 2 15/05/2010 2 19/06/2010 2 30/07/2010 ; run; proc freq data=temp; tables id*monyy /list out=result(drop=percent); run; proc print noobs label; var id monyy count; label count='invites'; run; [/pre] Ksharp ... View more

@data _null_; is correct. He is more understanding about Macro variable and clever than me. Learned it. ... View more

Hi. Your vbar variable is numeric , so SAS will automatically compute midpoint of horizontal axis. You need option ' discrete ' to fit the axis or change 'age' into character type. [pre] proc gchart data= sashelp.class; vbar age / midpoints = 11 to 15 sumvar=height type=mean discrete; run; [/pre] P.S. Actually If you post your question to the 'SAS graphic',There is a sas-man named Robort would solve it. Ksharp Message was edited by: Ksharp ... View more

Hi.Misunderstood what your said. Actually . I think Patrick's method can work.But It is hard to decide without your origin data. And Maybe you can use LENGTH statement to solve your problem, which has effect as modifier ' : ' ; [pre] data temp; length comment $ 20000; input id comment $; datalines; 1 tuieorejejepudf 2 diuet 3 troerpere 4 skjfasiwoewojkfoewroegerelgkerg ;run; proc print noobs;run; [/pre] Ksharp ... View more

Hi.Misunderstood what your said. Actually . I think Patrick's method can work.But It is hard to decide without your origin data. And Maybe you can use LENGTH statement to solve your problem, which has effect as modifier ' : ' ; [pre] data temp; length comment $ 20000; input id comment $; datalines; 1 tuieorejejepudf 2 diuet 3 troerpere 4 skjfasiwoewojkfoewroegerelgkerg ;run; proc print noobs;run; [/pre] Ksharp ... View more

Hi. Maybe using proc format to change your dataset1 into format will be a good choice, This method is efficient.Suggest posting some dummy data to see how to code it. Ksharp ... View more

En.Yes .SAS can do it. [pre] data temp; infile datalines delimiter=' ,'; input parentid $ subid $; datalines; 123, 990 123, 991 124, 992 124, 990 run; proc sql feedback; select * from temp group by subid having count(distinct parentid ) ge 2; quit; [/pre] Ksharp ... View more