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
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.
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?
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.
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.
@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.
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.
Did you assign library first?
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
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.