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?
Super easy! I had no clue what a .JCL file was and couldn't find useful answers on Google.
THANK YOU!
JCL is most likely Job Control Language, which is the system language of IBM mainframes.
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.
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 25. 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.