Importing a SAS7BDAT file from c drive location

[tobyfarms]

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

33

34 %_eg_hidenotesandsource;

SYMBOLGEN: Macro variable _EGNOTES resolves to NOTES

SYMBOLGEN: Macro variable _EGSOURCE resolves to SOURCE

46

47

48 %_eg_hidenotesandsource;

SYMBOLGEN: Macro variable _EGNOTES resolves to NOTES

SYMBOLGEN: Macro variable _EGSOURCE resolves to SOURCE

51

[Tom]

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.

[tobyfarms]

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?

[Reeza]

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

[tobyfarms]

Yes, SAS EG and it is server installed.

[Reeza]

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.