Hmmm, I'm confused.
None of the scenarios you are proposing are using SQL Pass Through.
2 and 3 are almost identical. The view must be resolved in order to retrieve the data. So, yes the creation of the view is done immediately, but resolution will take probably the same time as 2 (depends how you are defining the view).
Append works fast, because it does not need to scan the whole base table, only data is effectively processed row by row. And again it depends how data is retrieved.
I would indeed consider adding a 4th scenario, which would be, a SQL Pass Through extract to a sas dataset, followed by proc append to the base dataset. It depends on the amount of data you're trying to retrieve, on the DBMS engine, on how complex is your WHERE condition.
From my experience, you won't get a clear answer without doing some serious testing of the 4 approachs (although I would put aside rightaway 2 and 3).
Cheers from Portugal.
Daniel Santos @
www.cgd.pt.