Hi , i am using sas 9.3 portable version on windows 7 32 bit intel i5 processor ( 4 cores )  , i need to enable parallel processing to harness rest of the core , its using only one. ... View more

I have two tables, Table A has user Id and 5 different product columns(empty, to be filled by count ). Table B has timestamp user id and product id ( purchased at time timestamp ). This code id giving error   Proc SQL; update table_A as table_A set Count_Product_1 =   (select count(product_ID) from Table_B inner join Table_A on Table_A.User_ID=Table_B.User_ID where Product_ID='Unique_identifier_product_1'); Quit;     error: You cannot reopen Table_A for update access with member-level control because Table_A is in use by you in resource environment SQL ... View more