Dear all,   Is any way to add key that not in dataset to hash? Just like: dcl hash h(dataset:"sashelp.class”); h.definekey("key","sex"); h.definekey(all:"Y"); h.definedone(); I try to use _N_ ,but failed. dcl hash h(dataset:"sashelp.class”); h.definekey("_N_","sex"); h.definekey(all:"Y"); h.definedone(); Or I try to use in option, failed as well. dcl hash h(dataset:"sashelp.class(in=key)”); h.definekey("key","sex"); h.definekey(all:"Y"); h.definedone(); So is there any possible to add a key that does not exist in the dataset when I use the dataset option in hash？   Thanks. ... View more

Dear all，   What I have： data have; input subject $ seq aval date $10. @@; datalines; A 1 3 2020-01-01 A 2 4 2020-01-04 A 3 3 2020-03-01 A 4 5 2020-04-01 B 1 4 2020-04-05 B 2 1 2020-03-03 B 3 2 2020-01-03 B 4 1 2020-02-03 C 2 4 2020-02-04 C 1 4 2020-02-03 ; And what I want: And my code please see as after: data a; if _N_=1 then do; dcl hash h(); h.definekey('subject','seq'); h.definedata('min'); h.definedone(); call missing(min); end; do _N_=1 by 1 until(last.subject); set have; by subject; if first.subject or .<aval<min then h.replace(); min=min(min,aval); end; do until(last.subject); set have; by subject; if h.check()=0 and aval=min then output;; end; run; Running results are not what I want，and how to modify the code in order to put the smallest date record into hash and output in the second DOW?   Thanks ... View more

  Hi all, How to modify the code to run successfully? I want to use &faa in one data set. %scan(symget('faa'),&i,|) can't run successfully too. %macro ff; data a; if _n_=1 then do; aa='f|dd|ff'; call symputx('faa',aa); end; set xx; %let i=1; %do %until (%scan(&faa,&i,|) = ); %scan(&f,&i,|)='1'; %let i=%eval(&i+1); %end; run; %mend; %ff; Thanks.   ... View more

  proc template; define style GDOLinePlotBW; parent=Styles.JOURNAL; class GraphError / LineThickness=1px; class GraphData1 / markersymbol = "CircleFilled" linestyle = 1; class GraphData2 / markersymbol = "Triangle" linestyle = 2; end; run; SCATTERPLOT X=_jitter_time Y=y/ YERRORUPPER = uppervar YERRORLOWER = lowervar DATATRANSPARENCY = 0.3 NAME = 'scatter' GROUP = groupp; Hi all, Is there any problem with my code? Why the linetype is the same with two group? Thanks.     ... View more

Hi all,   I want to use the code as below to avoid truncation.   proc format library=work; value $cmfreq "1" = "BID" "2" = "TID" "3" = "QID" other=[$100.] ; run;     But how to use cntlin to replace this code. data tmp_format; set tmp_format; by fmtname; output; if last.fmtname then do; start='other'; end='other'; label='[$200.]'; output; end; run; The code as below is not work.   Thanks.     ... View more