I am trying to import this data set into SAS University Edition, but I am getting an error that suggests that my file isn't saved in myfolders folder, even though it is saved there under the same name. This is the error:
and this is my code:
DATA work.draft;
INFILE "/folders/myfolders/2017NBADraft2.csv"
DLM=',' FIRSTOBS=2 DSD MISSOVER;
INPUT LastName $ FirstName $ Team $ Position $ Birthdate :ANYDTDTE10. Height Wingspan Weight College $ Year $;
RUN;
Go to Servers Files Folders pane.
Find your file
Right click>Properties
Copy the path
Use that in your infile statement.
@Miah wrote:
I am trying to import this data set into SAS University Edition, but I am getting an error that suggests that my file isn't saved in myfolders folder, even though it is saved there under the same name. This is the error:
ERROR: Physical file does not exist, /folders/myfolders/2017NBADraft2.csv.NOTE: The SAS System stopped processing this step because of errors.WARNING: The data set WORK.DRAFT may be incomplete. When this step was stopped there were 0 observations and 10 variables.WARNING: Data set WORK.DRAFT was not replaced because this step was stopped.
and this is my code:
DATA work.draft;
INFILE "/folders/myfolders/2017NBADraft2.csv"
DLM=',' FIRSTOBS=2 DSD MISSOVER;
INPUT LastName $ FirstName $ Team $ Position $ Birthdate :ANYDTDTE10. Height Wingspan Weight College $ Year $;
RUN;
@Miah wrote:
I am trying to import this data set into SAS University Edition, but I am getting an error that suggests that my file isn't saved in myfolders folder, even though it is saved there under the same name. This is the error:
ERROR: Physical file does not exist, /folders/myfolders/2017NBADraft2.csv.NOTE: The SAS System stopped processing this step because of errors.WARNING: The data set WORK.DRAFT may be incomplete. When this step was stopped there were 0 observations and 10 variables.WARNING: Data set WORK.DRAFT was not replaced because this step was stopped.
and this is my code:
DATA work.draft;
INFILE "/folders/myfolders/2017NBADraft2.csv"
DLM=',' FIRSTOBS=2 DSD MISSOVER;
INPUT LastName $ FirstName $ Team $ Position $ Birthdate :ANYDTDTE10. Height Wingspan Weight College $ Year $;
RUN;
Make sure the case is the same in the code and the way the file appears to the file system in the virtual box.
Also if you didn't change the file extension to .txt from .csv to post the example on the forum then you didn't use the correct file name in the infile statement.
Go to Servers Files Folders pane.
Find your file
Right click>Properties
Copy the path
Use that in your infile statement.
@Miah wrote:
I am trying to import this data set into SAS University Edition, but I am getting an error that suggests that my file isn't saved in myfolders folder, even though it is saved there under the same name. This is the error:
ERROR: Physical file does not exist, /folders/myfolders/2017NBADraft2.csv.NOTE: The SAS System stopped processing this step because of errors.WARNING: The data set WORK.DRAFT may be incomplete. When this step was stopped there were 0 observations and 10 variables.WARNING: Data set WORK.DRAFT was not replaced because this step was stopped.
and this is my code:
DATA work.draft;
INFILE "/folders/myfolders/2017NBADraft2.csv"
DLM=',' FIRSTOBS=2 DSD MISSOVER;
INPUT LastName $ FirstName $ Team $ Position $ Birthdate :ANYDTDTE10. Height Wingspan Weight College $ Year $;
RUN;
@Miah wrote:
I am trying to import this data set into SAS University Edition, but I am getting an error that suggests that my file isn't saved in myfolders folder, even though it is saved there under the same name. This is the error:
ERROR: Physical file does not exist, /folders/myfolders/2017NBADraft2.csv.NOTE: The SAS System stopped processing this step because of errors.WARNING: The data set WORK.DRAFT may be incomplete. When this step was stopped there were 0 observations and 10 variables.WARNING: Data set WORK.DRAFT was not replaced because this step was stopped.
and this is my code:
DATA work.draft;
INFILE "/folders/myfolders/2017NBADraft2.csv"
DLM=',' FIRSTOBS=2 DSD MISSOVER;
INPUT LastName $ FirstName $ Team $ Position $ Birthdate :ANYDTDTE10. Height Wingspan Weight College $ Year $;
RUN;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.