topic Re: infile statement in sas in SAS Programming

infile statement in sas

subhra07 — Tue, 07 Aug 2018 10:52:03 GMT

Hi when i use the below mentioned sas code to access the data, it throws the error-physical file does not exist. I am using sas studio. and have added the text data into my sas folder.

I have attached the file showing the error.

Do is need to add anything else.

data price;
infile="/folders/myfolders/data_infile.txt";
input brand $ model $ price;
run;

Re: infile statement in sas

rudfaden — Tue, 07 Aug 2018 11:09:12 GMT

If you right click on the files and choose properties, you can see the file location

Re: infile statement in sas

subhra07 — Tue, 07 Aug 2018 11:18:33 GMT

Have tried with the full path and got error too.

this is the code

data price;
infile="F:\SASUniversityEdition\myfolders\data_infile.txt" dlm = '09'x;
input brand $ model $ price;
run;

Re: infile statement in sas

Kurt_Bremser — Tue, 07 Aug 2018 11:41:13 GMT

@subhra07 wrote:

Have tried with the full path and got error too.

this is the code

data price;
infile="F:\SASUniversityEdition\myfolders\data_infile.txt" dlm = '09'x;
input brand $ model $ price;
run;

This can never work in UE, as the virtual machine only "sees" the UNIX file system.

Have you tried '/folders/myfolder/data_infile.txt'? (if set up correctly, the shared folder has no trailing s in the VM)

Re: infile statement in sas

subhra07 — Tue, 07 Aug 2018 11:48:11 GMT

Have got the solution. There should not be equal sign after infile statement

Re: infile statement in sas

Kurt_Bremser — Tue, 07 Aug 2018 11:57:42 GMT

@subhra07 wrote:

Have got the solution. There should not be equal sign after infile statement

Ouch. At least one of us should have caught that immediately. Going for additional coffee.

Re: infile statement in sas

subhra07 — Tue, 07 Aug 2018 12:03:36 GMT

Yes I have tried that and it worked fine.

One more doubt. Will it work the same way '/folders/myfolder/data_infile.txt' in SAS enterprise guide or do i have to give the full path "F:\SASUniversityEdition\myfolders\data_infile.txt" dlm = '09'x

Thanks

Re: infile statement in sas

Kurt_Bremser — Tue, 07 Aug 2018 12:10:01 GMT

@subhra07 wrote:

Yes I have tried that and it worked fine.

One more doubt. Will it work the same way '/folders/myfolder/data_infile.txt' in SAS enterprise guide or do i have to give the full path "F:\SASUniversityEdition\myfolders\data_infile.txt" dlm = '09'x

Thanks

You can't use Enterprise Guide with University Edition.

Apart from that, it always depends on where the SAS process itself runs, and how files are brought into the respective server environment.

Re: infile statement in sas

subhra07 — Tue, 07 Aug 2018 12:15:37 GMT

I am not using EG with university edition.

the EG is working with office server.

I would like to know if we could import text files using the infile statement. And if so, what would be the code like?

Thanks.

Re: infile statement in sas

Tom — Tue, 07 Aug 2018 12:28:34 GMT

@subhra07 wrote:

I am not using EG with university edition.

the EG is working with office server.

I would like to know if we could import text files using the infile statement. And if so, what would be the code like?

Thanks.

The INFILE statement works the same no matter where SAS is running.

But you do need to understand where your files are on the machine where SAS itself is running. If it is not machine where your browser or SAS Enterprise Guide is running then the path you use in SAS will most likely be different than what you would use on your PC. Also remember that SAS University Edition is using a virtual machine to run SAS.

Re: infile statement in sas

Kurt_Bremser — Tue, 07 Aug 2018 13:19:51 GMT

@subhra07 wrote:

I am not using EG with university edition.

the EG is working with office server.

I would like to know if we could import text files using the infile statement. And if so, what would be the code like?

Thanks.

What @Tom said. You need to somehow make the file "visible" to the SAS process, either by copying it to the server, or using a shared resource that is accessible by both your desktop and the server, or by using a resource shared from the server that is mounted on your desktop. Either way, the path will be different from what you use on your PC.

Re: infile statement in sas

nirupama1 — Sat, 10 Nov 2018 17:53:55 GMT

Hi All,

I used below codes i.e. with Tilde and without tilde(~). And getting the same result . Can yo explain why is it so?

case1-

Data student;
infile cards dsd dlm=',';
Input id team $25.;
Cards;
1,"Green House,NCSS"
2,"Green House,ABPS"
3,"Green House,JKLM"
;
proc print;
Run;

case 2-

Data student;
infile cards dsd dlm=',';
Input id team ~ $25.;
Cards;
1,"Green House,NCSS"
2,"Green House,ABPS"
3,"Green House,JKLM"
;
proc print;
Run;

same outputfor both cases-

id team

1	"Green House,NCSS"
2	"Green House,ABPS"
3	"Green House,JKLM"

While I expect to not receive quotes in output for case 1 scenario, as per the DSD fuctionality.

PLease explain Why getting same output.

Thanks,

Nirupama

Re: infile statement in sas

Kurt_Bremser — Sat, 10 Nov 2018 18:19:37 GMT

@nirupama1 wrote:

Hi All,

I used below codes i.e. with Tilde and without tilde(~). And getting the same result . Can yo explain why is it so?

case1-

Data student;
infile cards dsd dlm=',';
Input id team $25.;
Cards;
1,"Green House,NCSS"
2,"Green House,ABPS"
3,"Green House,JKLM"
;
proc print;
Run;

case 2-

Data student;
infile cards dsd dlm=',';
Input id team ~ $25.;
Cards;
1,"Green House,NCSS"
2,"Green House,ABPS"
3,"Green House,JKLM"
;
proc print;
Run;

same outputfor both cases-

id team

1 "Green House,NCSS"

2 "Green House,ABPS"

3 "Green House,JKLM"

While I expect to not receive quotes in output for case 1 scenario, as per the DSD fuctionality.

PLease explain Why getting same output.

Thanks,

Nirupama

Do not hijack other people's threads, post your question in a new one. Old questions are only "seen" by the original participants.