sql view is taking more time to copy into table or print

[sunilreddy]

when i am copying the records from view to table, its taking around 12 mins for 70K records, but when i am copying from view to view its taking less than a min

by using simple select statement.

I am using simple proc print statement for view and table. view is taking lot of more time than table.

is there any way to reduce the time to print with view

[ballardw]

Trying to optimize code without an example of what the code is doing is extremely difficult. So an example of code would be helpful. Also are the views/ tables/ datasets SAS or accessing an external database?

In general a view has to excecute the equivalent of the code each time. If the source data is large or lots of complex code involved performance takes a hit. View to view is basically just constructing the instructions, not actually moving any data. The instructions execute when the view is used, such as in Proc print.

[Doc_Duke]

Thus is working as intended.  Copying a view to a view just copies the associated commands; no data are moved.  That's why there is such a time difference.  RTFM.