Hey there, Yeah. I mean export. Thanks for your help. Got it and it works! Please keep safe. ... View more

Hi, Yes. Thank  you so much. Sorry for if i made some confusions with regards to my previous posts.   ... View more

Hi, Oh I see. Thank you. By the way, is there a way to import such report in an excel format? I am very much overwhelmed because of the fast response I am getting here. Thank you very much. Sorry if I made some confusions with regards to my previous posts. Keep safe. ... View more

Hi, Sorry for that. data Test; input ID Name _01 _02 _03 _04 _05 _06 _07 _08 _09 _10 _11 _12; cards; 1 a 10 1 2 3 1 4 5 4 5 1 5 1 2 b 12 3 3 4 5 6 5 4 6 5 4 2 3 c 2 2 1 3 1 3 4 5 2 3 5 3 ; Is there a way that I can add label which is the year (2021) on top of the months? Thank you.   maricelj ... View more

Hi, Sorry if it's kind of confusing. I just can't add a table here so I made such presentation which seemed to be a report. Actually, it's not yet a report instead, it's a dataset. It's a table and I want the column headers be like that, if it's possible. My report is in excel format which such table is being called through a macro. Thank you. ... View more

Hi, Thank you. The code goes like this: PROC SQL; CREATE TABLE Test AS SELECT DISTINCT ID as ID, Name TRANS_MONTH FROM Transaction WHERE year = '2021' ORDER BY ID; QUIT;   I want the output to have a year above each trans_month but such year should appear only once and no idea how to do it. PROC SQL; CREATE TABLE Test AS SELECT DISTINCT ID, Name TRANS_MONTH FROM Transaction WHERE year = '2021' ORDER BY ID; QUIT; Output be like this: ID | NAME | YEAR 2021 | | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 10 | 11 | 12 Thank you. Thank you. ... View more

CrizNZ, Thank you so much. It works. Have a great day and keep safe.   ... View more

Hi ChrisNZ, Thank you for the help. May I just request another thing. Sorry I am really a newbie here. The code is working, it's just that I am having trouble for some months with duplicates and are under the same name. How can I eliminate those duplicates based on file attachments? *The latest date will be retained. The attachment is concatenated with filename, month, day and time. Something like this: data HAVE; input NAME $ TRANS_MONTH $ FILE_ATTACH $; cards; A 01 QQQFEB2207:54 A 01 QQQFEB2002:54 A 04 DDDMAR0112:01 B 01 DDDJAN1807:00 B 05 YYYSEP0111:10 B 05 GGGOCT1108:21 ; The output should be something like this: Obs NAME MTH01 MTH02 MTH03 MTH04 MTH05 MTH06 MTH07 MTH08 MTH09 MTH10 MTH11 MTH12  1 A QQQFEB2207:54 X X DDDMAR0112:01 X X X X X X X X  2 B DDDJAN1807:00 X X X GGG1108:21 X X X X X X X Thank you so much and have a great day ahead. maricelj   ... View more

Hi, Thank you for this. Will try to give you feedback as soon as possible. Keep safe and have a great day ahead. ... View more