PROC SUMMARY works well with formatted values....   data temp; set sashelp.cars; format region z2.; if origin='Asia' then region=1; else if origin='Europe' then region=2; else if origin='USA' then region=3; run; proc summary data=temp nway; class make region; output out=temp1; run; proc print data=temp1;run;     The SAS System   Obs Make region _TYPE_ _FREQ_ 1 Acura 01 3 7 2 Audi 02 3 19 3 BMW 02 3 20 4 Buick 03 3 9 5 Cadillac 03 3 8 6 Chevrolet 03 3 27 7 Chrysler 03 3 15 8 Dodge 03 3 13 9 Ford 03 3 23 10 GMC 03 3 8 11 Honda 01 3 17 12 Hummer 03 3 1 13 Hyundai 01 3 12 14 Infiniti 01 3 8 15 Isuzu 01 3 2 16 Jaguar 02 3 12 17 Jeep 03 3 3 18 Kia 01 3 11 19 Land Rover 02 3 3 20 Lexus 01 3 11 21 Lincoln 03 3 9 22 MINI 02 3 2 23 Mazda 01 3 11 24 Mercedes-Benz 02 3 26 25 Mercury 03 3 9 26 Mitsubishi 01 3 13 27 Nissan 01 3 17 28 Oldsmobile 03 3 3 29 Pontiac 03 3 11 30 Porsche 02 3 7 31 Saab 02 3 7 32 Saturn 03 3 8 33 Scion 01 3 2 34 Subaru 01 3 11 35 Suzuki 01 3 8 36 Toyota 01 3 28 37 Volkswagen 02 3 15 38 Volvo 02 3 12   ... View more

  I would hitchhike all the way down from Canada!!! ... View more

I'm taking the latest flight I can, so I can take in as many sessions as possible! ... View more

>From the UK we don't need a VISA for travel to the USA or Canada, but for the USA we need an ESTA... and for Canada we need a Work Permit .... I haven't worked in the USA, so I'm not sure what the arrangements are... All sorts of strange "agencies" have sprung up around the ESTA, which charge additional fees which you don't need to pay.... So anyone getting an ESTA should check they are going through the official site, and only paying the minimal fee required.... ... View more