I have an excel sheet that I want to upload into SAS studio

zhawasli1 — Thu, 27 Jan 2022 17:06:05 GMT

THe good news is that I successfully uploaded my excel worksheet into a sas folder. However, I donot know how to tell SAS studio that I want to use those data inside the excel sheet (libname?) so that I can figure out information such as geometric mean, median, mean, IQR, and standard deviation. Thank you so much for reading!!!

Re: I have an excel sheet that I want to upload into SAS studio

Tom — Thu, 27 Jan 2022 17:14:10 GMT

So if you can see the file in the Files and Folders tab then you can check its properties to find out its actual name (also called the path). You will need that in your code. So copy it from the properties window and paste it into the code window.

libname x xlsx "fully qualified name of your file";

Now each SHEET in the XLSX file can be treated as a SAS dataset.

But it probably will work best to first just copy all of the sheets into work datasets and then code from that.

proc copy inlib=x outlib=work;
run;

If you will need to continue to use this data you might want to write back out as permanent SAS datasets.

topic I have an excel sheet that I want to upload into SAS studio in New SAS User

I have an excel sheet that I want to upload into SAS studio

Re: I have an excel sheet that I want to upload into SAS studio