On my side your code works also if I write data _null_... but it is not a problem on the reason...I think my brain works in a way more different than SAS, anyway I couldn't understand the reason... many thanks ... View more

Here you are what my file contains: I tahke it from the log running data _null_;    infile "my.csv" ;    input;    list; run; RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+---- 1   CHAR  AAAAA:.BBBBBB.CCCCCCC.2/2/2014.. 32     ZONE  44444304444440444444403232333300     NUMR  11111A92222229333333392F2F20149D the code you before provided me works, I mean I can get the date but I lost the other fields contained in the line. The initial gol was easly (how happen in the other language ) read the complete line. But I will split my goal in two steps, read the first three fields and than the last one using your code... Many thanks! ... View more

HI Tom, Thanks for you almost  useful reply. I replaced MISSOVER with TRUNCOVER but never changed. I also confirm that a Carriage Return is present at the end of the line but adding the option TERMSTR=CRLF to infile statement haven't changed so much: it still doesn't work. To be honest I'm quite new in SAS, but some things that with some other language we can do in few minutes with SAS we need a lot of time and a lot of tries to make it working....also if you ask to very SAS expert...it seems that there isn't logical way to get the things working, only try and try and try... ... View more

I think I've not clearly explained my goal. My goal is write, using a call execute, an if instruction where I have to check if a char variable is missing, I mean I have to write if mycharvar eq '' then bla bla bla; using a call execute. I mean, I have to write call execute ('if myvariable eq '' then do;'); but whit I don't know how manage the quote... What my dataset contains is not relevant...my problem is "how write the call execute...I hope is more clear now... Anyway a solution should be, wiht a datastep before to run the call execute, create another variable in the input dataset that is equals to 0 if myvariable is missing or 1 if not, something like this; data input2; set input1; if myvariable eq '' then myvariablenum = 0; else  myvariablenum = 1; run; and then I run the original code: data _null_;    set myinput end=last;    if _n_=1 then do;       call execute('data myoutput;');       call execute('set myinput;')    end;    call execute ('if myvariablenum = 0 then do;'); .....    call execute ('end; /* myvariable missing end */');    if last then do;       call execute('run;');    end; run; ... View more