BookmarkSubscribeRSS Feed
kngu022
Obsidian | Level 7

To whom it may concerns, 

 I am very new SAS user and I am using the university Edition version. I have tried to do my exercise on SAS and the result comes out like screenshot below.

Screen Shot 2020-01-14 at 5.07.17 AM.png

However, the diabetes.sas7bdat actually exits and does contains column. I tried the same thing on Uni computer. It is fine.  I am not too sure what mistake I did? Could you help me please?

Thanks 

Khanh Nguyen

8 REPLIES 8
novinosrin
Tourmaline | Level 20

Hi @kngu022  Can you plz check what is in the A1 library using proc contents

 

proc contents data=a1._all_ nods;
run;

and let us know

kngu022
Obsidian | Level 7

I just tried what you just showed and the result like thisScreen Shot 2020-01-14 at 5.27.26 AM.png

novinosrin
Tourmaline | Level 20

Hello @kngu022  Please make sure there is a space between _all_ and nods. Review your code and the example I posted earlier. Here it is again

 

proc contents data=a1._all_ nods;
run;
kngu022
Obsidian | Level 7

I just tried it again and the results isScreen Shot 2020-01-14 at 5.37.24 AM.png

novinosrin
Tourmaline | Level 20

so where is the Diabetes dataset?

 

That doesn't seem to be in the library

kngu022
Obsidian | Level 7

 

 

1Screen Shot 2020-01-14 at 5.41.45 AM.png

 

The diabetes is inside the A1 file. I just wonder how can I include the diabetes dataset? 

regards, 

 

novinosrin
Tourmaline | Level 20

Okay so make sure your path is full and correct in the libname statement pointing to the A1 folder. Then, reassign libname and check

kngu022
Obsidian | Level 7

Thanks. I successfully got it. 

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 8 replies
  • 1164 views
  • 0 likes
  • 2 in conversation