topic Re: problem to access data in my SAS training exam in SAS Programming

problem to access data in my SAS training exam

serges007 — Fri, 20 Aug 2021 09:20:49 GMT

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

Re: problem to access data in my SAS training exam

andreas_lds — Fri, 20 Aug 2021 10:30:01 GMT

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?

Re: problem to access data in my SAS training exam

ballardw — Fri, 20 Aug 2021 11:54:15 GMT

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.

Re: problem to access data in my SAS training exam

serges007 — Fri, 20 Aug 2021 12:33:11 GMT

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.

Re: problem to access data in my SAS training exam

ballardw — Fri, 20 Aug 2021 14:58:49 GMT

@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.

Re: problem to access data in my SAS training exam

serges007 — Fri, 20 Aug 2021 20:55:52 GMT

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.

Re: problem to access data in my SAS training exam

tarheel13 — Fri, 20 Aug 2021 21:39:40 GMT

Did you assign library first?

Re: problem to access data in my SAS training exam

Cynthia_sas — Sat, 21 Aug 2021 15:09:28 GMT

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

Re: problem to access data in my SAS training exam

serges007 — Sun, 22 Aug 2021 06:23:51 GMT

Hi Cynthia , the instructions are there and I can't see anywhere where it is indicate the link to download the input data.

Re: problem to access data in my SAS training exam

serges007 — Sun, 22 Aug 2021 06:50:21 GMT

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

Re: problem to access data in my SAS training exam

Harichandana19 — Wed, 09 Nov 2022 12:13:08 GMT

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;