topic Proc Append of Proc SQL? in SAS Programming

Proc append

Boa — Sun, 27 Nov 2016 08:57:34 GMT

Buyingid Customerid purchasedate City numunits numorderlines

1232 121211 12OCT09 Farifield 45 1

1233 353412 15OCT09 Newyork 1 1

1234 343121 30NOV12 Japan 2 1

Question: Display only the customerid and firstname.

Boa — Sat, 26 Nov 2016 15:32:17 GMT

Reeza — Sat, 26 Nov 2016 10:58:42 GMT

Your code seems incorrect.

You would first filter your table 2 based on purchase and then get the corresponding names from table 1.

Given your question and data, I'm not sure how you'd filter as there isn't an item code that I can see.

mkeintz — Sat, 26 Nov 2016 11:11:56 GMT

Is there a reason you're not doing this entirely within SQL?

Boa — Sat, 26 Nov 2016 17:06:01 GMT

Thanks.

mkeintz — Sat, 26 Nov 2016 11:37:58 GMT

You should filter the buying dataset using the buyingid variable prior to the inner join. Take a look at the "where" clause for sql.