Hello Experts Dataset "a" created below is extracted from a log file In the data "b", I want to pull out the information about tables after t_table_list, using regular expression. How do I write the regular expression in data step "b" when the tables' name are displayed in multiple lines? There are thousands of log files, each can has more or less tables than the example provided below. I want to write a universal regular expression that allows me to extract  tables for all the log files. for example, in log file 1, there is only 1 table after t_table_list . But in log file2, there could be 100 tables. So I need the regular expression as flexible as possible. data a; length line $500; infile cards dlm="*" truncover; input line $150.; cards; 87         %check (t_table_list=CUTP_TPCR_PIMS 88                 CUTP_CTP_CUTG 89                 CUTP_TPCR_PIM 90                 CUTP_TPCR_PIMQ 91                 CUTP_CTP_CUT 92                 CUTP_CTP_CUT_C 93                 CUTP_CTP_CUTN 94                 CUTP_CTP_CUAD 95                 CUTP_CTP_CUTC 96                 CUTP_TPCR_PIML, 97                l_file_list=, 98                s_file_list= 99         ) run;     data b;       set a;        array rearr {*} regex1;        array posarr {*} pos1;        array colarr {*} check;        keep line check ;        dimm=1;         if _n_=1 then do;   rearr{1}=prxparse("/.*check\s*.*t_table_list=(.*)/i");          end;        retain regex1;         do i=1 to dimm;          posarr{i}=prxmatch(rearr{i},line);            if prxmatch(rearr{i}, line) then do;            wf=prxparen(rearr{i});              call prxposn(rearr{i},wf,posarr{i},len);              colarr{i}=substr(line,posarr{i},len);            end;             output;    end; run; Thanks ... View more

Hello experts, Can someone tell me why the metacharacter \n is not working for the program belw data a; infile cards truncover; length a $1; input a $150.; cards; a b run; data b; set a; e=prxmatch("/a\nb",a); run; Thanks ... View more

Hello expert, The following program will produce a xml output which can be opened by excel. When you open the xml output in excel, it has two tabs, "a" and "b". Within "b" tab, it has three column, "c", "d", "e" My question is how do I conceal the content of column "e" so It doesn't  go beyond the boundary of column e.(I have tried wraptext="No" but it didn't work, it seem the previous wraptext="yes" has override the subsequent one) or how do I expand the row height (have tried row_height option but still not work). data a; length a $500 b$500; a="sdakfasdfgsdfgsdfgdfgsdfgsdfsdfgdfgafgasdfgsdfasd.jadfklhlagjsdklfnasdklnklfnklgnklsdngalsdbnglasdgasod"; b="asdskdfahklasdjklfjasdlsdfhsdgfjsadjkfhasdjklfhjkasdhfjkhasdjkfhjkasdhfjksdkfjasjkfhsdkajfsdafhasdjkfhasdgfasdgfhasdfgasdgfgsdhfjgasdjkf"; run; data b; length c $500 d $500 e $500; c="asdskdfahklasdjklfjasdlsdfhsdgfjsadjkfhasdjklfhjkasdhfjkhasdjkfhjkasdhfjksdkfjasjkfhsdkajfsdafhasdjkfhasdgfasdgfhasdfgasdgfgsdhfjgasdjkf"; d="asdskdfahklasdjklfjasdlsdfhsdgfjsadjkfhasdjklfhjkasdhfjkhasdjkfhjkasdhfjksdkfjasjkfhsdkajfsdafhasdjkfhasdgfasdgfhasdfgasdgfgsdhfjgasdjkf"; e="asdskdfahklasdjklfjasdlsdfhsdgfjsadjkfhasdjklfhjkasdhfjkhasdjkfhjkasdhfjksdkfjasjkfhsdkajfsdafhasdjkfhasdgfasdgfhasdfgasdgfgsdhfjgasdjkf"; run; ODS LISTING CLOSE; ODS TAGSETS.EXCELXP FILE="c:\a.xls"                               OPTIONS(SHEET_NAME='a' ABSOLUTE_COLUMN_WIDTH='18' AUTOFIT_HEIGHT="YES" WRAPTEXT="NO") style=Printer; proc report data=a nowd; run; ODS TAGSETS.EXCELXP OPTIONS(SHEET_NAME='b' ABSOLUTE_COLUMN_WIDTH='18' AUTOFIT_HEIGHT="YES" WRAPTEXT="YES") style=Printer; proc report data=b nowd; run; ods tagsets.ExcelXP close; Thanks ... View more

Hello expert, when I use ods tagset excelxp to produce xml file and opened in excel, if the last column (the first column at the right side) has a lot of content, then it will go beyond the column boundary. How do I conceal some of its content or expand it vertically like adjust the row height, I have tried wraptext="no" and row_height option but it didn't work. you can run the following sample code to see the issue to display column a: data a; length a $500; input a $; cards; asdskdfahklasdjklfjasdlsdfhsdgfjsadjkfhasdjklfhjkasdhfjkhasdjkfhjkasdhfjksdkfjasjkfhsdkajfsdafhasdjkfhasdgfasdgfhasdfgasdgfgsdhfjgasdjkf ; run; ODS LISTING CLOSE; ODS TAGSETS.EXCELXP FILE="c:/a.xls"                               OPTIONS(SHEET_NAME='a' ABSOLUTE_COLUMN_WIDTH='5' AUTOFIT_HEIGHT="YES" WRAPTEXT="NO" ) style=Printer; proc print data=a; run; ods tagsets.ExcelXP close; ... View more

Hello experts, how do I write a SAS code to identify any missing "Report" using the following data. The date interval for the weekly report is 7 days. for example, if the first report is on 01/01/2015 and second report is on 15/01/2015 then there is a report missing on 08/01/2015. the final output should only include the missing report's (report name, date, frequency) For monthly report, however the date interval for the monthly report is not exactly 30 days but for example if the first report and last report is on jan 2015 and may2015 then there must be one report every month between Jan2015 and May2015 , if for a particular month between Jan2015 and May2015, there is no report then the report is missing then I want to identify the report name, month and its frequency. Report              Date               Frequency a                    01/01/2015             weekly a                   15/01/2015              weekly a                    22/01/2015              weekly b                   03/02/2015               weekly b                    10/02/2015             weekly b                    17/01/2015             weekly c                    10/01/2015             monthly c                    12/02/2015             monthly c                    10/04/2015            monthly c                    12/05/2015           monthly ... .... many records ... View more

Hello experts, I tried to run the following program to produce xml output with two tabs in the excel. But it didn't work when I included "where" statement, ODS LISTING CLOSE;                                                                                                                                                                                       ODS tagsets.excelxp FILE="c:\example.xls"; ods tagsets.excelxp options(sheet_name="cars"); Proc print data=sashelp.cars; where origin="Europe"; Run; ods tagsets.excelxp options(sheet_name="class"); Proc print data=sashelp.class; where Sex="Male"; Run; ods tagsets.excelxp close; ods listing; Thanks ... View more

Hello Experts, I understand length statement is adding key items and data items defined in Hash object to the Program Data Vector so they can be treated as Data step variables so SAS can retrieve relevant records based on the key value and place it the corresponding DATA step variable in the PDV. My question is, in terms of  loading the hash object with the SAS data, does the length statement also help to build a link between hash key and data items and dataset variables that you want to load into the hash, in other words, SAS won't be able to load the hash object with the SAS data without length statement? ... View more