I have a csv file (attached) it has two different reports within it, one report named "TM Rule to SAR KPI Report" the other  named "TM Condition to SAR KPI Report", the headers are right after their names in the csv. I'm trying to split these out to two different datasets. I'm stuck on how to tell it to read the first part until it gets to a blank row or next report. I'm just getting blank tables. any help would be appreciated DATA WORK.tm_rule_to_sar_kpi tm_condition_to_sar_kpi; LENGTH Rule_Name $ 20 Total_Incident_from_Rule 8 Total_Alert_from_Rule 8 Total_Alert_Closed_WO_Case_Rule 8 Total_Alert_Closed_W_Case_Rule 8 Total_Case_Closed_WO_SAR_Rule 8 Total_Case_Closed_W_SAR_Rule 8 Total_Alert_to_Case_Pct_Rule 8 Total_Case_to_SAR_Pct_Rule 8 Total_Alert_to_SAR_Pct_Rule 8 Condition_ID $ 50 Severity $ 10 Incident_from_Condition 8 Alert_from_Condition 8 Alerts_Closed_WO_Case_Condition 8 Alerts_Closed_W_Case_Condition 8 Case_Closed_WO_SAR_Condition 8 Case_Closed_W_SAR_Condition 8 Alert_to_Case_Pct_Condition 8 Case_to_SAR_Pct_Condition 8 Alert_to_SAR_Pct_Condition 8; LABEL Rule_Name = "Rule Name" Total_Incident_from_Rule = "Total Incident from Rule" Total_Alert_from_Rule = "Total Alert from Rule" Total_Alert_Closed_WO_Case_Rule = "Total Alerts Closed w/o Case from Rule" Total_Alert_Closed_W_Case_Rule = "Total Alerts Closed w/ Case from Rule" Total_Case_Closed_WO_SAR_Rule = "Total Case Closed w/o SAR from Rule" Total_Case_Closed_W_SAR_Rule = "Total Case Closed w/ SAR from Rule" Total_Alert_to_Case_Pct_Rule = "Total Alert to Case % from Rule" Total_Case_to_SAR_Pct_Rule = "Total Case to SAR % from Rule" Total_Alert_to_SAR_Pct_Rule = "Total Alert to SAR % from Rule" Condition_ID = "Condition ID" Incident_from_Condition = "Incident from Condition" Alert_from_Condition = "Alert from Condition" Alerts_Closed_WO_Case_Condition = "Alerts Closed w/o Case from Condition" Alerts_Closed_W_Case_Condition = "Alerts Closed w/ Case from Condition" Case_Closed_WO_SAR_Condition = "Case Closed w/o SAR from Condition" Case_Closed_W_SAR_Condition = "Case Closed w/ SAR from Condition" Alert_to_Case_Pct_Condition = "Alert to Case % from Condition" Case_to_SAR_Pct_Condition = "Case to SAR % from Condition" Alert_to_SAR_Pct_Condition = "Alert to SAR % from Condition"; FORMAT Rule_Name $CHAR20. Total_Incident_from_Rule BEST5. Total_Alert_from_Rule BEST5. Total_Alert_Closed_WO_Case_Rule BEST5. Total_Alert_Closed_W_Case_Rule BEST5. Total_Case_Closed_WO_SAR_Rule BEST5. Total_Case_Closed_W_SAR_Rule BEST5. Total_Alert_to_Case_Pct_Rule BEST5. Total_Case_to_SAR_Pct_Rule BEST5. Total_Alert_to_SAR_Pct_Rule BEST5. Condition_ID $CHAR50. Severity $CHAR10. Incident_from_Condition BEST5. Alert_from_Condition BEST5. Alerts_Closed_WO_Case_Condition BEST5. Alerts_Closed_W_Case_Condition BEST5. Case_Closed_WO_SAR_Condition BEST5. Case_Closed_W_SAR_Condition BEST5. Alert_to_Case_Pct_Condition BEST5. Case_to_SAR_Pct_Condition BEST5. Alert_to_SAR_Pct_Condition BEST5.; INFILE 'R:\BSA Department\10. Systems (Prod)\Actimize\Prod Alert tracking\Actimize reports\2022\tm_rule_and_condition_to_sar_kpi_report_10012022-10012022.csv' LRECL=32767 ENCODING="WLATIN1" DLM='2c'x; input reportsplit $3. @; if reportsplit = "TM R" then do; do until (Rule_Name = ""); INPUT Rule_Name : $CHAR20. Total_Incident_from_Rule : ?? BEST5. Total_Alert_from_Rule : ?? BEST5. Total_Alert_Closed_WO_Case_Rule : ?? BEST5. Total_Alert_Closed_W_Case_Rule : ?? BEST5. Total_Case_Closed_WO_SAR_Rule : ?? BEST5. Total_Case_Closed_W_SAR_Rule : ?? BEST5. Total_Alert_to_Case_Pct_Rule : ?? BEST5. Total_Case_to_SAR_Pct_Rule : ?? BEST5. Total_Alert_to_SAR_Pct_Rule : ?? BEST5. ; output tm_rule_to_sar_kpi; end; end; else if reportsplit = "TM C" then do; do until (Rule_Name = ""); INPUT Rule_Name : $CHAR20. Condition_ID : $CHAR50. Severity : $CHAR10. Incident_from_Condition : ?? BEST5. Alert_from_Condition : ?? BEST5. Total_Alert_from_Rule : ?? BEST5. Alerts_Closed_WO_Case_Condition : ?? BEST5. Total_Alert_Closed_WO_Case_Rule : ?? BEST5. Alerts_Closed_W_Case_Condition : ?? BEST5. Total_Alert_Closed_W_Case_Rule : ?? BEST5. Case_Closed_WO_SAR_Condition : ?? BEST5. Total_Case_Closed_WO_SAR_Rule : ?? BEST5. Case_Closed_W_SAR_Condition : ?? BEST5. Total_Case_Closed_W_SAR_Rule : ?? BEST5. Alert_to_Case_Pct_Condition : ?? BEST5. Total_Alert_to_Case_Pct_Rule : ?? BEST5. Case_to_SAR_Pct_Condition : ?? BEST5. Total_Case_to_SAR_Pct_Rule : ?? BEST5. Alert_to_SAR_Pct_Condition : ?? BEST5. Total_Alert_to_SAR_Pct_Rule : ?? BEST5. ; output tm_condition_to_sar_kpi; end; end; RUN; ... View more

My situation is similar but the output needs to be rows. All my data is in one giant line where each value is separated by comma, and I should only have one column of data, where each of these are rows. Also my one line is extremely long greater than 32K+ in length.    ["T_283_20220605_73_283A0000006757_830010", "T_283_20220605_75_283A0000012029_830010", "T_283_20220605_77_283A0000017945_Ach_OPull", "T_283_20220605_79_283A0000011229_Ach_OPull"]   How to get it to transpose when i import it:   ColumnA T_283_20220605_73_283A0000006757_830010 T_283_20220605_75_283A0000012029_830010 T_283_20220605_77_283A0000017945_Ach_OPull T_283_20220605_79_283A0000011229_Ach_OPull   Attached is full sample. ... View more