Hi. you need a 'having' statement to fliter the group. try this. [pre] data patrick; input id $ product; datalines; 101 6 101 3 101 5 101 3 102 2 102 3 102 6 102 6 103 6 103 6 103 6 103 6 ; run; proc sql; create table test1 as select * from patrick where product in (6 3) group by id having count( distinct product) ge 2; run; quit; proc print; run; [/pre] Ksharp ... View more

Hi. Cynthia@sas is right, you can use proc tabulate or report to get that. This is an example. [pre] proc format; value $sexfmt 'F'='Female' 'M'='Male' 'U'='Unknow' ; run; proc report data=sashelp.class nowd completerows; column sex n; define sex /group format=$sexfmt. preloadfmt exclusive; define n /format=4. 'Freq'; run; [/pre] Ksharp ... View more

Hi. Patrick You are definitely right, the code you writed is what i mean,but there are too long code ,So i write the code before. The longitude data is very useful when you meet a trouble. And unfortunately I also have much job to complete,and have little time to browse this forum.But I love this forum.From it I learned much more than i have. Ksharp ... View more

Hi. Mr. Patrick . long time no see. 🙂 And my code is more simple than yours. So you understand more about SAS than me. [pre] data temp(drop=id); input (id _2009_01 _2009_02 _2009_03 _2009_04) ( : $ ); datalines; 1 CM CM LA LA 2 MC MC MC MC 3 AQ ZZ LL LL 4 AG HG HG HG 5 IJ IJ Ij IJ ; run; proc print; run; data patrick; set temp; array a{*} _character_; do i=2 to dim(a); if a{i} ne a{i-1} then do; varname= vname(a{i}); output; end; end; keep varname; run; proc freq data=patrick; tables varname/nopercent nocum; run; [/pre] Ksharp ... View more

Hi. I think transposing your data into longitudinal data would be helpful. And assumping your variables(i.e. 2009/01 2009/02 2009/03 2009/04...) are all character. try this. For getting Macro, do it yourself. give the code next Monday. Message was edited by: Ksharp ... View more

Hi. I only know how to make log looks like exactly in SAS log window in a picture.But the color of text in this picture is all black. so you can use photoshop to make a chang or use proc gprint and annotate dataset to achieve what you need.But I am not familiar with annotate dataset,you can see its documentation by yourself.And if you can ,hope to put this picture into your html file. the code is:(the name of picture is 'logGraph') [pre] filename logtxt 'c:\temp\log.txt'; goptions reset=all; proc printto log=logtxt; run; proc print data=sashelp.class; run; proc printto; run; proc gprint fileref=logtxt name='logGraph'; run; [/pre] Ksharp Message was edited by: Ksharp ... View more

[pre] data a; A='101';order=1;val=25;p=0;output; A='101';order=2;val=54;p=0;output; A='101';order=3;val=66;p=1;output; A='101';order=4;val=85;p=1;output; A='101';order=5;val=99;p=0;output; A='101';order=6;val=120;p=0;output; A='101';order=7;val=135;p=1;output; A='101';order=8;val=170;p=1;output; A='101';order=9;val=186;p=1;output; A='101';order=10;val=190;p=1;output; A='101';order=11;val=195;p=1;output; run; data temp; set a; retain flag 0; if p ne lag(p) then flag+1; run; data result; set temp; by flag; retain pre; if first.flag then pre=val; if last.flag and p then do; Name='A'; Diff=catx('-',val,pre); output; end; keep Name Diff; run; proc print; run; [/pre] Ksharp ... View more

Hi.Doc@Duke I guess that the sample size is too small or the events are too sparse.So the estimation of coefficient would be bias. So anna You can try to use exact logistic regression .Such as: [pre] proc logistic data=yourdataset descending exactonly; model Y=X Z; exact X Z /estimate=both; run; [/pre] Ksharp ... View more

Hi.Anna. I think Doc@Duck has the right idea here.That is to say you need more covariates to add into your model or need more obs.Your logistic model is perfect prediction(i.e. you only have one outcome variable and one covariate).The perfect prediction is not a good model which will give your not good estimate and interpretation. I think SAS will issue a NOTE in the log file. Message was edited by: Ksharp ... View more

then Don't use 'descending'. But i am curious that Why you do want to do that? ... View more

Hi.Cynthia. I learned that using DDE also can be without opening xls file. SAS is a really amazing tool. ... View more

Hi.Peter. I have no clue about this ,Sorry. I just saw something writed by Cynthia and write these codes. You should talk with some technical guys of SAS.They can give some detailed reason. It is also not convenient to open xls file firstly with DDE. ... View more

Have your Solaris UNIX set up some Anti-virus Software or Fire wall? If it has ,try to run your code with closing Anti-virus Software or Fire wall temporarily. ... View more

Have you format the variable in the dataset forever? Such as: [pre] filename area1 DDE 'excel|c:\[Op.xls]Sheet1!r2c2:r50c20'; filename area2 DDE 'excel|c:\[Op.xls]Sheet1!r2c30:r50c40'; data temp; set sashelp.class; format weight height dollar12.2; run; data _null_; set temp; file area1; put name sex height weight; file area2; put name sex height weight; run; [/pre] Ksharp ... View more

Hi.Just as Cynthia@SAS said ,you can do it by DDE. But firstly you should create a xls file(e.g Op.xls),and before run the code below,you should open Op.xls; [pre] filename area1 DDE 'excel|c:\[Op.xls]Sheet1!r2c2:r50c20'; filename area2 DDE 'excel|c:\[Op.xls]Sheet1!r2c30:r50c40'; data _null_; set sashelp.class; file area1; put name sex height weight; file area2; put name sex height weight; run; [/pre] Ksharp ... View more