topic Re: How to line plot all info without transpose?! in SAS Programming

How to line plot all info without transpose?!

hellohere — Thu, 22 Jan 2026 04:18:28 GMT

I have data below. Dataset also attached.

How to line plot all the info into one Picture, without Proc Transpose?!

Ten lines: one row for each

y=the value of off_max_ct_xx:

x=100/80/60/40/30/20/10/5 at the column names[off_max_ct_xx]

Thanks,

Re: How to line plot all info without transpose?!

hellohere — Thu, 22 Jan 2026 04:32:48 GMT

Transpose is fine if too tough to do so.

Re: How to line plot all info without transpose?!

Ksharp — Thu, 22 Jan 2026 07:51:03 GMT

libname x v9 'C:\Users\xiakeshan\Documents\Downloads';
data x;
 set x._t_mm_temp_coll_n;
 array _x{*} off_max_ct_: ;
 do i=1 to dim(_x);
   y=_x{i};
   x=input(scan(vname(_x{i}),-1,'_'),best.);
   output;
 end;
 keep x y xahead;
run;

proc sgplot data=x;
series x=x y=y /group=xahead ;
run;

Re: How to line plot all info without transpose?!

PaigeMiller — Thu, 22 Jan 2026 10:21:38 GMT

@hellohere wrote:

I have data below. Dataset also attached.

How to line plot all the info into one Picture, without Proc Transpose?!

Ten lines: one row for each

y=the value of off_max_ct_xx:

x=100/80/60/40/30/20/10/5 at the column names[off_max_ct_xx]

Thanks,

Best practice is to NOT arrange the data like this in the first place. Specifically, you have incorporated some meaningful data that the plot needs in the variable name — in this case, specifically, the data in the variable name is the _100 and _80 and so on. Data belongs in variable values, not in the variable name.

So a better arrangement would be to have the 100 and 80 and so on in their own variable, perhaps named VALUE, which contains the numeric values 100 and 80 and so on. This is called a long data set, and is always preferable to storing data in variable names. Why? Because most SAS procedures are designed to work on long data sets. In your case, the graph you want can ONLY be created from a long data set, so a transpose is required, and @Ksharp has provided a transpose for you, even if it is not PROC TRANSPOSE.

See Maxim 19.

Re: How to line plot all info without transpose?!

hellohere — Thu, 22 Jan 2026 11:29:36 GMT

Thanks for your suggestion. The columns are gotten from SQL once for all. I know how to transpose, just feel

something can be better.