Hi folks, I ran into a situation where I need to extract 4-digit numbers from a string. The location of these numbers varies and sometimes there would also be 3-digit or 5-digit numbers along with (sometimes without) 4-digit number. Once extracted, these number needs to be separated by a delimiter like comma (,). Example: - Original data DATA ALPHA(124) BETA (5678) CHARLIE(9012) DELTA(3456)    Data after extracting numbers and separated by delimiter like comma. DATA CLEANED_DATA ALPHA(124) BETA(5678) CHARLIE(9012) DELTA(3456) 5678, 9012, 3456   As you see in the above example the 4-digit numbers in DATA string are extracted to CLEANED_DATA variable and are separated by comma delimiter. It would be great if you could help me with this.   Thanks in advance, Banana19 ... View more

Hi All, I'm looking for a solution where multiple tables are loaded one below the other dynamically. Here is an Output example; Attached is the code I used ODS EXCEL FILE = "&LOCATION/ODS_TEST1.XLSX"; ODS EXCEL OPTIONS( SHEET_INTERVAL = "NONE" START_AT = "2,2" EMBEDDED_TITLES = "NO" SHEET_LABEL = "NA" SHEET_NAME = "NA" ABSOLUTE_ROW_HEIGHT = "15" ZOOM = "100"); PROC REPORT DATA=WORK.TEMP NOWD; COLUMN ('TABLE1'(COLUMN_A COLUMN_B COLUMN_C)); DEFINE COLUMN_A / "COLUMN_A"; DEFINE COLUMN_B / "COLUMN_B"; DEFINE COLUMN_C / "COLUMN_C"; RUN; ODS EXCEL OPTIONS( SHEET_INTERVAL = "NONE" START_AT = "2,10" EMBEDDED_TITLES = "NO" SHEET_LABEL = "NA" SHEET_NAME = "NA" ABSOLUTE_ROW_HEIGHT = "15" ZOOM = "100"); PROC REPORT DATA=WORK.TEMP2 NOWD; COLUMN ('TABLE2'(COLUMN_A COLUMN_B COLUMN_C)); DEFINE COLUMN_A / "COLUMN_A"; DEFINE COLUMN_B / "COLUMN_B"; DEFINE COLUMN_C / "COLUMN_C"; RUN; ODS EXCEL CLOSE; In the above code there are only 2 proc reports. As shown in O/P example, I have 4 different datasets and I only want to use the mentioned 2 proc report  codes to generate 4 different tables one below the other dynamically without adding more proc reports. It would be good if some one could help me with this issue and let me know if you need anything else.   Thanks, BD   ... View more

Hi All - As the subject line says I've come across a scenario where I need to cross check variables from 2 different tables based on a condition. I wrote a case when expression but I do not think it works. Below is the example of logic I'm trying to use.   CASE WHEN (COMPRESS(A.Account_Number)=COMPRESS(B.Account_Number)) AND A.name NOT IN B.name THEN '1' END AS FLAG   In the above example, when Table A account number equals to Table B account number then the name variable present in table A should cross check against name variable of table B for that particular account number. If the name variable in Table A is not present in name variable of Table B for that particular account then I'm creating a flag. This needs to performed for when ever both tables account numbers match.   It would be great if you could help me in this issue.   Thanks, SD ... View more

Hi All - As the subject line says I was trying to figure out a way to automate the following scenario. I have a SAS dataset and I wanted to automatically send the data to SP to create a SP list. Is this possible? I'm currently exporting the SAS dataset to an excel and changing the format to a tabular format and manually uploading it to SP site to create a SP list. I've seen couple of documents but these documents say that dataset can be stored in a SP site  as an XLSX file. Thanks in advance!   Thank you, RD ... View more