SAS中proc transpose在R中的等价实现求助

Hey there! It's totally normal to hunt for R equivalents when switching from SAS—let's get you sorted out.

First off, could you share the SAS code you’re currently using? Dataset transformations cover a ton of ground (like reshaping data, recoding variables, merging datasets, filtering rows, etc.), and having your specific SAS snippet will let me give you a precise R match.

That said, here are a few common transformation examples to kick things off:

Example 1: Reshaping Data (Wide ↔ Long) #

SAS Code Example (Transposing to Long Format): #

proc transpose data=original out=long_format;
    id variable_name;
    var value_columns;
run;

R Equivalent (Using tidyr): #

library(tidyr)

long_format <- pivot_longer(original, 
                            cols = starts_with("value"), # Adjust to match your value columns
                            names_to = "variable_name",
                            values_to = "value")

Example 2: Filtering Rows & Selecting Columns #

SAS Code Example: #

data filtered_data;
    set original;
    where age > 18;
    keep id name age;
run;

R Equivalent (Using dplyr): #

library(dplyr)

filtered_data <- original %>%
    filter(age > 18) %>%
    select(id, name, age)

Example 3: Recoding Categorical Variables #

SAS Code Example: #

data recoded_data;
    set original;
    if gender = "M" then gender_code = 1;
    else if gender = "F" then gender_code = 2;
    else gender_code = 9;
run;

R Equivalent (Using dplyr): #

library(dplyr)

recoded_data <- original %>%
    mutate(gender_code = case_when(
        gender == "M" ~ 1,
        gender == "F" ~ 2,
        TRUE ~ 9
    ))

Once you share your specific SAS code, I can tweak the R code to fit your exact use case perfectly!

内容的提问来源于stack exchange，提问作者Houssem Missaoui