As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Tip of the Day:October 10

From sasCommunity
Jump to: navigation, search

sasCommunity Tip of the Day

When using PROC TRANSPOSE, the ID statement is used to tell SAS how to NAME the variables resulting from the transpose. You can also tell SAS how to LABEL the resulting variables, by using the value of a variable in the original dataset, just as is done with the ID statement. For example:

  proc transpose data=test out=newtest prefix=visit;
    by subjid;
    var labres;
    id visit;
    idlabel visitl;
  run;

SAS will name the variables VISITx .. VISITy based on the values in the VISIT variable. And will ALSO label VISITx with the corresponding value from VISITL on the given record and label VISITy with the corresponding value from VISITL on the given record for all created variables.

Submitted by AYW Training and Consulting. Contact me at my Discussion Page.



Feel free to comment on this tip.


Prior tip - Next tip - Random Tip

Submit a Tip