Good afternoon.   I am working in EG version 6.1. I have a sas dataset with a numeric key and multiple numeric variables (8). What I need to do is to rank them by highest variable value ranked as number 1, second highest as number 2, etc. In the case of a tie I need both tied scores to have the same value i.e. highest ranked as number one, first variable tie also ranked as number 1, second highest value ranked as number 2, etc. All ranking must be within each observation, not ranked over the entire dataset. So all ranking would be within observation 1 for observation 1, all ranking for observation 2 would be within observation 2, etc.   I would really appreciate any help anyone could give me.   Thanks in advance.   Jeff   HAVE                   KEY VAR1 VAR2 VAR3 VAR4 VAR5 VAR6 VAR7 VAR8   1 1 2 4 4 4 9 9 7   2 1 2 3 4 5 6 7 8   3 7 8 9 9 6 5 5 4   4 4 9 9 7 7 8 5 1                       WANT 1                   KEY VAR1 VAR2 VAR3 VAR4 VAR5 VAR6 VAR7 VAR8   1 6 5 3 3 3 1 1 2   2 8 7 6 5 4 3 2 1   3 3 2 1 1 4 5 5 6   4 5 1 1 3 3 2 4 6                       ALTERNATIVE                 KEY VAR1 VAR2 VAR3 VAR4 VAR5 VAR6 VAR7 VAR8 RANK 1 1 2 4 4 3 8 9 7 VAR6;VAR7; VAR8 2 1 2 3 4 5 6 7 8 VAR7; VAR8 3 7 8 9 9 6 5 5 4 VAR3; VAR4 4 4 9 9 7 7 8 5 1 VAR2; VAR3 ... View more

I hope someone can give me an assist here. I have text data in one variable that varies in length. The field begins with a name and contains the word "ZIP" somewhere in the string. I need to find the occurrence of "ZIP" and remove all text after that occurrence to the end of the string. Is there anyone who could point me in the right direction? Thank you very much. Data Have John M. Smith ZIP 99999 any town any city Mary M. Smith any town any city ZIP 88888 some other text Bill Murray title book ZIP Data Want: John M. Smith Mary M. Smith Bill Murray ... View more

Good morning. I was wondering if anyone has come up with a solution to this problem? When I run the code below I get a "style" error when I try to open the file. When I look to the log file I get the following error. I've been going over this code for awhile but see nothing different from other code I run that seems to work. I would so appreciate any insights anyone might have regarding this problem. Thank you very much. XML ERROR in Style REASON: Too many tags FILE: C:\Users\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\IFESGBSK\MH3_assigned_special_housing 04MAY15.xls GROUP: Styles TAG: Style ATTRIB: ID VALUE: NoteContent11 title1; title2; title3; footnote1; odslisting close; ods tagsets.ExcelXP file"F:\sasdata\attachments\FILENAME_&SYSDATE..xls"style=SASDocPrinter       style(REPORT)={cellpadding=5 background=#D0C7A8}       style(COLUMN)={font_face=Arial font_size=1 background=white}       style(HEADER)={font_face=Arial font_size=1 font_weight=bold foreground=black background=#EBE8DA};       column facility idno namel namef unitno cellno moveindt moveoutdt dsu asu imu bhu condition_code condition_type condition_description dd3need count;       define facility / group 'Inst';       define idno / 'SID';       define namel / 'Last Name';       define namef / 'First Name';       define unitno / 'Unit';       define cellno / 'Cell';       define moveindt / 'In Date';       define moveoutdt / 'Out Date';       define dsu / 'DSU';       define asu / 'ASU';       define imu / 'IMU';       define bhu / 'BHU';       define condition_code / 'BHS Code';       define condition_type / 'BHS Type';       define condition_description / 'BHS Description';       define dd3need / 'DD3';       define count / 'Count' noprint;     compute after facility / style=[font_face=Arial font_weight=bold font_size=1 foreground=black background=#DCD6BE];         line count.sum comma5. ' Inmate(s)';         line ' ';     endcomp;     compute after;         line count.sum comma5. ' People';     endcomp; run; ods tagsets.ExcelXP close; ods listing; ... View more