I am not sure how to loop the macro values,  The below code i tried but it reads only first value in the macro.    data test; infile datalines; input part $ bldg $ area $ po $; datalines; A1 FR KIT XX1 A2 W KIT XX1 A3 FR LOIN XX4 C3 FR KIT XX6 ; run; proc sql; select part into: part_list from test; quit; proc sql; select bldg into: bldg_list from test; quit; proc sql; select area into: area_list from test; quit; proc sql; select po into: po_list from test; quit; %put &date.; OPTIONS EMAILSYS=SMTP EMAILHOST=intramail.cis.cat.com EMAILID="test@mail.com"; FILENAME BLAT EMAIL FROM = ( "test@mail.com" ) TO = ("rec@mail.com" ) SUBJECT = ("&subject.– &date") TYPE = "TEXT/HTML" ; DATA _NULL_; FILE BLAT; put "Team,<BR><BR>"; PUT "&part_list. is routed to &bldg_list. &area_list but does not have a coordinate on &po_list..Determine the correct coordinate and add it. <BR><BR>"; PUT " "; PUT "Regards,<BR><BR>"; RUN; ... View more

Here is the correct program, i have added one comma incorrecty. data test; infile datalines delimiter=','; ; length overall_summary grief_summary $50 ; input overall_summary $ grief_summary $ count_inv count_inv_unq ; datalines ; 100% GR completed, Part line GR completed, 154, 24, Not found in Invoice table, Not found in Invoice table, 48, 48 Partial GR done, GR data not available, 2011, 567 Partial GR done, GR qty greater than Invoice qty, 468,88 Partial GR done, IBD data not available, 570,89 Partial GR done, Part line GR completed, 281,90 Partial GR done, Partial GR done, 19,10 ; run; ... View more

Hi,    Here is the dummy program and the dataset   data test; infile datalines delimiter=','; ; length overall_summary grief_summary $50 ; input overall_summary $ grief_summary $ count_inv count_inv_unq ; datalines ; 100% GR completed Part line, GR completed, 154, 24, Not found in Invoice table, Not found in Invoice table, 48, 48 Partial GR done, GR data not available, 2011, 567 Partial GR done, GR qty greater than Invoice qty, 468,88 Partial GR done, IBD data not available, 570,89 Partial GR done, Part line GR completed, 281,90 Partial GR done, Partial GR done, 19,10 ; run;   the output i am expecting is attached below. Overall summary will have both group of Overall summary as well as Grief Summary     Overall_Summary count_inv count_uniq_inv 100% GR completed 154 24 Part line GR completed 154 24 Not found in Invoice table 48 48 Not found in Invoice table 48 48 Partial GR done 3314 563 GR data not available 1976 395 GR qty greater than Invoice qty 468 57 IBD data not available 570 91 Part line GR completed 281 12 Partial GR done 19 8 Grand Total 3516 635 ... View more

Thanks for your time, I have already added the pivot table in the initial, i need to report the same way ... View more

Thanks Cynthia; I understood that we cant directly import the images into SAS. The requirement is to import the PDF which has screenshots and load the screenshots into Azure. I think we should have to use VBA or other tools; Thanks for your time on this. ... View more

I understood that I am not able to read the image stored in the PDF file. Do we have any option if the PDF is having a table format data, can we import the PDF file into SAS? ... View more

I am able to view the tables in sas libraries, but using the pass through method, it is not working. ... View more

Thanks again. I have tried with CONNECT USING, but still i am not able to view the table. I just want to confirm if it is working for other tables which i can access from snowflake schema, for those also, ths code is not working. libname snow ODBC complete="driver=&sf_driver;uid=&sf_uid;pwd=&sf_pwd;server=&sf_server;database=&sf_database" schema=&sf_schema autocommit=no ; proc sql; connect using snow; select * from connection to snow (select * from table_name ); disconnect from snow; quit; I am getting the below error: ERROR: CLI prepare error: SQL compilation error: Object 'Table Name' does not exist or not authorized. Thanks again for your time and help. ... View more

Thanks for the reply. I have already tried this pass through method but i am getting the below error; ERROR: The SNOW engine cannot be found. ERROR: A Connection to the snow DBMS is not currently supported, or is not installed at your site. I have used libname to connect with snowflake table first and then using connect statement in PROC SQL to get the column names. Thanks ... View more