BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
serges007
Fluorite | Level 6

Hi, I am starting my SAS certification training session and I have a small problem with accessing the data. I don't know but I have an error when I submit my first exercise:
ERROR: File RESULTS.OUTPUT04.DATA does not exist.
ERROR: Library CERT does not exist.

However I have created the folders in the files(home). I have also created the requested libraries:

%let path=/home/u49976893/cert/input;
libname cert "&path";

%let path=/home/u49976893/cert/output;
libname results "&path";

Here is my sub-code:

data cert.input04;
set results.output04;
length var3 $ 5;
var1=ceil(var1);
var2=ceil(var2);
var3=var1*var2;
var20=sum(of var12-var19);
run;

I make you here a screen capture of my workspace moreover I make you a capture of the statements of the exercises. but for my part it is specified null part where to import the data of the exam

3.png2.png1.png

1 ACCEPTED SOLUTION

Accepted Solutions
serges007
Fluorite | Level 6

Salut, je changed but I have the same error

 

data results.output04;
set cert.input04;
length var3 $ 5;
var1=ceil(var1);
var2=ceil(var2);
var3=var1*var2;
var20=sum(of var12-var19);
run;

 

ERROR: File CERT.INPUT04.DATA does not exist.

ERROR: Library RESULTS does not exist. 

View solution in original post

10 REPLIES 10
andreas_lds
Jade | Level 19

The data statement names the dataset to be created, while the set-statement names the datasets to be processed.

You should also check the log: are both libraries successfully assigned?

ballardw
Super User

The data step works like this:

 

Data nameofoutputdataset;

    set nameofinputdataset.

 

Your code has them backwards.

You have not yet created the results.output04 so of course it does not exist.

serges007
Fluorite | Level 6

Salut, je changed but I have the same error

 

data results.output04;
set cert.input04;
length var3 $ 5;
var1=ceil(var1);
var2=ceil(var2);
var3=var1*var2;
var20=sum(of var12-var19);
run;

 

ERROR: File CERT.INPUT04.DATA does not exist.

ERROR: Library RESULTS does not exist. 

ballardw
Super User

@serges007 wrote:

Salut, je changed but I have the same error

 

data results.output04;
set cert.input04;
length var3 $ 5;
var1=ceil(var1);
var2=ceil(var2);
var3=var1*var2;
var20=sum(of var12-var19);
run;

 

ERROR: File CERT.INPUT04.DATA does not exist.

ERROR: Library RESULTS does not exist. 


Usually indicates a failure to execute the set up of the materials correctly from a previous step.

 

The first code you show also has both libraries pointing to the same path which might be an issue, possibly in the spelling in the Path macro variable.

serges007
Fluorite | Level 6

hi ballard, thanks for your observation, I pointed the libraries in different directories, the code is executed but there is no data in the output table and there is an error generated:

ERROR: File CERT.INPUT04.DATA does not exist.

 

tarheel13
Rhodochrosite | Level 12

Did you assign library first? 

Cynthia_sas
SAS Super FREQ
Hi:
The instructions clearly say that you should have an input folder under the cert folder but under your cert folder, you only have programs and results. You do not have an input folder or an output folder. I would recommend that you go back to the beginning instructions and follow the instructions again for making the data on the SAS OnDemand for Academics server.
Cynthia
serges007
Fluorite | Level 6
Hi Cynthia , the instructions are there and I can't see anywhere where it is indicate the link to download the input data.
serges007
Fluorite | Level 6

Thanks Cynthia, you were absolutely right, I am in the wrong working environment, I should be in SAS virtual Labs, for that it was enough to click on create user and follow the instructions. Sorry everyone for the inconvenience

Harichandana19
Calcite | Level 5

You need to derive the data from the input folder 

hence your code should be 

data program04; /*or whatever name you want to give for the dataset

set cert.input04;

 

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 10 replies
  • 3944 views
  • 1 like
  • 6 in conversation