Hi to all, I have to use the proc summary with a lot of ID variables. How can I save the list of variables  in the macro variable? is there one way to have a macro variables with a list of variable of dataset  but without the list in the  VAR ? proc summary data = one      var a b;      id &listvariable.; in this macro variable, how can i put the list of variable of the data set one without the a,b variable  into the  VAR field? output = have; run; ... View more

Hi, Hi have this table: COD  FLAG 1          N 1          N 1          S 2          N 2          N 3          S 3          N; I need to create a new table with a new column (chk) that verify the variation of FLAG Variable in the same group of COD coloumn: if FLAG change in the same group of COD, the variable chk is set to 1 to all group of cod: here there is the example: COD  FLAG         CHK 1         N                   1 1         N                   1 1         S                   1 2         N                   0 2         N                   0 3         S                    1    3         N                    1 I create this sas code: data mytable;      retain _flag;      retain _chk 0;      set a;      by COD;      if first.cod then do; _flag = flag; chk=0; end;      else if _flag ne flag                then do;                _flag=flag;                chk = 1;            end; run; it works but i don't get the table that I need. how can I do that? ... View more

Hi, I use SAS 9.1, and I would like to move my sas log in an external file in. I use this code: filename mylog 'c:\.......\log.txt'; proc printto log = mylog new; run; Obviously it works, but If want to see the update of the file txt, I have always to close the file txt and re-open the file txt...and it's not comfortable... is there one way to see the update of the file log without close the file log and re-open? p.s. I use the program notepad of windows in order to see the file log. ... View more

Hi, I have a problem with left join inside the SAS merge: I have two table(I can't give you the real tables or the log files, becouse the policy of the enterprise where I'm working is very strictly 😞 table A: id     source     _a      _b 1     a               re     123 2     b               ba     53 3     a               ag     679 3     b               45      78 table B id     number 1     13 2     14 3     2 If I will make a left join with this SAS code: data C;          merge a(in=a)                 b(in=b);      by id;      if a;      if source = 'a' then number = . ; run; the data set has both of row 3 with the missing value, instead of just one(with the source = a); is there a logical mystake in the sas code(merge)? i ... View more

Hi, I have a problem to import this file csv with these column:(in a I have the point, while in b I have the comma) a          b                   1          1,048            356,8 3          6764 0.1       564 4          0,0019 1          0,0678 Obviously, I will have to do, some arithimetics operation between this coloumn and with other column from other table with COMMAX7.3 format. have you any idea how to build the input statment in a data step? ... View more

Hi, I have to convert a number with the format commax20.2 to the SAS number(I have this coloumn from other tables). I have also to convert SAS number to commax20.2. what should I have to do? Is there any functions that can help me? thanks. ... View more