topic Re: Starting with a libname and proc data in New SAS User

Starting with a libname and proc data

98ighcfdvxcghjk — Wed, 14 Oct 2020 16:43:58 GMT

Hello,

I am trying to have my SAS read my files but I am having trouble. I have this code below and it says the library does not exist when I run it but it worked before so now I am confused. IS there anyone who can help me with it and fixing the code so it runs?

/**this is the start of the prescribed medicine files for 2017 first**/

LIBNAME RX17 "C: Users\nidia\Documents\SASTHESIS";

FILENAME IN1 "C: Users\nidia\Documents\SASTHESIS\RX17\H197a.ssp";

PROC XCOPY IN=IN1 OUT=RX17 IMPORT;

Run;

PROC CONTENTS DATA= RX17h197a;

TITLE "List of Variables SCRIPT 2017 MEPS";

Run;

/**start of the prescribed medicine files for 2018**/

LIBNAME RX18 “"C: Users\nidia\Documents\SASTHESIS";

FILENAME IN1 “"C: Users\nidia\Documents\SASTHESIS\RX18\H206a.ssp";

PROC XCOPY IN=IN1 OUT=RX18 IMPORT;

Run;

PROC CONTENTS DATA= RX18.h206a;

TITLE “List of Variables SCRIPT 2018 MEPS”;

Run;

Re: Starting with a libname and proc data

Reeza — Wed, 14 Oct 2020 16:56:34 GMT

Are you getting any errors? What does the log show?

Make sure to paste your code into code blocks otherwise the HTML changes your code - is the missing slashes (see red below) in your path HTML changes or is it missing from the path?

@98ighcfdvxcghjk wrote:

Hello,

I am trying to have my SAS read my files but I am having trouble. I have this code below and it says the library does not exist when I run it but it worked before so now I am confused. IS there anyone who can help me with it and fixing the code so it runs?

/**this is the start of the prescribed medicine files for 2017 first**/

LIBNAME RX17 "C:\Users\nidia\Documents\SASTHESIS";

FILENAME IN1 "C:\Users\nidia\Documents\SASTHESIS\RX17\H197a.ssp";

PROC XCOPY IN=IN1 OUT=RX17 IMPORT;

Run;

PROC CONTENTS DATA= RX17h197a;

TITLE "List of Variables SCRIPT 2017 MEPS";

Run;

/**start of the prescribed medicine files for 2018**/

LIBNAME RX18 “"C:\Users\nidia\Documents\SASTHESIS";

FILENAME IN1 “"C:\Users\nidia\Documents\SASTHESIS\RX18\H206a.ssp";

PROC XCOPY IN=IN1 OUT=RX18 IMPORT;

Run;

PROC CONTENTS DATA= RX18.h206a;

TITLE “List of Variables SCRIPT 2018 MEPS”;

Run;

Re: Starting with a libname and proc data

98ighcfdvxcghjk — Wed, 14 Oct 2020 16:59:55 GMT

I added the slashes but I still get errors. This is the log:

18 /**this is the start of the prescribed medicine files for 2017 first**/
19
20 LIBNAME RX17 "C: \Users\nidia\Documents\SASTHESIS";
NOTE: Library RX17 does not exist.
21 FILENAME IN1 "C: \Users\nidia\Documents\SASTHESIS\RX17\H197a.ssp";
22 PROC XCOPY IN=IN1 OUT=RX17 IMPORT;
23 Run;

WARNING: Library RX17 does not exist.
NOTE: Input library IN1 is sequential.
ERROR: Physical file does not exist, C:\Users\nidia\
\Users\nidia\Documents\SASTHESIS\RX17\H197a.ssp.
NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE XCOPY used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds

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

24 PROC CONTENTS DATA= RX17h197a;
ERROR: File WORK.RX17H197A.DATA does not exist.
25 TITLE "List of Variables SCRIPT 2017 MEPS";
26 Run;

NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

NOTE: The SAS System stopped processing this step because of errors.
27
28 /**start of the prescribed medicine files for 2018**/
29
30 LIBNAME RX18 “"C: \Users\nidia\Documents\SASTHESIS";
ERROR: Libref in LIBNAME statement must be followed either by quoted string or engine name or
semicolon; "“" found.
ERROR: Error in the LIBNAME statement.
31 FILENAME IN1 “"C: \Users\nidia\Documents\SASTHESIS\RX18\H206a.ssp";
ERROR: Error in the FILENAME statement.

32 PROC XCOPY IN=IN1 OUT=RX18 IMPORT;
33 Run;

ERROR: Libref RX18 is not assigned.
NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE XCOPY used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds

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

35 PROC CONTENTS DATA= RX18.h206a;
ERROR: Libref RX18 is not assigned.
36 TITLE “List of Variables SCRIPT 2018 MEPS”;
37 Run;

NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

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

Re: Starting with a libname and proc data

Reeza — Wed, 14 Oct 2020 17:14:48 GMT

It seems like the path is still wrong, it has an extra space in it.

Copy the path directly from Windows Explorer and paste it in. Hold down CTRL+SHIFT + RIGHT CLICK on a file and select copy as path and Windows will copy the full file path to your clipboard.

Run just the libname portion until that works correctly before running anything else.

@98ighcfdvxcghjk wrote:

I added the slashes but I still get errors. This is the log:

