Creating a SAS Data Set from a Space-delimited Raw Data File

smart — Sun, 02 Dec 2018 23:38:56 GMT

The SAS help community has always been very valuable for a beginner like me. Hoping someone can take the time to please help me again! Here is my code thus far:

filename rawdata '/courses/ddb976e5ba27fe300/NHANES 2013_2014/alcohol.dat';

data Alcohol (keep = SEQN ALQ120Q);
infile rawdata;
run;
proc print data=Alcohol;
run;

***I have no errors, but this warning keeps popping up "The table "WORK.ALCOHOL" cannot be opened because it does not contain any columns."***

Here is my task if more information is needed on what I am trying to do:

The codebook, which shows the variable labels and formats, is available at:

https://wwwn.cdc.gov/Nchs/Nhanes/2013-2014/ALQ_H.htm#SEQN

Import the alcohol.dat data into a temporary SAS data set called Alcohol. The alcohol.dat file is stored in the /courses/ddb976e5ba27fe300/NHANES 2013_2014folder. The data values represent SEQN, ALQ101, ALQ110, ALQ120Q, ALQ120U, ALQ130, ALQ141Q, ALQ141U, ALQ151, and ALQ160, respectively.

The alcohol data set should contain only the following variables:

Sequence Number and Number of Drinks Per Day for the Past 12 Months

The two variables in the Alcohol data set should have permanently assigned variable labels.

Re: Creating a SAS Data Set from a Space-delimited Raw Data File

ChrisBrooks — Mon, 03 Dec 2018 00:17:09 GMT

You're missing an INPUT statement listing the variables - add that and you should be fine.

You can find the full syntax here -> https://documentation.sas.com/?docsetId=lestmtsref&docsetTarget=n0oaql83drile0n141pdacojq97s.htm&docsetVersion=9.4&locale=en

Re: Creating a SAS Data Set from a Space-delimited Raw Data File

Reeza — Mon, 03 Dec 2018 04:18:30 GMT

https://stats.idre.ucla.edu/sas/faq/how-do-i-read-in-a-delimited-ascii-file-in-sas/

topic Creating a SAS Data Set from a Space-delimited Raw Data File in SAS Studio

Creating a SAS Data Set from a Space-delimited Raw Data File

Re: Creating a SAS Data Set from a Space-delimited Raw Data File

Re: Creating a SAS Data Set from a Space-delimited Raw Data File