topic Re: Transfer data and loops in SAS Programming

Transfer data and loops

gretaolsson — Thu, 13 Apr 2017 09:43:03 GMT

Hello,

I want to analyze simulated data of different sizes in both R and SAS. 
I have simulated all the samples in R and where I've done all my analysis, now I want to analyze 
all of those samples in SAS. All samples are in a the data frame.
I want to do logistic regression and exact logistic regression, 
and I'm interested in the estimated coefficients. (university edition)

1. How do I transfer all samples to SAS smoothly? (So that point 2 gets easy)

2. How do I make a loop so that I can analyze all the data directly? 
Note that the sample size goes from 5-1500 with an increment of 5 and for now I 
only have one explanatory variable.

Plz help :)

Re: Transfer data and loops

user24feb — Thu, 13 Apr 2017 11:30:20 GMT

1. One easy way would be a csv-file (write.csv, .. in R & proc import in SAS). (And you could simulate your data in SAS as well (?))

2. Depending on your models and data there are different ways too. Check out the "BY" Statement of proc logistic.

Re: Transfer data and loops

RW9 — Thu, 13 Apr 2017 11:48:12 GMT

Hi,

There are R packages to create datasets directly for example:

https://cran.r-project.org/web/packages/sas7bdat/sas7bdat.pdf

Then you simply copy that file to your working area and write code based on that dataset.

AS for your stats question, I don't know the code offhand, but "looping" is done using by group processing.