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!!!
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;
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
Change informat to best.1
No need to change the format
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 ...
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.