Hello folks,   I'm looking for a way to check the number of rows for several data sets in a library.   Say I have Dsn1, Dsn2 and Dsn3 stored in a library called A, and I only want to execute the process on the data sets which has more than 10 rows.   I am using %if %sysfunc(attrn(A.Dsn&i,nobs))>10 %then %do;    However, sas told me attrn referenced by %sysfunc is not a number. Any idea?           ... View more

Hello,   I want to get the exact datetime 3 weeks from now. However, the intnx function will always return the time 00:00:000. Any idea on this issue?  Here is an example, thanks.   data example; a=intnx('dtweek',datetime(),-3); a1=put(a,datetime22.3); b=datetime(); b1=put(b,datetime22.3); run; ... View more

Hi folks,   Say I have data sets: Onedata1, Onedata2,  Twodata1, Twodata2, Threedata1, Threedata2, which have the same structure.   I can simply merge them like this:   Data combine; set Onedata1 Onedata2  Twodata1 Twodata2 Threedata1 Threedata2; run;   However, I'm wondering is there an alternative way to merge them, to make loops on one to three and 1 to 2, so that I don't need to list all of them after set statement. Thanks.           ... View more

  I'm curious is there anyway to run a flow on different data sets? say something as following.    However, it only gives me the regression result for data1. I don't want to repeat regression node for each data.   Thanks. ... View more

  I am wondering is there any way to generate the interaction by groups.   say the following program generates the effects x1,x2 and x1*x2 :   proc glmselect; effect poly = polynomial(x1-x2/degree=2 mdegree=1); model y = poly/selection=none; run;   However, if I have x1,x2,y1,y2 and want to generate the effects x1,x2,x1*x2,y1,y2 and y1*y2, how to modify the effect statement? Thanks. ... View more

Here is my question. I want to create several variables to store the values, where the suffix is an index, and strings are changed based on different conditions. However, the following code doesn't generate the expected output.    %let var1=left; %let var2=center; %let var3=right;   %macro example; %do i=1 %to 3; %do j=1 %to 2; %global list_&&var&i_&j; data whatever; list_&&var&i_&j=1 run; %end; %end; %mend;   %example;   I want the macros resolved separately to have list_left_1, list_left_2,list_center_1,list_center_2,list_right_1,list_right_2. How can I get them? Thanks.   ... View more

Say I have a dataset as following:   group  id  var1  var2    1      1    x1     x2     1      2    x3     x4    1      3    x5     x6    2      1    y1     y2    2      2    y3     y4    2      3    y5     y6    3      1    z1     z2    .       .      .       .    .       .      .       .   I want to obtain a dataset like this: group       var1    var2     var3     var4    var5    var6     1           x1        x2        x3         x4      x5        x6     2           y1        y2        y3         y4      y5        y6     3           z1        z2        ....     ...   Any idea on how to transpose the 1st table? Thanks. ... View more