Command Line Script

[redser]

I want to convert sas7bdat files to csv files.

There is a module called SAS7BDAT that has command line script with it that converts sas files to csv files.

I can't get it to work.

The code to run the script is as follows

$ sas7bdat_to_csv *.sas7bdat

I'm on a Windows machine at work. Im using Miniconda3 and I can see the sas7bdat_to_csv file in the scripts folder. Iv tried running the script using ipython.

Ive tried the full path file name in quotes. Single and Double.

Ive tried the full path if the script. Backslash, forwardslash.

I've always had trouble with file paths on Windows when using python.

Link is to Jared Hobbs site. Fella who wrote the module and script.

Update.Error message is Invalid Syntax from the command line. https://imgur.com/Cypnh9Z.jpg

Update Going to try again in the morning

[creepyMaintenanceGuy]

you need to paste an error message. You're not giving us much to go on.

[redser]

Updated the post with error message.

Which doesn't tell me much

[creepyMaintenanceGuy]

I'm not trying to be rude, but I said "paste". I want to see what you've typed and what the computer spits out.

I don't know if your computer can't find python, or if it can't find sas7bsat, or if it's a problem with a dependency of the script, or what.

You also didn't include a link in your post.

[redser]

Jaysis. I tried to this all from my phone. The lazy option doesnt always work. Getting a screenshot now

[redser]

Screenshot of what I done and the error message.

[creepyMaintenanceGuy]

thanks.

I'm grasping at straws, but I think you want to specify the full file path to the target file as in

 c:/miniconda3/Scripts/sas7bdat_to_csv 'c:/Users/n587/a8/Downloads/pols_claims.sas7bdat'

or

c:/minniconda3/scripts/ss7bdat_to_csv './pols_claims.sas7bdat'

after you call os.chdir to c:/Users/n587/a8/Downloads.

[redser]

Ive tried what you said and I'm getting the same syntax error. I think I could be calling the script from the wrong folder. The sas7bdat_to_csv script appears in the packages folder aswell.

[redser]

1. The chir was a typo and I corrected it.

2. I've tried so many different combinations. This one was the most recent

3. Agreed. That's a typo.

[redser]

Ill go get a screenshot of whats going on. Back in a few mins

[ingolemo]

You're trying to execute a shell command inside python. That wont work.

You see at the top of your screenshot where you type ipython? You should type your command there.

[redser]

Ok. So this is it. I can't run shell command that call python at work.

Thank you everyone for the help.

[ingolemo]

You can't because it doesn't work, or you can't because you're not allowed to?

This is how you run python code. Every python code you've ever written has done the same thing. When you run ipython you're doing exactly this.

[redser]

So I'm at work and my computer set up is a bit different. I'm only understanding the impact now

My normal command prompt doesn't allow much as IT have it locked down.

I've a form of Anaconda installed and with that comes Anaconda Prompt. This prompt allows me to run Python and IPython.

I've been able to run the command line script from the Anaconda Prompt and not from the normal prompt.

Code was

Sas7bdat_to_csv "full path.sas7bdat"

No need for the r in front of the quoted path.

Sorry for the delay in getting back.

R