1)First read the pdf file as data file via excel, feeding the page which you need 2)This creates a tab in excel with structured data 3)then you can read in sas (Suitable for not many tables) ... View more

Is there a data set used to make that example data? That appears as if it may be a summary. There a times that desired report layouts are better done with raw data and not summarized values.   @saswiki wrote: 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

You probably need to include the schema name when referencing the table in the pass thru sql. Perhaps &sf_schema..table_name ? Test the passthru SQL syntax using some other way to run SQL code in Snowflake. Such as the browser based tool that Snowflake has.   The other thing to check is the name of the variables in the snowflake dataset.  Using SELECT * you are trying to retrieve them as is.  If any of those are also not valid SAS names you will have problems.  But I would expect a different error message.   ... View more