Solved: Re: Proc Append of Proc SQL?

Boa · Posted 11-26-2016 02:54 AM

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.

mkeintz · Posted 11-26-2016 06:37 AM

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

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

Boa · Posted 11-26-2016 03:47 AM

Reeza · Posted 11-26-2016 05:58 AM

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 · Posted 11-26-2016 06:11 AM

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

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

Boa · Posted 11-26-2016 06:29 AM

Thanks.

mkeintz · Posted 11-26-2016 06:37 AM

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

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

Classroom Training Available!