topic Re: Need Help Merging in New SAS User

Need Help Merging

Nique — Tue, 22 Sep 2020 21:12:52 GMT

I currently have access to SAS Enterprise Guide and SAS Universal Viewer. I have been dabbling in universal viewer, but have not been able to figure out how to use enterprise. So at this moment I am able to view, sort and filter data files in viewer, which is great. I am posting this because I am finding out my assignment will require that I merge or join data files together to review information. I am told, maybe its wrong I can not merge in SAS universal viewer, so that's fine. I have Enterprise, but I am not a coder, I am comfortable pointing and clicking. So what do I need to do, why program is it that will allow me to merge data files together easily without coding? Can I do that with viewer, enterprise? or perhaps there is no way to do it other than coding, or perhaps theres another program that will permit? Please help. I've been on this all day today

Re: Need Help Merging

Kurt_Bremser — Tue, 22 Sep 2020 21:41:08 GMT

Use the query builder in Enterprise Guide.

Re: Need Help Merging

CurtisMackWSIPP — Tue, 22 Sep 2020 21:42:10 GMT

I am not sure how far along you are in Enterprise Guide. This will get you started.

Working with Process Flows

You are looking specifically for the Query Builder Task.

Re: Need Help Merging

Reeza — Tue, 22 Sep 2020 21:45:23 GMT

Go here, click the Getting Started with SAS Programming and take the first e-course. I'd highly recommend that or walking through the EG tutorials that are installed. They'll help you get started. And the documentation of course....

https://support.sas.com/en/software/enterprise-guide-support.html

There's a video there on using query builder for example or the tutorial here

https://support.sas.com/documentation/onlinedoc/guide/tut8/en/menu.htm.

@Nique wrote:

I currently have access to SAS Enterprise Guide and SAS Universal Viewer. I have been dabbling in universal viewer, but have not been able to figure out how to use enterprise. So at this moment I am able to view, sort and filter data files in viewer, which is great. I am posting this because I am finding out my assignment will require that I merge or join data files together to review information. I am told, maybe its wrong I can not merge in SAS universal viewer, so that's fine. I have Enterprise, but I am not a coder, I am comfortable pointing and clicking. So what do I need to do, why program is it that will allow me to merge data files together easily without coding? Can I do that with viewer, enterprise? or perhaps there is no way to do it other than coding, or perhaps theres another program that will permit? Please help. I've been on this all day today

Re: Need Help Merging

Nique — Tue, 22 Sep 2020 22:27:11 GMT

This was great thank you so much Reeza, that link you sent me learning the basics, had a link for joining tables in Enterprise Guide. So I'll just need to follow the instructions, I will maybe start with some of the tutorials, so I can get familiar doing some of the basics first in Enterprise, then I'll be ready for the query tool.

Re: Need Help Merging

Nique — Tue, 22 Sep 2020 22:28:12 GMT

Thank you Kurt for your efficient response. Much appreciated.