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

[naeemahb1]

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.

[Reeza]

Importing or accessing files

https://video.sas.com/detail/videos/sas-analytics-u/video/4664335810001/accessing-your-existing-data...

Merge:

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

---

@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.

---

[ballardw]

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.

[Reeza]

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...

[Reeza · Accepted solution]

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;

[naeemahb1]

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