topic Re: "INVALID PHYSICAL NAME" in SAS Software for Learning Community

"INVALID PHYSICAL NAME"

dheaney — Thu, 26 Sep 2024 21:53:48 GMT

I am trying to delete a file and it had created a copy of itself in my library and my data. I am unable to delete it because it says "INVALID PHYSICAL NAME"

Re: "INVALID PHYSICAL NAME"

Tom — Thu, 26 Sep 2024 22:08:58 GMT

@dheaney wrote:

I am trying to delete a file and it had created a copy of itself in my library and my data. I am unable to delete it because it says "INVALID PHYSICAL NAME"

How are you trying to delete it?

Did you run code? Show the code and the log from the execution of the code.

Did you use some interactive feature? What interactive tool are you using? What action did you take (what menu did you use)?

Re: "INVALID PHYSICAL NAME"

tom_grant — Thu, 26 Sep 2024 22:09:59 GMT

Can you post a screenshot of the file in the directory?

Re: "INVALID PHYSICAL NAME"

dheaney — Thu, 26 Sep 2024 22:16:31 GMT

I got this error

{}

[TRACEBACK]

Re: "INVALID PHYSICAL NAME"

tom_grant — Thu, 26 Sep 2024 22:24:12 GMT

You should be able to find the file on the Server Files and Folders tab (in one of your subfolders under Files(Home)) & then just right-click -> Delete.

Re: "INVALID PHYSICAL NAME"

dheaney — Thu, 26 Sep 2024 22:26:18 GMT

It won't allow me to delete it

Re: "INVALID PHYSICAL NAME"

dheaney — Thu, 26 Sep 2024 22:27:27 GMT

I get a pop up:
Invalid physical name

Re: "INVALID PHYSICAL NAME"

tom_grant — Thu, 26 Sep 2024 22:56:50 GMT

Can you post a screenshot of the file in your Server Files and Folders tab?

Re: "INVALID PHYSICAL NAME"

dheaney — Thu, 26 Sep 2024 23:33:41 GMT

I would like to delete the following:

MyData
- student_performance_factors2.sas7bdat
- Student_performance_factors2.sas7bdat
My Library
- student_performance_factors2.sas7bdat

Re: "INVALID PHYSICAL NAME"

JackieJ_SAS — Fri, 27 Sep 2024 00:30:43 GMT

Hi,

Try the PROC DATASETS code in the solution of this other post:

https://communities.sas.com/t5/SAS-Software-for-Learning/Deleting-Files-in-SAS-Studio-SAS-on-Demand-for-Academics/m-p/913852#M1662

The code deletes all the datasets in a library. PROC datasets allows you to delete individual datasets as well, but that may not work given the problem you are having with the filename. I suggest you copy any datasets you want to keep to another folder, then delete all the datasets in the folder that contains the datasets you want to delete.

Re: "INVALID PHYSICAL NAME"

JackieJ_SAS — Fri, 27 Sep 2024 00:34:48 GMT

By the way- I think the issue here is the mixed casing in the dataset names. I think SAS is expecting dataset names in all lower case. If you create a dataset using code within SODA, it will always have a name in all lowercase, but you may have imported a file with mixed case.

Re: "INVALID PHYSICAL NAME"

dheaney — Fri, 27 Sep 2024 00:38:10 GMT

HI Jackie,
I tried to do that and got the following.
WARNING: Library MYLIB does not exist.
ERROR: Library MYLIB does not exist.
Devon

Re: "INVALID PHYSICAL NAME"

dheaney — Fri, 27 Sep 2024 00:38:42 GMT

is there anyway to reset my account? I loaded the file in at 5PM tonight and thats where things went wrong

Re: "INVALID PHYSICAL NAME"

JackieJ_SAS — Fri, 27 Sep 2024 00:42:03 GMT

That error is telling you that you aren't pointing to the correct folder. Make sure to change the folder path in the code to the folder where the files are.

Re: "INVALID PHYSICAL NAME"

dheaney — Fri, 27 Sep 2024 00:44:37 GMT

I do not know what to change

Re: "INVALID PHYSICAL NAME"

dheaney — Fri, 27 Sep 2024 00:46:33 GMT

Re: "INVALID PHYSICAL NAME"

JackieJ_SAS — Fri, 27 Sep 2024 00:53:00 GMT

OK. Here is the original code:

libname mylib "~/MyFolder";

proc datasets library=mylib kill;
run; quit;

The part you want to change is what is in quotes:

"~/MyFolder";

On SODA, your Files(Home) is your root directory, and you can call that with:

"~/"

I see you want to delete datasets from two subfolders-- MyData and MyLibrary.

So run the code once like this:

libname mylib "~/MyData";

proc datasets library=mylib kill;
run; quit;

Then run it again like this:

libname mylib "~/MyLibrary";

proc datasets library=mylib kill;
run; quit;

Make sense?

Re: "INVALID PHYSICAL NAME"

dheaney — Fri, 27 Sep 2024 00:59:46 GMT

This worked! I am just having trouble deleting this Junk folder.

Re: "INVALID PHYSICAL NAME"

JackieJ_SAS — Fri, 27 Sep 2024 01:02:47 GMT

Hooray!! I am glad it worked.

To delete a folder, you have to delete any files within the folder first.

If you are able to right click on each file to delete the files in your junk folder, than do that.

Otherwise- can you see how to modify the previous code to use a folder path to your junk folder? That will also delete all the datasets in that folder.

Re: "INVALID PHYSICAL NAME"

dheaney — Fri, 27 Sep 2024 01:09:09 GMT

Hi Jackie,

Can you please confirm the correct code to use to do so? I appreciate all of your help!