SAS will not show my 2 variables correctly

[kmendonsa]

Can someone PLEASE help me.....I am very NEW to SAS and taking it as part of a Data Science course at SMU.  I am trying to run a simple proc print data with just two variables...1 numeric and the other string.  I am using the $ sign to denote a string variable but when the results display I see just dashes/periods in the first column and the two variables concatenated in the second column.  The first is the numeric variable and the second is the string variable. 

Here's the data....and code

data creativity;

input score treatment_s $;

datalines;

5	Extrinsic
5.4	Extrinsic
6.1	Extrinsic
10.9	Extrinsic
11.8	Extrinsic
12	Extrinsic
12.3	Extrinsic
14.8	Extrinsic
15	Extrinsic
16.8	Extrinsic
17.2	Extrinsic
17.2	Extrinsic
17.4	Extrinsic
17.5	Extrinsic
18.5	Extrinsic
18.7	Extrinsic
18.7	Extrinsic
19.2	Extrinsic
19.5	Extrinsic
20.7	Extrinsic
21.2	Extrinsic
22.1	Extrinsic
24	Extrinsic
12	Intrinsic
12	Intrinsic
12.9	Intrinsic
13.6	Intrinsic
16.6	Intrinsic
17.2	Intrinsic
17.5	Intrinsic
18.2	Intrinsic
19.1	Intrinsic
19.3	Intrinsic
19.8	Intrinsic
20.3	Intrinsic
20.5	Intrinsic
20.6	Intrinsic
21.3	Intrinsic
21.6	Intrinsic
22.1	Intrinsic
22.2	Intrinsic
22.6	Intrinsic
23.1	Intrinsic
24	Intrinsic
24.3	Intrinsic
26.7	Intrinsic
29.7	Intrinsic

proc print data=creativity;

run;

here's the result I get...see attached.  THANKS!!!

[art297]

I can only guess. Are your two fields separated by a tab? If so, try:

data creativity;
  infile dataline delimiter='09'x;
  input score treatment_s $;
datalines;

Art, CEO, AnalystFinder.com

[kmendonsa]

Thanks so much for the response. It appears that excel does use the tab separator.


I tried your solution but it did not work...just the one row that I manually cleared out the tab and added a space


data creativity;
infile dataline delimiter='09'x;
input Score Treatment $;
datalines;
5 Extrinsic
5.4 Extrinsic
6.1 Extrinsic
10.9 Extrinsic
11.8 Extrinsic
12 Extrinsic
12.3 Extrinsic
14.8 Extrinsic
15 Extrinsic
16.8 Extrinsic
17.2 Extrinsic
17.2 Extrinsic
17.4 Extrinsic
17.5 Extrinsic
18.5 Extrinsic
18.7 Extrinsic
18.7 Extrinsic
19.2 Extrinsic
19.5 Extrinsic
20.7 Extrinsic
21.2 Extrinsic
22.1 Extrinsic
24 Extrinsic
12 Intrinsic
12 Intrinsic
12.9 Intrinsic
13.6 Intrinsic
16.6 Intrinsic
17.2 Intrinsic
17.5 Intrinsic
18.2 Intrinsic
19.1 Intrinsic
19.3 Intrinsic
19.8 Intrinsic
20.3 Intrinsic
20.5 Intrinsic
20.6 Intrinsic
21.3 Intrinsic
21.6 Intrinsic
22.1 Intrinsic
22.2 Intrinsic
22.6 Intrinsic
23.1 Intrinsic
24 Intrinsic
24.3 Intrinsic
26.7 Intrinsic
29.7 Intrinsic
;

proc print data=creativity;
run;

[Shmuel]

Change informat to best.1

No need to change the format

[Shmuel]

You miss INFORMAT to define how to read the score correctly and a FORMAT how to display it:

data creativity;
input score 4.1   treatment_s  $;
format scrore 4.1;
datalines;
... your data and next code ...

[art297 · Accepted solution]

There was an error in the code I originally suggested. It should have been datalines (not dataline as I had posted). Try (it worked for me using SAS UE):

data creativity;
  infile datalines delimiter='09'x;
  input score treatment_s $;
  datalines;
5	Extrinsic
5.4	Extrinsic
6.1	Extrinsic
10.9	Extrinsic
11.8	Extrinsic
12	Extrinsic
12.3	Extrinsic
14.8	Extrinsic
15	Extrinsic
16.8	Extrinsic
17.2	Extrinsic
17.2	Extrinsic
17.4	Extrinsic
17.5	Extrinsic
18.5	Extrinsic
18.7	Extrinsic
18.7	Extrinsic
19.2	Extrinsic
19.5	Extrinsic
20.7	Extrinsic
21.2	Extrinsic
22.1	Extrinsic
24	Extrinsic
12	Intrinsic
12	Intrinsic
12.9	Intrinsic
13.6	Intrinsic
16.6	Intrinsic
17.2	Intrinsic
17.5	Intrinsic
18.2	Intrinsic
19.1	Intrinsic
19.3	Intrinsic
19.8	Intrinsic
20.3	Intrinsic
20.5	Intrinsic
20.6	Intrinsic
21.3	Intrinsic
21.6	Intrinsic
22.1	Intrinsic
22.2	Intrinsic
22.6	Intrinsic
23.1	Intrinsic
24	Intrinsic
24.3	Intrinsic
26.7	Intrinsic
29.7	
Intrinsic
 
proc print data=creativity;
run;