topic Re: dat file 1st observation in SAS Programming

dat file 1st observation

Sou1 — Thu, 30 Apr 2020 08:42:28 GMT

Hi,

I have successfully updated this dat file but the first observation is the variables (see attachment).

This is the code I have used it:

DATA patients;
INFILE '/.../uis.dat';
INPUT id $ age $ gender;
RUN;

How can I fix this?

Thanks!

Re: dat file 1st observation

Kurt_Bremser — Thu, 30 Apr 2020 08:59:30 GMT

Add

firstobs=2

to the INFILE statement.

Re: dat file 1st observation

Sou1 — Thu, 30 Apr 2020 09:04:13 GMT

Thanks so much!!

: )))))

Re: dat file 1st observation

sdhilip — Thu, 30 Apr 2020 09:05:57 GMT

Hi

You can use this

DATA patients;
INFILE '/.../uis.dat';
INPUT id $ age $ gender;
RUN;

Data patient_new;
set patients(firstobs = 2);
run;

This will create a dataset from the second observation

Re: dat file 1st observation

Kurt_Bremser — Thu, 30 Apr 2020 09:29:23 GMT

Given what I saw in your screenshot, I suggest changes to your code:

data patients;
infile '/.../uis.dat' firstobs=2;
input id $ age gender $;
run;

as age is always numeric, and gender might actually be a character value. Once you know what is in the character columns, you can adapt the lengths by using a informat.

I also guess that the trailing n for the physical filename is not needed.

BTW, you do not need to encapsulate screenshots in Word documents. Save your screenshot as a picture, and use the "camera" icon to insert the picture directly in your post. Word documents make it harder for many of us to view the picture, as corporate firewalls block the download of a .docx and/or the use of the previewer (as that works on a cloud storage service)