18 /**this is the start of the prescribed medicine files for 2017 first**/
19
20 LIBNAME RX17 "C:X\Users\nidia\Documents\SASTHESIS";
NOTE: Library RX17 does not exist.
21 FILENAME IN1 "C:X\Users\nidia\Documents\SASTHESIS\RX17\H197a.ssp";
22 PROC XCOPY IN=IN1 OUT=RX17 IMPORT;
23 Run;

WARNING: Library RX17 does not exist.
NOTE: Input library IN1 is sequential.
ERROR: Physical file does not exist, C:\Users\nidia\
\Users\nidia\Documents\SASTHESIS\RX17\H197a.ssp.
NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE XCOPY used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds

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

24 PROC CONTENTS DATA= RX17h197a;
ERROR: File WORK.RX17H197A.DATA does not exist.
25 TITLE "List of Variables SCRIPT 2017 MEPS";
26 Run;

NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

NOTE: The SAS System stopped processing this step because of errors.
27
28 /**start of the prescribed medicine files for 2018**/
29
30 LIBNAME RX18 “"C: \Users\nidia\Documents\SASTHESIS";
ERROR: Libref in LIBNAME statement must be followed either by quoted string or engine name or
semicolon; "“" found.
ERROR: Error in the LIBNAME statement.
31 FILENAME IN1 “"C: \Users\nidia\Documents\SASTHESIS\RX18\H206a.ssp";
ERROR: Error in the FILENAME statement.

32 PROC XCOPY IN=IN1 OUT=RX18 IMPORT;
33 Run;

ERROR: Libref RX18 is not assigned.
NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE XCOPY used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds

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

35 PROC CONTENTS DATA= RX18.h206a;
ERROR: Libref RX18 is not assigned.
36 TITLE “List of Variables SCRIPT 2018 MEPS”;
37 Run;

NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

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

Re: Starting with a libname and proc data

ballardw — Wed, 14 Oct 2020 17:15:17 GMT

You have

LIBNAME RX17 "C: \Users\nidia\Documents\SASTHESIS";

but the space between : and \ is not valid

LIBNAME RX17 "C:\Users\nidia\Documents\SASTHESIS";

Also, have you created the folder SASTHESIS?

If you are working with a server then the server executing your SAS code likely does not see your hard drive as well.

Re: Starting with a libname and proc data

98ighcfdvxcghjk — Wed, 14 Oct 2020 17:34:45 GMT

Thanks. The first part works now but I want SAS to read another file and that does not work in terms of the libname.

LIBNAME RX18 "C:\Users\nidia\Documents\SASTHESIS";

FILENAME IN2 "C:\Users\nidia\Documents\SASTHESIS\RX18\H206A.ssp";

PROC XCOPY IN=IN2 OUT=RX18 IMPORT;

Run;

PROC CONTENTS DATA= RX18.H206A;

TITLE “List of Variables SCRIPT 2018 MEPS”;

Run;

It gives me this in the log

LIBNAME RX18 "C:\Users\nidia\Documents\SASTHESIS";
NOTE: Libref RX18 refers to the same physical library as RX17.
NOTE: Libref RX18 was successfully assigned as follows:
Engine: V9
Physical Name: C:\Users\nidia\Documents\SASTHESIS
121 FILENAME IN2 "C:\Users\nidia\Documents\SASTHESIS\RX18\H206A.ssp";
122 PROC XCOPY IN=IN2 OUT=RX18 IMPORT;
123 Run;

NOTE: Input library IN2 is sequential.
ERROR: File is probably a cport file. XPORT engine unable to read file created by proc cport.
Please use proc cimport to convert this file to native format.
NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE XCOPY used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

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

Re: Starting with a libname and proc data

Reeza — Wed, 14 Oct 2020 17:58:08 GMT

@98ighcfdvxcghjk wrote:

Thanks. The first part works now but I want SAS to read another file and that does not work in terms of the libname.

LIBNAME RX18 "C:\Users\nidia\Documents\SASTHESIS";

FILENAME IN2 "C:\Users\nidia\Documents\SASTHESIS\RX18\H206A.ssp";

PROC XCOPY IN=IN2 OUT=RX18 IMPORT;

Run;

PROC CONTENTS DATA= RX18.H206A;

TITLE “List of Variables SCRIPT 2018 MEPS”;

Run;

It gives me this in the log

LIBNAME RX18 "C:\Users\nidia\Documents\SASTHESIS";
NOTE: Libref RX18 refers to the same physical library as RX17.
NOTE: Libref RX18 was successfully assigned as follows:
Engine: V9
Physical Name: C:\Users\nidia\Documents\SASTHESIS
121 FILENAME IN2 "C:\Users\nidia\Documents\SASTHESIS\RX18\H206A.ssp";
122 PROC XCOPY IN=IN2 OUT=RX18 IMPORT;
123 Run;

NOTE: Input library IN2 is sequential.
ERROR: File is probably a cport file. XPORT engine unable to read file created by proc cport.
Please use proc cimport to convert this file to native format.
NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE XCOPY used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

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

Did you try using PROC CIMPORT instead as suggested by the log? Code is very similar, see the docs link for more details.

libname newlib 'sas-library';
filename tranfile 'transport-file';
                  
proc cimport library=newlib infile=tranfile;
run;