Architecting, installing and maintaining your SAS environment

Copying SPSS Logic to SAS

Reply
New Contributor
Posts: 3

Copying SPSS Logic to SAS

There is a series of data transformations and process steps in SPSS that I would like to copy and migrate to SAS.  --- I'm not concerned with moving data from SPSS to SAS, but instead I would like to copy the underlying logic to SAS.  Does SAS provide a means to do that, or are there an external tools that would take care of this?

Thank you for your help!

Super User
Posts: 19,869

Re: Copying SPSS Logic to SAS

I don't think there are tools that can do this reliably (as far as I know). There are probably consultants or some manual work Smiley Sad

Super User
Posts: 11,343

Re: Copying SPSS Logic to SAS

I used to spend a certain amount of time going the other way SAS program => SPSS. What I learned is you want to understand the whole process and use the different tools appropriate to each piece. Most numeric transformations will be pretty routine but look very closely at anything involving text. As I recall I was always cursing at SPSS for the weak choice of text manipulation tools and some pretty stupid defaults such as Length returning the declared length of the variable not the actual length of value as SAS does.

Super User
Posts: 3,260

Re: Copying SPSS Logic to SAS

The best advice I can give when migrating logic from one language to another is to ensure you understand the processes involved as ballardw has said.

I've been involved in such projects and found that you often encounter errors in the source systems, that if you just blindly copy you will repeat the same mistakes.

Also test the output in both systems to ensure that it is identical, or if it is not identical to be able to explain the differences, for example when correcting errors.

Ask a Question
Discussion stats
  • 3 replies
  • 522 views
  • 0 likes
  • 4 in conversation