topic create fake/test data with certain attributes of original data in SAS Programming

create fake/test data with certain attributes of original data

danmet — Sun, 22 Jun 2014 19:52:08 GMT

Hej everybody.

I have a quick question on how to efficiently create a test data set.

I am working remotely with confidential data and I would like to create a fake data set with the same data structure so that I can do some programming on my local computer. As potentially many tables are affected, I would like to automatize this procedure as far as possible. Basically, I would like to do the following:

1. generate some code that creates a data set with the same variables/data types (a simple proc sql- describe table may do?)

2. save mean, std, and correlations (of number variables) and detect string data types of other variables.

3. create random data with the same of the statistical attributes of the original data.

4. the code should be flexible so that I can adjust it easily for different tables.

Any help is highly appreciated!!

Thanks

Daniel

Re: create fake/test data with certain attributes of original data

ballardw — Mon, 23 Jun 2014 14:54:01 GMT

The first part is easy:

Data want;

set have (obs=0);

run;

Creating fake data with mean and std is quite possible. Correlation I'm not so sure of, especially if you want to mantain correlation from variable x to y1, y2, y3, etc. As when you create the dummy X you have a lot of constraints on the other variables that will be an interesting challenge.

Re: create fake/test data with certain attributes of original data

RW9 — Mon, 23 Jun 2014 15:00:18 GMT

Could you not just annonymize the data you have, so anything identifiable would be replaced with some code + random number?