- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hello --
This is probably super simple and I am just overthinking things, but I am using SAS UE and am having issue reading in my data. It is saved in a different format than I am used to, and don't know if that is the issue, or what. It is a jcl file instead of csv, dat, sas, etc...
I am utilizing the RCG survey data from 1991, which is available publicly through the NCES. When you download the files from their site, you get a jcl file for SAS and SPSS, and a dat file. I would like to use the dat file, but it doesn't have any variable names (so I don't have anything for an input statement in my example below), and when I asked the contact at the NCES, they said variable names are available in the jcl file.
I have tried:
DATA RCG;
INFILE '/folders/myfolders/data/PC1P_SAS.JCL';
RUN;
I did try another approach as well, but I either get an error that the file doesn't exist, or that the file does not contain any columns.
I also tried attaching the file to this post, but it says the contents of the attachment doesn't match its file type. Maybe that's my problem?
Any ideas?
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Make sure to put the .DAT file in your myfolders or setup a shortcut path to the folder desired.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Make sure to put the .DAT file in your myfolders or setup a shortcut path to the folder desired.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Super easy! I had no clue what a .JCL file was and couldn't find useful answers on Google.
THANK YOU!
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
JCL is most likely Job Control Language, which is the system language of IBM mainframes.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
They probably saved it as .jcl files because you can embed the SAS code in JCL scripts and feed the sysin from there; small programs are often run like that.