SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
ANKH1
Pyrite | Level 9

Hi, I am trying to open and work with a SAS dataset provided by the CDC in this link:

https://www.cdc.gov/nccdphp/dnpao/growthcharts/resources/sas.htm

 

The dataset is the one under step 1 for instructions for SAS users.

 

I downloaded the file and copied it in a folder in SAS studio. I tried opening just from the folder and by calling it in a data step but it says it doesn't exist. The error when clicking in the file (from the folder) says: File_TEMP1.CDCREF_D.DATA does not exist.

 

However, the file opens from SAS universal viewer. How can I open it from SAS studio?

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

Try changing the name to all lower case and accessing the file that way.

 

EDIT: Tested, works when the data set is all lower case, weird quirk of unix file systems. 

View solution in original post

3 REPLIES 3
Reeza
Super User

Try changing the name to all lower case and accessing the file that way.

 

EDIT: Tested, works when the data set is all lower case, weird quirk of unix file systems. 

ANKH1
Pyrite | Level 9

Worked! Thank you so much! 

Tom
Super User Tom
Super User

Weird quirk of the DOS/Windows file system.  It forces file names to be non-case sensitive.  So in DOS you can reference a file that is named with uppercase letters with a name that only uses lowercase letters.  In Unix those are two different file names.

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1469 views
  • 0 likes
  • 3 in conversation