DATA Step, Macro, Functions and more

create fake/test data with certain attributes of original data

Reply
N/A
Posts: 1

create fake/test data with certain attributes of original data

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

Super User
Posts: 11,343

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

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.

Super User
Super User
Posts: 7,942

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

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

Ask a Question
Discussion stats
  • 2 replies
  • 392 views
  • 0 likes
  • 3 in conversation