Hello
I'm a student using SASV9.4 with parallels on my MacBook. I used the following code and it ran without errors
libname EPID5205 '\\Mac\Home\Desktop\EPID5205';
%include'\\Mac\Home\Desktop\EPID5205\Final_Formats_NYCHANES-2013-14_AnalyticDB_042618.sas';
run;
data EPID5205.NYCH14;
set EPID5205.public_v3_051419;
run;
data EPID5205.NYCH14;
set EPID5205.public_v3_051419;
if HIQ_1 =.d then delete;
if HIQ_1 =.r then delete;
if us_born =.d then delete;
if us_born =.r then delete;
run;
However when I try :
proc freq data=EPID5205.NYCH14;
tables HIQ_1 / plots=(freqplot);
run;
It returns the error below:
5384 proc freq data=EPID5205.NYCH14;
ERROR: File EPID5205.NYCH14.DATA does not exist.
5385 tables HIQ_1 / plots=(freqplot);
ERROR: No data set open to look up variables.
5386 run
I can see the NYCH14 dataset in the EPID5205 library but when I try to open it says EPID5205.nych14 either does not exist or cannot be displayed.
Any suggestions ?
Thanks
Make sure that the filename of nych14.sas7bdat is all lowercase.
Make sure that the filename of nych14.sas7bdat is all lowercase.
That fixed it thanks!
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 16. 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.