I'm trying to merge two different datasets, keeping some variables of the second dataset.   I used the following code:   proc sort data = MO; by n; run; proc sort data = TE; by n; run; Data MOTE; Merge MO (in=A) TE (in=B keep = n UltMes MesSEMReg); by n; If A; run;   In the merged data set the variables UltMes MesSEMReg exist but they are empty.   Can you help me solving this problem?     ... View more

Hello   I've created this macro variables   %let basemon=201601; %let mon02=%sysfunc(intnx(month,%sysfunc(inputn(&basemon,yymmn6.)),+2),yymmn.); %let mon01=%sysfunc(intnx(month,%sysfunc(inputn(&basemon,yymmn6.)),+1),yymmn.); Then I created this two data statements:   data out.P24M&basemon.; set out.P24M&basemon.; FONTE201602=tranwrd(FONTE&mon01.,'D','1'); FONTE201602=tranwrd(FONTE&mon01.,'E','1'); FONTE201602=tranwrd(FONTE&mon01.,'A','1'); FONTE201603=tranwrd(FONTE&mon02.,'D','1'); FONTE201603=tranwrd(FONTE&mon02.,'E','1'); FONTE201603=tranwrd(FONTE&mon02.,'A','1'); run; data out.P24M&basemon.; set out.P24M&basemon.; NFONTE201602= input(FONTE&mon01., comma10.); run; Bus what I want and it doesn´t work is this code:   data out.P24M&basemon.; set out.P24M&basemon.; FONTE&mon01.=tranwrd(FONTE&mon01.,'D','1'); FONTE&mon01.=tranwrd(FONTE&mon01.,'E','1'); FONTE&mon01.=tranwrd(FONTE&mon01.,'A','1'); FONTE&mon02.=tranwrd(FONTE&mon02.,'D','1'); FONTE&mon02.=tranwrd(FONTE&mon02.,'E','1'); FONTE&mon02.=tranwrd(FONTE&mon02.,'A','1'); run; data out.P24M&basemon.; set out.P24M&basemon.; NFONTE&mon01.= input(FONTE&mon01., comma10.); run; If I write  FONTE&mon01.=tranwrd(FONTE&mon01.,'D','1'); instead of FONTE201601=tranwrd(FONTE&mon01.,'D','1'); SAS does not assumes the macro variable that is on the left side of the equality.   How can I solve this? ... View more

Hi,   Have the following problem, I want to identify the first and the last missing values in a row. Take as an example the following code:   data example; input id var1 var2 var3 var4 var5 var6 var7 var8 var9 var10 var11 var12; cards; A 1 2 3 . . . . . 1 1 1 3 B 3 3 2 1 3 2 1 . . . . . C . . . . 1 2 3 1 2 3 2 . D 3 . 1 . 3 . 1 . 3 . 1 . F 1 3 . . 1 3 . . 1 3 . . E 3 2 1 . . . . . 1 1 1 3 G 3 3 2 1 3 2 1 . . . . . H . . . . . 1 2 3 1 2 3 2 I 3 . 1 . 3 . 1 . 3 . 1 . J A E . . A E . . A E . . ; In row A the first is var4 and the last var8   In row D the first is var2 and the last is var12   Thank you. ... View more

I want to define a variable which it assumes a value if at least two of six variables assume a value 1.   If it were only one variable the code should be this one:   FORMAT GE1 $1.; IF QI020=1 OR QI021=1 OR QI022=1 OR QI023=1 OR QI024=1 OR QI027=1 THEN GE1=1; Which code should I write for as least two options validated?   Thank you for your help. ... View more

Hi,   Have the following problem, I want to count the number of successive missing values in a row, only in specific lines, also I want to know when the missing values occur at the beginning or at the end of the sequence. Take as an example the following code: data example; input id var1 var2 var3 var4 var5 var6 var7 var8 var9 var10 var11 var12; cards; A 1 2 3 . . . . . 1 1 1 3 B 3 3 2 1 3 2 1 . . . . . C . . . . 1 2 3 1 2 3 2 . D 3 . 1 . 3 . 1 . 3 . 1 . F 1 3 . . 1 3 . . 1 3 . . E 3 2 1 . . . . . 1 1 1 3 G 3 3 2 1 3 2 1 . . . . . H . . . . . 1 2 3 1 2 3 2 I 3 . 1 . 3 . 1 . 3 . 1 . J A E . . A E . . A E . . ; In particular, I want to know the successive missing values in B,C,G and F.   Thank you ... View more