topic Re: Libname Error Help in New SAS User

Libname Error Help

bhufman — Thu, 03 Dec 2020 02:23:14 GMT

Hi everyone,

Below is the Libname statements I am using, I keep getting an Error on Libname "HypeResults." Here is a copy of the Libname and the log:

%LET CourseRoot = /folders/myfolders/My Folders/BIOS6680;
LIBNAME HypTabs "/folders/myfolders/My Folders/BIOS6680/Cancer RCT/Data/3_Tabulations";
LIBNAME Hypan1 "/folders/myfolders/My Folders/BIOS6680/Cancer RCT/Data/4_Analysis";
Libname HypResults "/folders/myfolders/My Folders/BIOS6680/Cancer RCT/Data/5_Results";
/* Enter additional LIBNAME statements */
/* Enter any necessary options in an OPTIONS statement*/
OPTIONS FMTSEARCH= (Hyptabs.hypformats WORK LIBRARY)
NOFMTERR;

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73 * Instructions:

74 1) Change the path in the %LET statement to the location of the BIOS 6680 course root folder

75 2) Submit the %LET and LIBNAME statements below *;

76 %LETCourseRoot = /folders/myfolders/My Folders/BIOS6680;

77 LIBNAME HypTabs"/folders/myfolders/My Folders/BIOS6680/Cancer RCT/Data/3_Tabulations";

NOTE: Libref HYPTABS was successfully assigned as follows:

Engine: V9

Physical Name: /folders/myfolders/My Folders/BIOS6680/Cancer RCT/Data/3_Tabulations

78 LIBNAME Hypan1 "/folders/myfolders/My Folders/BIOS6680/Cancer RCT/Data/4_Analysis";

NOTE: Libref HYPAN1 was successfully assigned as follows:

Engine: V9

Physical Name: /folders/myfolders/My Folders/BIOS6680/Cancer RCT/Data/4_Analysis

79 Libname HypResults "/folders/myfolders/My Folders/BIOS6680/Cancer RCT/Data/5_Results";

ERROR: HypResults is not a valid SAS name.

ERROR: Error in the LIBNAME statement.

80 /* Enter additional LIBNAME statements */

81 /* Enter any necessary options in an OPTIONS statement*/

82 OPTIONS FMTSEARCH= (Hyptabs.hypformats WORK LIBRARY)

83 NOFMTERR;

86 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Do you initially see anything wrong with my HypResults Libname?

Re: Libname Error Help

Allie_Haun — Thu, 03 Dec 2020 02:35:49 GMT

Hi there!

I believe this naming convention may be too long. Try "HypRslt" instead of HypResults

Re: Libname Error Help

ballardw — Thu, 03 Dec 2020 04:17:50 GMT

Libname HypResults "/folders/myfolders/My Folders/BIOS6680/Cancer RCT/Data/5_Results";

Libnames are always limited to a maximum of 8 characters, the first character must be a letter or the _ character, others letter, digit or _. No other characters allowed.

Re: Libname Error Help

AnnaWoolery — Sun, 06 Dec 2020 18:49:16 GMT

Hi Breanna,

Another issue you may be having is that your LIBNAME statements include "Cancer RCT" in the location route. I believe this should be "Hypertension Study" instead. Hope this also helps 🙂

LIBNAME HypTabs "/folders/myfolders/My Folders/BIOS6680/Cancer RCT/Data/3_Tabulations";
LIBNAME Hypan1 "/folders/myfolders/My Folders/BIOS6680/Cancer RCT/Data/4_Analysis";
Libname HypResults "/folders/myfolders/My Folders/BIOS6680/Cancer RCT/Data/5_Results";

Re: Libname Error Help

Rohan_Garg4 — Tue, 15 Dec 2020 22:26:17 GMT

Hey BHufman,

Regarding your libname error, I am pretty sure the libname statement can only be 8 character long. So would need to reduce it HypRslts at the max in order have it be valid.

Re: Libname Error Help

bfreeman0402 — Wed, 16 Dec 2020 05:20:25 GMT

Hi Bre!

I was having a really similar issue when working with the HypAnalysis1 data set for homework. I think your LIBNAME statement might be too long (I used HypRes)! Also, im not sure what version of SAS you may be using but I had a ton of issues with SAS OnDemand when I was using it (raw data wouldn't open, libraries weren't saving correctly, etc) and I can honestly say when I downloaded university edition I had way less issues like this! Hope this helps 🙂

Best,

Brandon