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!
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.