topic Re: Importing a SAS7BDAT file from c drive location in SAS Programming

Importing a SAS7BDAT file from c drive location

tobyfarms — Tue, 15 Oct 2019 19:44:42 GMT

I am having difficulty reading in a file from my c drive location. Here is the code.

data new;

set 'C:\cert\input\input04.sas7bdat';

run;

Here is the error

30 data new;

31 set 'C:\cert\input\input04.sas7bdat';

ERROR: The value 'C:\CERT\INPUT\INPUT04'n is not a valid SAS member name.

32 run;

NOTE: Compression was disabled for data set WORK.NEW because compression overhead would increase the size of the data set.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.NEW may be incomplete. When this step was stopped there were 0 observations and 0 variables.

WARNING: Data set WORK.NEW was not replaced because this step was stopped.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

34 %_eg_hidenotesandsource;

SYMBOLGEN: Macro variable _EGNOTES resolves to NOTES

SYMBOLGEN: Macro variable _EGSOURCE resolves to SOURCE

48 %_eg_hidenotesandsource;

SYMBOLGEN: Macro variable _EGNOTES resolves to NOTES

SYMBOLGEN: Macro variable _EGSOURCE resolves to SOURCE

Re: Importing a SAS7BDAT file from c drive location

Tom — Tue, 15 Oct 2019 19:52:11 GMT

What version of SAS are you running? That error message looks funny. As if you used:

set 'C:\cert\input\input04.sas7bdat'n;

Instead of

set 'C:\cert\input\input04.sas7bdat';

Are you sure those a normal ASCII single quotes? Try typing them again.

Also is SAS running on the same machine as where that file is stored? That junk at the bottom of your log makes it look like you are using Enterprise Guide to run your SAS code. So depending on what server you connected it to SAS might be running on a different machine than where Enterprise Guide is running.

Re: Importing a SAS7BDAT file from c drive location

Reeza — Tue, 15 Oct 2019 20:06:37 GMT

Are you using SAS EG?
Is EG a server installation or installed on your local machine and working off data in your machine.

Re: Importing a SAS7BDAT file from c drive location

tobyfarms — Wed, 16 Oct 2019 13:04:44 GMT

Yes, SAS EG and it is server installed.

Re: Importing a SAS7BDAT file from c drive location

tobyfarms — Wed, 16 Oct 2019 13:05:56 GMT

Yes I am using SAS EG and it is server connected. So could that cause the issue with trying to connect to data located on my machine?

Re: Importing a SAS7BDAT file from c drive location

Reeza — Wed, 16 Oct 2019 14:51:21 GMT

Yes, you can still upload the file you just need to do it in a different manner, primarily using Point and Click. There should be a Copy Files task that allows you to upload the file to the server and then you can use it.