topic Re: File Does Not Exist Windows SAS 9.4 .csv in New SAS User

File Does Not Exist Windows SAS 9.4 .csv

tjz3 — Tue, 22 Sep 2020 04:24:47 GMT

Hello,

For the record, I just started using SAS and have no idea what I'm doing. I can't stop getting the error that the physical file does not exist. I'm using windows 10, SAS 9.4 is downloaded locally on the machine and I've even tried downloading SAS on a different device and trying to use it there but it still isn't working. I have tried rewording things to not include any spaces or special characters, that didn't work. I also tried using a diagnostic bit of code to see if SAS even recognizes the files, it did see them actually. I moved the data file location, and even tried a completely different data file as well. Attached is a picture of the code and log that's relevant. The extension in the folder for the datafile I'm trying to use is .sas7bdat.

Thanks,

Tony

Re: File Does Not Exist Windows SAS 9.4 .csv

andreas_lds — Tue, 22 Sep 2020 04:54:18 GMT

Please post the full log as text using "insert code" the icon </>.

What happens if you copy the path of the csv-file including filename and paste it into windows explorer?

Re: File Does Not Exist Windows SAS 9.4 .csv

Kurt_Bremser — Tue, 22 Sep 2020 06:19:12 GMT

If a file has the .sas7bdat extension, then it is already a SAS dataset. Put it where a libname is defined, and use it. No import needed.

Re: File Does Not Exist Windows SAS 9.4 .csv

andreas_lds — Tue, 22 Sep 2020 06:30:52 GMT

@Kurt_Bremser wrote:

If a file has the .sas7bdat extension, then it is already a SAS dataset. Put it where a libname is defined, and use it. No import needed.

Incredible, how could i have overlooked the last sentence in the original post? I should fall-back to the old rule: start the computer after having a least one cup of coffee.

Re: File Does Not Exist Windows SAS 9.4 .csv

Kurt_Bremser — Tue, 22 Sep 2020 09:46:04 GMT

What do you actually mean by

"SAS 9.4 is downloaded locally on the machine"

Did you download a SAS depot and run the Software Deployment Wizard/Manager to install SAS?

Re: File Does Not Exist Windows SAS 9.4 .csv

tjz3 — Tue, 22 Sep 2020 20:56:53 GMT

I read somewhere something about SAS being used on a different server or something. So I thought I would just mention that it was installed on my machine and not being used on some other server.

Re: File Does Not Exist Windows SAS 9.4 .csv

Kurt_Bremser — Tue, 22 Sep 2020 21:42:49 GMT

Then my first answer is valid.

Re: File Does Not Exist Windows SAS 9.4 .csv

tjz3 — Wed, 23 Sep 2020 02:32:48 GMT

Could I bug you again? I'm sorry I'm really not sure what I'm doing here. What would the code be to use the dataset then for the program I'm trying to run? The rest of the code is already written I just need to get the data to be used. Thanks.

Re: File Does Not Exist Windows SAS 9.4 .csv

Kurt_Bremser — Wed, 23 Sep 2020 05:44:17 GMT

Say you have a directory C:\users\you\sasdat, and a file called xxx.sas7bdat there. You then define the library with LIBNAME:

libname mydata 'C:\users\you\sasdat';

so you can then use mydata.xxx in statements, e.g.

proc print data=mydata.xxx;
run;