topic Re: why it doesn't work in SAS Procedures

why it doesn't work

tianerhu — Sat, 07 Mar 2020 01:23:09 GMT

data females;
set apple.survey;
where Gender = "F" ;
run;
pro print data = females;
run;

log:

516 data females;
517 set apple.survey;
ERROR: File APPLE.SURVEY.DATA does not exist.
518 where Gender = "F" ;
519 run;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.FEMALES may be incomplete. When this step was stopped there were 0
observations and 0 variables.
WARNING: Data set WORK.FEMALES was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.04 seconds

520 pro print data = females;
---
14
WARNING 14-169: Assuming the symbol PROC was misspelled as pro.
521 run;

NOTE: No observations in data set WORK.FEMALES.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds

Re: why it doesn't work

novinosrin — Sat, 07 Mar 2020 01:41:08 GMT

Can you check the contents of your APPLE library to confirm whether or not the dataset really exist?

proc contents data=apple._all_ nods;
run;

Re: why it doesn't work

tianerhu — Sat, 07 Mar 2020 01:49:11 GMT

Thank you .

Yes , i am not make sure that .

l always don't understand this point------- how to check check the contents of the APPLE library to confirm whether or not the dataset really exist?

Would you like teach me how to do that ?

Re: why it doesn't work

novinosrin — Sat, 07 Mar 2020 01:53:09 GMT

I requested you to run this earlier

proc contents data=apple._all_ nods;
run;

and let us know what you see in output window(list)

Re: why it doesn't work

tianerhu — Sat, 07 Mar 2020 02:02:09 GMT

data  females;
   set apple.survey;
where Gender = "F" ;
run;
proc contents data = apple._all_nods;
run;


/*
NOTE: The SAS System stopped processing this step because of errors.

543
544  data  females;
545     set apple.survey;
ERROR: File APPLE.SURVEY.DATA does not exist.
546  where Gender = "F" ;
547  run;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.FEMALES may be incomplete.  When this step was stopped there were 0
         observations and 0 variables.
WARNING: Data set WORK.FEMALES was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      cpu time            0.03 seconds


548  proc contents data = apple._all_nods;
ERROR: File APPLE._ALL_NODS.DATA does not exist.
549  run;

NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

NOTE: The SAS System stopped processing this step because of errors.

*/

Re: why it doesn't work

novinosrin — Sat, 07 Mar 2020 02:04:12 GMT

There is a blank space betweeen _all_ and nods. See below plz

proc contents data=apple._all_ nods;
run;

Re: why it doesn't work

tianerhu — Sat, 07 Mar 2020 02:21:00 GMT

Yes , it work well now.

i check that folder with your method , yes, the survey file is not there , and after i move the survey file to where it should be the code works .

Thank you so much.

Re: why it doesn't work

novinosrin — Sat, 07 Mar 2020 02:24:28 GMT

Good. I'm glad you've found it.

Re: why it doesn't work

Reeza — Sat, 07 Mar 2020 02:33:31 GMT

Please mark the question answered.