topic Re: Merging?? Write SAS code to Read a file and import an excel file in New SAS User

Merging?? Write SAS code to Read a file and import an excel file

naeemahb1 — Mon, 07 Jan 2019 22:49:24 GMT

Hello everyone. Can you help with is problem.

Write SAS code to:

Read a file called: SOMEDATA.SAS7BDAT &
Import an Excel data file (CSV) called “CARSMPG.CSV”

after downloading the data files.

Please help. I was not able to find a tutorial for this. A step by step is appreciated.

The desired result is in the attached file.

Re: Merging?? Write SAS code to Read a file and import an excel file

Reeza — Mon, 07 Jan 2019 22:52:59 GMT

Importing or accessing files

https://video.sas.com/detail/videos/sas-analytics-u/video/4664335810001/accessing-your-existing-data-in-sas-university-edition:-download-version?autoStart=true

Merge:

https://video.sas.com/detail/video/4572997800001/merging-sas-tables-in-a-data-step?autoStart=true&q=merge

@naeemahb1 wrote:

Hello everyone. Can you help with is problem.

Write SAS code to:

Read a file called: SOMEDATA.SAS7BDAT &

Import an Excel data file (CSV) called “CARSMPG.CSV”

after downloading the data files.

Please help. I was not able to find a tutorial for this. A step by step is appreciated.

The desired result is in the attached file.

Re: Merging?? Write SAS code to Read a file and import an excel file

ballardw — Mon, 07 Jan 2019 23:30:25 GMT

BTW, CSV files are text files that are in a format that spreadsheet programs can read. They are not "Excel files". Searching for reading Excel files will make things much more complicated than needed.

Re: Merging?? Write SAS code to Read a file and import an excel file

Reeza — Mon, 07 Jan 2019 23:59:27 GMT

Since the file is CSV, here's a video on exactly importing CSV files.
https://video.sas.com/detail/video/4573016758001/creating-a-sas-table-from-a-csv-file?autoStart=true&q=csv

Re: Merging?? Write SAS code to Read a file and import an excel file

Reeza — Tue, 08 Jan 2019 16:11:18 GMT

You cannot merge these files. They have nothing in common and there's no basis or logic that would be correct to merge them. I suspect you misunderstood the instructions somewhere.

If you download the data (sas data set, somedata.sas7bdat) and place it in the myfolders location you created, you can access the data as follows:

*set path to permanent library;
libname myData '/folders/myfolders/';


*show summary to match Word doc;
proc means data=myData.somedata; 
run;

Re: Merging

naeemahb1 — Thu, 10 Jan 2019 16:32:02 GMT

Thank you so much. This is exactly what I needed as I did misunderstand the
assignment directions.