here is the work i did so far, is anyone can help me where is the problem and how can i fix it, thank you very much!
Not sure exactly what you are looking for since you are vague. My guess is you want to see the the obs value by Substance in a scatter plot? Do you care about the observation number? Also in the future can you paste code to create the sample data to make it easier for us to test code.
Like @Konu-Tec said, you probably need to 'melt' the data from wide to narrow. Sometimes called transpose. With SAS you can use PROC TRANPOSE.
Here is sample data I made using your image:
data outdata;
input Substance $ obs1-obs4;
datalines;
1 29 28 23 26
2 17 25 24 19
3 17 16 21 22
4 18 20 25 24
;
run;
Then transpose/melt the data from wide to narrow using PROC TRANPOSE:
proc transpose data=outdata
out=narrowdata(rename=(col1=Value))
name=ObsNumber;
by substance;
run;
proc print data=narrowdata;
run;
Now that the data is in narrow format. Use the SCATTER statement in SGPLOT.
proc sgplot data=narrowdata;
scatter x=Substance y=Value;
quit;
I don't like the default image, so you can begin to explore different options and statements in SGPLOT. I'm also not sure exactly what you are looking for, but here is a start:
title color=charcoal justify=left height=14pt "Value by Substance";
proc sgplot data=narrowdata;
scatter x=Substance y=Value /
group=Substance
markerattrs=(symbol=circleFilled);
keylegend / noborder title="";
yaxis values=(0 to 35 by 5);
quit;
title;
- Peter
You might want to melt the data set first or reshape your input
https://pandas.pydata.org/docs/reference/api/pandas.melt.html
Not sure exactly what you are looking for since you are vague. My guess is you want to see the the obs value by Substance in a scatter plot? Do you care about the observation number? Also in the future can you paste code to create the sample data to make it easier for us to test code.
Like @Konu-Tec said, you probably need to 'melt' the data from wide to narrow. Sometimes called transpose. With SAS you can use PROC TRANPOSE.
Here is sample data I made using your image:
data outdata;
input Substance $ obs1-obs4;
datalines;
1 29 28 23 26
2 17 25 24 19
3 17 16 21 22
4 18 20 25 24
;
run;
Then transpose/melt the data from wide to narrow using PROC TRANPOSE:
proc transpose data=outdata
out=narrowdata(rename=(col1=Value))
name=ObsNumber;
by substance;
run;
proc print data=narrowdata;
run;
Now that the data is in narrow format. Use the SCATTER statement in SGPLOT.
proc sgplot data=narrowdata;
scatter x=Substance y=Value;
quit;
I don't like the default image, so you can begin to explore different options and statements in SGPLOT. I'm also not sure exactly what you are looking for, but here is a start:
title color=charcoal justify=left height=14pt "Value by Substance";
proc sgplot data=narrowdata;
scatter x=Substance y=Value /
group=Substance
markerattrs=(symbol=circleFilled);
keylegend / noborder title="";
yaxis values=(0 to 35 by 5);
quit;
title;
- Peter
thank you so much! so here is another question that if i try to get the ANOVA table, i try the code:
proc anova data = outdata;
class Substance;
model Substance = value;
run;
but there is a error,
Glad it helped.
For your other question you should explore or post in the statistical procedures forum here: https://communities.sas.com/t5/Statistical-Procedures/bd-p/statistical_procedures.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.