This is a test version of Biostars. For the public version, visit https://www.biostars.org.
How to export a table from SAS software to Excel

Hi guys,

I'm facing with a working problem and I'm quite upset by it!

I've a file created on SAS (I've never used this statistical software until now!!!), in which there's a table with my data.

Now, I've to export this table from the SAS file to an Excel file, in order to analyze these data in R.

I don't know where to start, since I've never used SAS as written before...

I tried to run in SAS (SAS 9.4 TS Level 1M3) the following commands:

proc export
data = my_data
dbms = xlsx
outfile ="C:\Users\Desktop\my_data2.xlsx"

and I found the following error message:

ERROR 202-322: The option or parameter is not recognized and will be ignored.

Could someone help me?? Thank u!

sas
• 1,727 views • link
updated by Pierre Lindenbaum Pierre Lindenbaum • written by Fede_Santos95 • Fede_Santos95

This is not a bioinformatics-related question as it stands.

• 0 views • link
written by Sej Modha Sej Modha

Now, I've to export this table from the SAS file to an Excel file, in order to analyze these data in R.

you meant to a comma-separated-value file in order to analyze these data in R. didn't you ?

• 0 views • link
written by Pierre Lindenbaum Pierre Lindenbaum

0 answers

No answers yet.

Log in to answer this question.

More posts like this
  • Problems when trying to use ensembl-vep
    written by langziv • langziv
    Hi. I've been using ensembl-vep through Docker before and managed to use it, but now I'm encountering difficulties. I'm running the commands as instructed in …
  • Post-Imputation QC Problem
    written by Jesse • Jesse
    Edit: See answer. tl;dr: code should have been: plink2 --vcf [input-name] dosage=HDS --exclude-if-info "R2<=0.3" --export vcf --out [output-name] **Original post** I'm struggling with post-imputation processing …
  • Generating count table
    written by gokberk gokberk
    Hi all, I've been trying to calculate TPM values for a count table, thus I've been using biomaRt package to obtain gene lengths. However, I'm …
  • Error in transferring annotations to a new assembly using RATT
    written by Jautis Jautis
    Hello, I am using RATT to try and transfer gene annotations from a published genome to a new assembly for a sister taxa. However, I …
  • Running Freebayes on 100+ Samples
    written by tpaisie tpaisie
    Hi everyone, So I've been using Freebayes for a while now to do my variant calling with usually around 100-200 samples and I've never had …
  • fast-dump error, SRA Toolkit is Updated???
    written by oars oars
    I'm having a problem with the following command: fastq-dump --split-files --origfmt SRR1611183 Here is the error message: ``` 2018-03-06T01:50:18 fastq-dump.2.3.5 err: error unexpected while resolving …
  • How to compare expression in gene list
    written by Lila M Lila M
    Hi everybody, I'm trying to analyze a data set of genes. I have 3 gene list: P1 (n =312), P2 (n =7444) and P3 (n …
  • remove NAs from exprs(gset)
    written by randalljellis randalljellis
    Hello, I updated all of my Bioconductor packages and now I'm getting errors I've never seen before. For this one, I'm trying to remove NA …
  • Import Gene Symbol
    written by V V
    Hello, I'm fairly new to R and I'm having a small issue. I've generated a typical count table where the first column is a list …
  • Empty Output With Pacbiotoca
    written by Philipp Bayer Philipp Bayer
    <p>Hi! </p> <p>I'm currently playing around with PacBioToCA to improve the accuracy of my pacbio-reads, and I've been following their tutorial on sourceforge with a …