BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Boa
Obsidian | Level 7 Boa
Obsidian | Level 7

 

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.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
mkeintz
PROC Star

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

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

View solution in original post

5 REPLIES 5
Boa
Obsidian | Level 7 Boa
Obsidian | Level 7
 
 
Reeza
Super User

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
PROC Star

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
Obsidian | Level 7 Boa
Obsidian | Level 7

 

Thanks. 

mkeintz
PROC Star

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

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 1557 views
  • 0 likes
  • 3 in conversation