topic Re: SAS will not show my 2 variables correctly in SAS Studio

SAS will not show my 2 variables correctly

kmendonsa — Sat, 02 Sep 2017 15:44:25 GMT

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!!!

Re: SAS will not show my 2 variables correctly

art297 — Sat, 02 Sep 2017 16:31:30 GMT

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

Re: SAS will not show my 2 variables correctly

Shmuel — Sat, 02 Sep 2017 16:35:16 GMT

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 ...

Re: SAS will not show my 2 variables correctly

kmendonsa — Sat, 02 Sep 2017 16:36:05 GMT

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;

Re: SAS will not show my 2 variables correctly

Shmuel — Sat, 02 Sep 2017 16:40:14 GMT

Change informat to best.1

No need to change the format

Re: SAS will not show my 2 variables correctly

art297 — Sat, 02 Sep 2017 16:47:44 GMT

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;