@GAL1986 personally I don't use PROC COMPARE, I would do a custom SQL or data step since PROC COMPARE output is difficult to wrangle. If you really want PROC COMPARE you likely need to take the full data out and restrict the data set in a second data step anyways.   PS. Please post your own question, not as a response to a thread that's 9 months old.   @GAL1986 wrote: Hi,    I would like to create a dataset that shows the values produced by OUTBASE and OUTCOMP but only for people with unequal values. Is there a way to do this? The following code, even with OUTNOEQUAL, shows the values for all observations.    proc compare base=HLA_internal_test comp=HLA_external_test out=dif2 outbase outcomp outnoequal; ID PID; run;   Thank you in advance!    ... View more

Quite frankly no.  You appear to be creating 24 datasets, for no reason.  You have a call to a macro variable &data_out never defined, and you refer to a variable A in your proc sql which is not selected, and the same across all datasets. This can all be done in one dataset, and have a variable called period which goes from 1-24, this will make your programming far easier in the long run: data want; do period=1 to 24; set sas_out.&data_out.; if ...; output; end; run; However it is impossible to say without seeing some test data (form of a datastep) and what the output should look like - other than one dataset would be better than many. ... View more

Thanks for your solution ... View more

@Jcorti wrote: Why this does not work??   data test (keep=jj);; do ii=1 to 100; do jj=1 to 25 ; i = %sysfunc(putn(jj,z2.)); output; end; end; run; ERROR: Argument 1 to function PUTN referenced by the %SYSFUNC or %QSYSFUNC macro function is not a number. ERROR: Invalid arguments detected in %SYSCALL, %SYSFUNC, or %QSYSFUNC argument list. Execution of %SYSCALL statement or %SYSFUNC or %QSYSFUNC function reference is terminated. 43 i = %sysfunc(putn(jj,z2.)); _ 22 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, INPUT, PUT.   %sysfunc is a macro function that is resolved by the macro processor before the data step is compiled, so it never has access to data step variable values, only names. The way it's written here, it then tries to run the data step function as putn("jj",z2.) Since putn expects a numeric value as its first argument -> boom. The %sysfunc wrapper was a remnant from your earlier code and should have been removed. ... View more

Thanks Man!! My variable Previous Count I don´t know why had leading spaces values, " Previous Count"n comma15. and it worked properly   Thanks again ... View more

r1=put(input("Range Start"n,15.),comma12.); r2=put("Range End"n,comma15.); Range=CATX('_',r1,r2); Yes I used that function and It worked, thanks for the comment ... View more

Now It worked properly 🙂 Thank you both!!   NOTE: The import data set has 25 observations and 7 variables. NOTE: WORK.BAL_M00_ACCT_BAL_AM data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: The import data set has 25 observations and 7 variables. NOTE: WORK.CR_M00_ACCT_CR_AM data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.02 seconds cpu time 0.00 seconds NOTE: The import data set has 25 observations and 7 variables. NOTE: WORK.PYM1_M00_ACT_PYM_AM data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.02 seconds cpu time 0.01 seconds NOTE: The import data set has 25 observations and 7 variables. NOTE: WORK.PYM2_M00_ACCT_P_AM data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds     ... View more

  Hi again,   Do you know if I can reference more variables here??   Asking because I need to cosolidate  into:     data allMyData; length fromSheet $32; set testv1_: indsname=name; fromSheet = cats("M", scan(name, 3, "._"), "_ACCT_BAL_AM"); run;   more macrovariables highlighted in black below:   %do i1=0 %to 24; %let i = %sysfunc(putn(&i1,z2.)); %let cons=consolidated; %let var1=M&i._ACCT_BALANCE_AM;     %let var2=M&i._ACCT_CREDIT_LIMIT_AM; %let var3=M&i._ACTUAL_PYMT_AM; %let var4=M&i._ACCT_PAYMENT_AM;    Thanks a lot in advance,     JC ... View more

Thanks a lot it worked 🙂 ... View more