topic Re: What is wrong with my programming here ? in New SAS User

What is wrong with my programming here ?

Godzilla_Hat — Thu, 30 Sep 2021 20:30:51 GMT

Can someone explain how do I fix my input to show the data correctly. I don't understand how it works. Can someone show me how the code should look ?

data hurricane1;
input name $ 1-7 year 8-12 deaths 13-17;
datalines;
Katrina	2005	1200
Andrew	1992	23
Charley	2004	10
Wilma	2005	5
Ivan	2004	25
Rita	2005	7
Frances	2004	6
Hugo	1989	21
Jeanne	2004	5
Floyd	1999	56
;
run;
proc print data=hurricane1;
run;

I really don't get how to use column inputs. What do I have to do ?

Re: What is wrong with my programming here ?

SASKiwi — Thu, 30 Sep 2021 20:39:44 GMT

There's nothing wrong with your program, but you have tabs in your data rows causing misalignments. Remove ALL tabs from your data lines and replace with spaces.

Re: What is wrong with my programming here ?

data_null__ — Thu, 30 Sep 2021 20:47:41 GMT

Your data have tabs. Use INFILE statement option EXPANDTABS;

data hurricane1;
   infile cards expandtabs;
   input name $ 1-7 year 8-12 deaths 13-17;
   datalines;
Katrina	2005	1200
Andrew	1992	23
Charley	2004	10
Wilma	2005	5
Ivan	2004	25
Rita	2005	7
Frances	2004	6
Hugo	1989	21
Jeanne	2004	5
Floyd	1999	56
;
run;
proc print data=hurricane1;
run;

Re: What is wrong with my programming here ?

Godzilla_Hat — Thu, 30 Sep 2021 20:44:19 GMT

So are the tabs for example the "1-7" ?

Re: What is wrong with my programming here ?

SASKiwi — Thu, 30 Sep 2021 20:52:08 GMT

No, you have tab characters between your data items: Katrina<tab>2005<tab>1200.

Remove the tabs or use @data_null__ 's solution.

Re: What is wrong with my programming here ?

data_null__ — Thu, 30 Sep 2021 21:00:32 GMT

Alternative would show the tabs some love. DSD and DLM= options.

data hurricane1;
   infile cards dsd dlm='09'x;
   input name $ year deaths;
   datalines;
Katrina	2005	1200
Andrew	1992	23
Charley	2004	10
Wilma	2005	5
Ivan	2004	25
Rita	2005	7
Frances	2004	6
Hugo	1989	21
Jeanne	2004	5
Floyd	1999	56
;
run;
proc print data=hurricane1;
run;

Re: What is wrong with my programming here ?

Godzilla_Hat — Thu, 30 Sep 2021 21:10:16 GMT

Thank you ! I was able to get it to work !