In your example 2.333......333 is the unformatted (underlying) value in Excel, which is what SAS reads and imports.  You can apply a SAS format such as 16.1 or comma20.1 after the import to achieve what you want. The standard import procedure in SAS does not carry across the format applied in Excel, although in the case of dates SAS uses the Excel format to identify the value as a date, import it and adjust the base date and apply a SAS date format which might or might not look similar to the Excel format. You might be able to achieve what you want by exporting the data as a text file (CSV or tab delimited) and importing that into SAS. Richard ... View more

I was looking for a button marked "Correct" to press, but I couldn't find any. ... View more

Often the order of variables does not matter, but I recently wrote an article about reordering variables according to a value of a statistic (mean, median, variance,...). Yes, I used the RETAIN statement. For details, see Order variables by values of a statistic - The DO Loop ... View more

Although you have multiple solutions based on above responses. Just to make sure, you are not trying to do this using point option right? ... View more

You do it in a data step. data lookup; do year = 2000 to 2013; output; end; run; data nr_of_ind2; merge   nr_of_ind (in=in_noi)   lookup ; by year; if not in_noi then noi = 0; run; ... View more

EASY FOR SQL. data have;    input id $ month quantitiy;    cards; a 2 11 a 7 12 b 10 11 b 4 9 ;;;;    run; data m; do month=1 to 12;   output; end; run; proc sql; create table temp as select * from      (select distinct id from have) as a,m; create table want as select temp.*,have.quantitiy   from have right join  temp on temp.id=have.id and temp.month=have.month; quit; Xia Keshan ... View more

true...unless there may be IDs in table B that you don't want counted...or if you needed other attributes on table A that weren't included in B....(assumes facts not in evidence). ... View more

I agree with Jaap Karman too. Reusing the same data set name throughout your program can also make it harder for anyone else to pick up your code and understand the data flows and what the program is trying to acheive. ... View more

What about using an update statement instead? ... View more

I don't see why not. Since EG is largely server based, so you do need to be aware of some differences. Mainly to make sure that the machine where your EG is running do have Excel running, and that could be problem if you don't have server version of MS office installed and/or you don't have PC SAS which supports local session for your EG. Other than that, it shouldn't be a problem. Putting the doable issue aside, AS mentioned you should also consider migrating to excelxp tagsets, where you can have most if not all the excel formats, macros in a more robust way. Haikuo ... View more

....and in case you wish to avoid sorting: data given; input  ID TRANS_DATE : yymmdd10.; datalines; 1 2012-07-01 1 2010-08-07 1 2012-07-01 2 2010-10-01 2 2010-10-01 2 2011-06-01 2 2011-06-01 3 2012-07-05 3 2012-09-07 3 2012-05-09 ; run; data solved(drop=rc);      if(1=2) then set given;      declare hash sv(ordered:"a");      sv.defineKey("id","trans_date");      sv.defineDone();      do until(done);           set given end=done;           rc=sv.check();           if rc=0 then output;           rc=sv.replace();      end;      format trans_date yymmdd10.;      stop; run; ... View more