About SASsyAndre

SASsyAndre · ‎07-09-2020

It took a lot of tinkering as I am still new to SAS but it eventually got there. THANK YOU!

SASsyAndre · ‎07-09-2020

Thank you, you fixed my obs problem! I have a syntax error and or not fully understand what you meant as it hasn't worked yet. Here are some examples of the code I have tried. data change_vigor; set WORK.flaxIn; name=tranwrd(name,'Vigor','Plant'); run; #followed by the previous code I had. and proc transpose data=WORK.flaxIn name=tranwrd(name,'Vigor','Plant') out=Transtrial4(rename=(col1=VigorScore _name_=Plant_Number)drop=_label_) ; Title 'Transposed_VigorList'; var Vigor1-Vigor5; by Species_source NOTSORTED; run; I tried following this guide after your suggestion to use TRANWRD; https://amadeus.co.uk/tips/find-and-replace-in-sas/

SASsyAndre · ‎07-09-2020

I am attempting to extract, transpose, and organize the vigor columns by each species source. I will then repeat this with the Growth form. My starting data looks like this. Row Plot Species_source VIGOR1 Growth_fm1 VIGOR2 Growth_fm2 VIGOR3 Growth_fm3 VIGOR4 Growth_fm4 VIGOR5 Growth_fm5 1 1 14 0 0 3 1 4 1 0 0 3 1 1 2 22 2 2 1 2 1 1 2 3 2 3 1 3 20 2 2 3 2 3 2 3 3 0 0 1 4 40 2 2 3 1 2 3 3 2 4 2 I have produced the next table using this code: proc transpose data=WORK.flaxIn out=Transtrial4(rename=(col1=VigorScore _name_=Plant_Number)drop=_label_) ; Title 'Transposed_VigorList'; var Vigor1-Vigor5; by Species_source NOTSORTED; run; Proc print data=Transtrial4;run; How can I change VIGOR1 - VIGOR5 to Plant1 -Plant 5? Additionally, can I drop the obs column? Thank you!

Online Status	Offline
Date Last Visited	‎07-09-2020 03:03 PM

Re: Changing transposed variable names in table

Re: Changing transposed variable names in table

Changing transposed variable names in table

Re: Changing transposed variable names in table

Re: Changing transposed variable names in table

Re: Changing transposed variable names in table

Changing transposed variable names in table