topic New SAS student in need of some help in New SAS User

New SAS student in need of some help

iyinope — Tue, 20 Sep 2022 06:35:08 GMT

Hi, so I am trying to use data step to read in the csv. file. I am looking for options in the INFILE statement and INFORMAT/FORMAT to use to make sure that I create the datasets correctly.

I tried to run it but the sex, name and race can out as dots.

I am new to SAS and a quick response would be appreciated.

Thank you 🙂

@SAS5

Re: New SAS student in need of some help

andreas_lds — Tue, 20 Sep 2022 07:15:56 GMT

Please post the code you have, so that we can suggest fixes.

Re: New SAS student in need of some help

ballardw — Tue, 20 Sep 2022 13:57:33 GMT

SAS, by default, will show a "dot" to represent a missing value for a numeric variable.

Typical causes would be values in the file that are read as numeric values that are not actually numeric such as "N/A" or ">45" or that are missing in the source file. If you see "Invalid data" messages in the log then then your values are not compatible with how you attempt to read the data. Without details it is extremely hard to make suggestions.

Best for debugging your particular problems are to go to the LOG. You can share the log by copying text of the program code you ran along with all the messages and notes. Then on the this forum open a text box using the </> icon that appears above the message window and pasting the copied text.

The text box is important because the main message window on this forum will reformat pasted text which can reduce the usefulness of the diagnostic messages SAS often provides for problems with code or data.

Re: New SAS student in need of some help

Tom — Tue, 20 Sep 2022 15:48:14 GMT

There is no need to attach files to share TEXT. Use the Insert Code button in the forum editor window to get a pop-up window where you can paste/edit the text.

ID_NUM,NAME,DOB,Sex,Race,MARITAL,OWNHOME,EDUCATION,EMPLOYED
110126,LLLLLLLL,2/23/1943,1,1,4,2,5,1
110010,AAAAAAAA,3/20/1954,1,3,3,1,7,4
110020,BBBBBBBB,8/1/1948,1,1,3,1,7,1
110031,CCCCCCCC,12/11/1952,1,1,3,1,5,1
110032,DDDDDDDD,8/1/1944,2,2,3,1,7,1
110037,EEEEEEEE,9/26/1968,1,1,3,1,5,1
110068,FFFFFFFF,10/9/1953,2,1,2,1,7,1
110075,GGGGGGGG,8/12/1942,2,1,3,1,7,4
110090,HHHHHHHH,8/7/1959,2,2,5,2,2,4
110098,IIIIIIII,2/16/1970,1,1,6,2,3,1
110120,JJJJJJJJ,11/22/1955,1,2,2,2,3,2
110121,KKKKKKKK,7/10/1946,1,1,3,1,3,1

Your file looks like a normal CSV (comma separated values) file.

You can easily write a DATA step to read such a file.

data want;
   infile 'Personal.csv' dsd truncover firstobs=2;
   input
     ID_NUM :$6.
     NAME :$20.
     DOB :mmddyy. 
     Sex Race MARITAL OWNHOME EDUCATION EMPLOYED
   ;
   format DOB yymmdd10.;
run;

Re: New SAS student in need of some help

Reeza — Tue, 20 Sep 2022 15:52:52 GMT

FYI - answers we give here likely won't match what you're being taught in courses.

Re: New SAS student in need of some help

iyinope — Thu, 06 Oct 2022 15:53:52 GMT

Yes, thank you so much.

Re: New SAS student in need of some help

iyinope — Thu, 06 Oct 2022 15:54:52 GMT

hmmmmm