Hi Kurt, Thank you for your quick response! I was not able to upload the file to the existing post. Kindly find the attachment in the below post. https://communities.sas.com/t5/SAS-Programming/To-import-an-Excel-file-into-SAS-with-column-headers-on-more/m-p/804730#U804730 Thank you for your time and guidance!! ... View more

Hi All,   Please accept my Sincere Apologies for posting the same question again. I missed the attachment in my previous post and I'm not sure how to add an attachment to the existing post (https://communities.sas.com/t5/SAS-Programming/Import-an-excel-sheet-which-has-the-column-header-on-two-rows/m-p/804672/emcs_t/S2h8ZW1haWx8dG9waWNfc3Vic2NyaXB0aW9ufEwxQlFPV0dXOEkyQURCfDgwNDY3MnxTVUJTQ1JJUFRJT05TfGhL#M316904).   I'm trying to read an excel file into SAS which has headers on two rows, I tried using the solutions provided here but I was not able to get the desired output. I thought of reading the .xlsx file twice and assigning the variable names to the merged columns in excel but later realized that the excel sheet/dataset keeps growing for the upcoming months or years. I also tried to transpose after importing the .xlsx file with GETNAME = NO OPTION.   The transpose results. Variable Name Variable Type C 2 E 2 F 2 G 2 GRAND TOTAL 1 H 2 I 2 J 2 K 2 L 2 M 2 N 2 O 2 PROGRAM_TYPE 2 PRODUCT_TYPE 2 R 2 S 2 T 2 U 2 V 2 W 2 X 2 Y 2 _2020 2 _2021 2   Please find the excel attached, Kindly Suggest.   ... View more

The transpose results. Variable Name Variable Type C 2 E 2 F 2 G 2 GRAND TOTAL 1 H 2 I 2 J 2 K 2 L 2 M 2 N 2 O 2 PROGRAM_TYPE 2 PRODUCT_TYPE 2 R 2 S 2 T 2 U 2 V 2 W 2 X 2 Y 2 _2020 2 _2021 2 ... View more

Hi Kurt, Thank you!! The Code works and is generating the report. Regards, Santosh ... View more

Hi Kurt, Thank you for your quick response! We need to use the Mean(Average) of Tr_Amt to compute the LTD column. Thanks ... View more

Hi Kurt, Thank you for your quick response! Since I was not able to upload a new attachment, I am posting the report and the dataset structure below. The below data set is the source - 2 datasets (Temp and Temp1). data TEMP; input grp_cnts Count_grp_cnts Tr_Amt Tdate ; datalines; 2 45 21000 200910 12 15 51000 200910 11 545 1000 200910 03 248 5000 200910 ; run; DATASET = TEMP1 Tdate Tr_Amt  grp_cnts Count_grp_cnts  200910 21000 2 45 200910 51000 12 15 200910 1000 11 545 200910 5000 3 248 The report/dataset should look something like this. Tdate= for the reporting month Tr_Amt = Average of Tr_Amt for the Reporting Month STD_TRNS_AMTS = STDEV of the Average of the Tr Amt for the reporting month. Count_grp_cnts= Sum of the group counts for the reporting month LMT is calcluated: LMT = Tr_Amt + 5 * STD_TRNS_AMTS Tdate Tr_Amt  STD_TRNS_AMTS Count_grp_cnts Tr_Amt  LMT 200910 19500 19665.96044 853 xxxxxxx Thank you for your Time and Help!! ... View more

Hi All,   I m trying to create a Report using Proc Report by creating computed columns. I m getting another ERROR: You can only BREAK on GROUPing and ORDERing variables.   kindly suggest.         ... View more

Thank you for the suggestion!! It worked ... View more