topic ERROR: Extension for physical file name "/folders/myfolders/poly.dat" does not correspond to a valid in SAS Programming

ERROR: Extension for physical file name "/folders/myfolders/poly.dat" does not correspond to a valid

qu — Wed, 19 Jul 2017 20:56:24 GMT

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

NOTE: PROCEDURE MIXED used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

ERROR: Extension for physical file name "/folders/myfolders/poly.dat" does not correspond to a valid member type.

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

62 PROC MIXED DATA='/folders/myfolders/poly.dat';

63 CLASS aggvar;

64 MODEL Z = P E P*P P*E E*E / S DDFM = BW;

65 CONTRAST 'slope of fit line P = E' P 1

66 E 1;

67 CONTRAST 'urvature of fit line P = E' P*P 1

68 P*E 1

69 E*E 1;

70 CONTRAST 'slope of misfit line P = -E' P 1

71 E -1;

72 CONTRAST 'curvature of misfit line P = -E' P*P 1

73 P*E -1

74 E*E 1;

75 RUN;

77 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: ERROR: Extension for physical file name "/folders/myfolders/poly.dat" does not corresp

Reeza — Wed, 19 Jul 2017 21:09:25 GMT

You have to first import your text file and then you can use it, you cannot use it directly as indicated.

Try a PROC IMPORT to first import your data, once imported, use the SAS dataset created.

@qu wrote:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

61

NOTE: PROCEDURE MIXED used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

ERROR: Extension for physical file name "/folders/myfolders/poly.dat" does not correspond to a valid member type.

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

62 PROC MIXED DATA='/folders/myfolders/poly.dat';

63 CLASS aggvar;

64 MODEL Z = P E P*P P*E E*E / S DDFM = BW;

65 CONTRAST 'slope of fit line P = E' P 1

66 E 1;

67 CONTRAST 'urvature of fit line P = E' P*P 1

68 P*E 1

69 E*E 1;

70 CONTRAST 'slope of misfit line P = -E' P 1

71 E -1;

72 CONTRAST 'curvature of misfit line P = -E' P*P 1

73 P*E -1

74 E*E 1;

75 RUN;

76

77 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: ERROR: Extension for physical file name "/folders/myfolders/poly.dat" does not corresp

qu — Wed, 19 Jul 2017 21:11:57 GMT

Thanks a lot. But how to import my text file in SAS studio (the data is in '/folders/myfolders/poly.dat').

Re: ERROR: Extension for physical file name "/folders/myfolders/poly.dat" does not corresp

Reeza — Wed, 19 Jul 2017 21:12:58 GMT

PROC IMPORT or see this video:

http://video.sas.com/detail/videos/how-to-tutorials/video/4573016758001/creating-a-sas-table-from-a-csv-file?autoStart=true