topic Re: Missing values are don't recognized correctly while importing TAB delimited files. in New SAS User

Missing values are don't recognized correctly while importing TAB delimited files.

riccardo88 — Fri, 08 Mar 2019 10:45:32 GMT

Hallo,

I'm importing some TAB delimited .txt files to SAS. In the files some values are missing.

Here my code:

filename inn 'G:\***\**\*****\BBB101-07022019-0934.txt';
data innocor_full;
infile inn dlm='09'x dsd firstobs=16;
input Time Arbeitsbelastung HR Atemfrequenz Ve VCO2 VO2 R VO2/HR FO2et FCO2et Ve/VCO2	Ve/VO2 SpO2 VO2/kg	VO2/BSA	FiCO2 FiO2 Va Vt Vd	Geschwindigkeit	Steigung DIA SYS MAP VeVCO2slp VO2loadSlp CoVo2slp BRper FEV1 FVC PEF MEF75 MEF50 MEF25 FET FEV1per MVV heigth weight BSA Alter UmgDruck UmgTemp UmgFeucht cvp1 PO2	PCO2 pH	BE HCO3;
run;

Whit this code I get wrongly all the missing values at the end like this:

this is wrong since most of the missing values are relatives to other variables. I tought this would have been solved writing the DSD Option.

Can someone help me spot the mistake?

Thank you!

Re: Missing values are don't recognized correctly while importing TAB delimited files.

RW9 — Fri, 08 Mar 2019 10:55:14 GMT

Have you tried missover option?

Also your variable names are not sas compliant:

VO2/kg

Variable names cannot - and should not contain special characters. I assume you changed the system option to be able to do this, however do not do this. Its quite possible that this also has some impact.

Re: Missing values are don't recognized correctly while importing TAB delimited files.

riccardo88 — Fri, 08 Mar 2019 10:57:36 GMT

Thank you very much! After modifying the variable's names it works.