cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
lgutie1808
‎10-04-2023
  • 4 Posts
  • 3 Likes Given
  • 1 Solutions
  • 2 Likes Received

Re: Importing a Microsoft Excel Worksheet (.xlsx) dataset into SAS 9.4

by Fluorite | Level 6 in SAS Programming
‎10-04-2023 04:39 PM
‎10-04-2023 04:39 PM
Thanks for both comments.    I've added the name of the excel file and it worked!   The successful code is provided below:   proc import datafile = 'H:\NIAGEN Clinical Trial\Fellowship Project\Datasets\SAS Programs for Data Analysis\COVID_Niagen_Sleep_SAS_1.0.xlsx' out = COVID.Sleep dbms = xlsx replace; run;   Thank you! ... View more

Re: Importing a Microsoft Excel Worksheet (.xlsx) dataset into SAS 9.4

by Fluorite | Level 6 in SAS Programming
‎10-04-2023 04:37 PM
2 Likes
‎10-04-2023 04:37 PM
2 Likes
Thanks for noting that!   I have tried this code adding the name of the excel file and it worked!   proc import datafile = 'H:\NIAGEN Clinical Trial\Fellowship Project\Datasets\SAS Programs for Data Analysis\COVID_Niagen_Sleep_SAS_1.0.xlsx' out = COVID.Sleep dbms = xlsx replace; run;   Thank you! ... View more

Re: Importing a Microsoft Excel Worksheet (.xlsx) dataset into SAS 9.4

by Fluorite | Level 6 in SAS Programming
‎10-04-2023 04:26 PM
‎10-04-2023 04:26 PM
I'm getting access to the software in my local computer through VPN and the use of a remote desktop. H: is my workplace drive. Yes! I can see the file when I navigate to the path using the file explorer.  Thank you. ... View more

Importing a Microsoft Excel Worksheet (.xlsx) dataset into SAS 9.4

by Fluorite | Level 6 in SAS Programming
‎10-04-2023 04:02 PM
‎10-04-2023 04:02 PM
Hello,    I'm using the following code to import a Microsoft Excel Worksheet (.xls) dataset into SAS 9.4:   proc import out=Sleep datafile="H:\NIAGEN Clinical Trial\Fellowship Project\Datasets\SAS Programs for Data Analysis" DBMS=EXCEL REPLACE; RANGE="Sheet1$";  GETNAMES=YES;  MIXED=YES;  SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; run;   However, I keep getting this error message in the Log:   <<ERROR: Unable to open file H:\NIAGEN Clinical Trial\Fellowship Project\Datasets\SAS Programs for Data Analysis.XLS. It does not exist or it is already opened exclusively by another user, or you need permission to view its data.>>   I don't have the file open when I'm running this code.   Many thanks in advance for some advice! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-04-2023 08:23 PM
Likes given to
View All
Likes from
View All
Quick links