Hi SAS guys,   I run  into a problem. When I use ods excelxp to output my table to xml file, the file name can not be resovled. Here is part of my code: ........... ODS noresults; ODS listing close; /*Turn off the standard line printer destination*/ ods tagsets.ExcelXP path="&dir./&&examdegree&i." file="&&abexamd&i._&&degree&k._&mon..xml" style=seaside /*Styles to control appearance of output*/; ods tagsets.ExcelXP options ( sheet_name= "Directory" embedded_titles='yes' autofit_height= 'yes' frozen_headers= '1' autofilter= 'yes' frozen_rowheaders="2" absolute_column_width= '20,20,4,4,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8'); options missing=" "; title j=l "&&examdegree&i. "; title1 j=l "Breakout: &&degree&k."; title2 j=l "Reporting Window: &mon."; proc Report data=uall NOWD style(header)=[foreground=white background=CX4D7EBF]; Column form summary roster; define form /Center display "Form Name"; define summary / center display "Summary"; define roster / center display "Roster" ; compute form; row+1; if (mod(row,2)) then do; call define(_row_,"style","style=[background=CXECEDEC]"); end; endcomp; run;   the log window shows: WARNING: Apparent symbolic reference ABEXAMD1_ not resolved. WARNING: Apparent symbolic reference DEGREE3_2017_08 not resolved. NOTE: Writing TAGSETS.EXCELXP Body file: &abexamd1_&degree3_2017_08.xml NOTE: This is the Excel XP tagset (Compatible with SAS 9.1.3 and above, v1.130, 05/01/2011). Add options(doc='help') to the ods statement for more information.   Those &&abexamd&i. and &&degree&k. have values when I use %put &&abexamd&i. &&degree&k.  command. The titles which have macro values are resolved. Thanks,     ... View more

Hello, I have a string of characters and I need those values in parentheses.  data title; input title $20.; datalines; National Geography (NG) Time (T) National Food and Energy Council (NFC) Food and Drug Administration (FDA) National Hockey League (NHL) National Football League (NFL) ; run; The results I want are:  NG T NFC NHL NFL Thanks for the help! ... View more

Hello SAS guys, I have data like below, the want data did not  give me  second response empty of id 123 and sixth response empty of id 456. How do I get the right answer? Thanks a lot!   data have ; length id $3 response $15 ; input id response ; datalines ; 123 A||B|C|D|A|C 456 A|A|C|D|B||C ; run ; data want; set have; cnt=countw(response,'|'); i=1; do while (i<cnt); resp=scan(response,i,'|'); output; i=i+1; end; drop response; rename resp=response; run;   the output is  123 A 123 B 123 C 123 D 123 A 456 A 456 A 456 C 456 D 456 B But I need : 123  A 123     123 B 123 C ..... ... View more

Hello, I have a csv file:   Id      questionid                                              response                           answerkey                             grade    123     q123|q234|q345|q456|q678|q789        A|B|C|D|A|B                      A|B|C|D|C|B                           Pass ...... ......   I want the dataset like: Id               questionid                            response                  answerkey                    grade 123            q123                                      A                                   A                               Pass 123            q234                                      B                                   B                               Pass 123            q345                                      C                                   C                              Pass ...... .....   Please help me out! I appreciate any help! ... View more