BookmarkSubscribeRSS Feed
RichardL
Calcite | Level 5

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!

3 REPLIES 3
Reeza
Super User

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

ballardw
Super User

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.

SASKiwi
PROC Star

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.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1129 views
  • 0 likes
  • 4 in conversation