Hi guys. I am new to the Macro, and a bit confuse about how macro resolve the date-time constant in keyword parameter.  This is my code. I want to give a date and number to a and b, and subset a sashelp.air first observation into a subset dataset. But I don't know what is wrong, I cannot resolve the datetime constant in my data step. Please help, thank you in advance  %macro subsetting(a=,b=); data subset; set sashelp.air; if date ="&a" and air ="&b"; run; %mend; %subsetting(a='01jan94'd,b=112); ... View more

Hi guys. I have a bug problem I cannot fix, this is my code. productname is a macro variable "a b c d" and sqlobs is 4 in my case. My logic is using macro do loop and %scan function to scan the product name each time and output the data using proc report step. But when I run the data, nothing comes out. I don't know why? data order; input ordernumber$ product$ qrt; cards; ##1 a 1000 ##2 b 200 ##3 c 3000 ##4 d 200 ; run; proc sql; select distinct product into: productname separated by ' ' from order; run;   %macro report; %do i=1 %to &sqlobs;%macro a; %mend a; %Let name=%scan(productname,&i,' '); proc print data=order; var ordernumber qrt; where Product="&name"; title '&name'; run; %end; %mend; %report; ... View more

Hi, guys. I have a simple question regarding the proc report format: Here is the data data order; input ordernumber$ product$ qrt; cards; ##1 a 1000 ##2 b 200 ##3 c 3000 ##4 a 200 ; run; Here is my code:   proc report data=order; column ordernumber product qrt; define product /group; define ordernumber/display; define qrt/display; run; This is a desirable format(on the top) I want to display and on the bottom is my layout:   My question is how can I change the product into a subtitle, and also is there any alternative way to make this report layout inside of the proc report  ... View more

Hi. I have a question regarding the sentence below: "The RANUNI function returns a number that is generated from the uniform distribution on the interval (0,1) using a prime modulus multiplicative generator with modulus 2 31− and multiplier 397204094 (Fishman and Moore 1982) "   I am confused about the meaning of uniform distribution? How can I understand the random number is generated from the uniform distribution on the 0 to 1 interval. Does it mean the random numbers cannot be 0.1 and 0.08? ... View more

Hi guys. This is my code, I want to substring the "word" value but the first part of the code cannot work, seems like word resolve into:123456789'. But I don't understand the mechanism behind it? In the second part, I got the result, but string='5', why it's not '6' when I use the sixth position inside the %substr function? /******************** first part***********************/ %macro createdata(n=,word=); %do i=1 %to &n; data data&i; %if &i>5 %then string=%substr(&word,6); run; %end; %mend; %createdata(n=10,word='123456789');   /********************second part***********************/ %macro createdata(n=,word=); %do i=1 %to &n; data data&i; %if &i>5 %then string=%substr(&word,6,1);; run; %end; %mend; %createdata(n=10,word='123456789'); ... View more

Hello guys. I have two questions regarding my code. The first one is the descending order inside the declare hash statement, which value will be applied to the descending order? I read material online, some people said the order would be applied on all the keys, so in my case, will the order only applied to the "score" variable?  Another question is my code output nothing on the ge90 dataset. But I don't understand the reason? Thanks in advance! data class_scores; input name :$9. score @@; datalines; Callum 82 Chyou 92 Damien 89 Grace 74 Jorge 99 Kyle 85 Lachlan 83 Lucia 90 Mia 91 Niamh 80 Philipp 89 Tomas 76 ; data top_quarter bottom_quarter ge90; length name $9 score 8; keep name score; if _n_=1 then do; declare hash h(dataset: 'class_scores', ordered: 'descending'); h.defineKey('score'); h.defineData('score','name'); h.defineDone(); call missing(name, score); declare hiter hi('h'); end; count=h.num_items; n=4; put count=; hi.first(); do i=1 to n; output top_quarter; hi.next(); end; hi.last(); do i=1 to n; output bottom_quarter; hi.prev(); end; rc=hi.first(); do while(rc=0); if socre>90 then output ge90; rc=hi.next(); end; run;   ... View more