topic Re: Variables (chra) mixed with the observation(numeric) in New SAS User

Variables (chra) mixed with the observation(numeric)

nana_confused — Sun, 24 Sep 2023 22:06:15 GMT

DATA CoImpt.disabilities;
INFILE "/home/u63555769/Project/Data/1_Source/disabilities.txt" delimiter ='&' ;
INPUT tract_fips $10.
pctn_disability :$4.;
run;

The tract_fips and disability appeared as the first observation. It suppose to be the header. Any suggestion.

Thank you in advance for your help

Re: Variables (chra) mixed with the observation(numeric)

Tom — Sun, 24 Sep 2023 22:23:28 GMT

If you don't want to read the first line of the text file then use FIRSTOBS=2 option on the INFILE statement.

Also do NOT use formatted mode input for the first variable. Use LIST MODE like you did for the second variable. Add the : modifier in front of both informats.

data CoImpt.disabilities;
  infile "/home/u63555769/Project/Data/1_Source/disabilities.txt" dlm='&' firstobs=2;
  input tract_fips :$10. pctn_disability :$4.;
run;

Or remove the informats and DEFINE the variable before using them in the INPUT statement.

data CoImpt.disabilities;
  infile "/home/u63555769/Project/Data/1_Source/disabilities.txt" dlm='&' firstobs=2;
  length tract_fips $10 pctn_disability $4;
  input tract_fips pctn_disability ;
run;

Re: Variables (chra) mixed with the observation(numeric)

nana_confused — Mon, 25 Sep 2023 17:25:29 GMT

Thank you so much. The issue with the code it resolved now.