topic Re: Importing a comma delimited txt file in SAS Programming

Importing a comma delimited txt file

Miah — Wed, 28 Mar 2018 21:08:35 GMT

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;

Re: Importing a comma delimited txt file

ballardw — Wed, 28 Mar 2018 21:16:34 GMT

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.

Re: Importing a comma delimited txt file

Reeza — Wed, 28 Mar 2018 21:26:07 GMT

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;