- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Did you assign library first?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;