topic Re: Translating a code from SPSS to SAS in SAS Programming

Translating a code from SPSS to SAS

Emma_at_SAS — Mon, 12 Jul 2021 16:06:51 GMT

I work with SAS and the other members of my team work with SPSS and I usually need to translate codes between SPSS and SAS. I wonder if someone may help me to translate this. I want to create new_var from var

I appreciate any hint that may help me to translate this. Thanks

STRING new_var (A200).

EXECUTE.

COMPUTE new_var=CHAR.SUBSTR(var,1,CHAR.INDEX(var,"?")-1).

IF NOT(CHAR.INDEX(var,"?")>0) new_var = var.

EXECUTE.

Re: Translating a code from SPSS to SAS

sbxkoenk — Mon, 12 Jul 2021 17:13:27 GMT

Hello Mary,

I think I can guess approximately what this SPSS code does, but it would be better if you can explain it a little bit.

Or specify some relevant examples of "var" and "new_var".

That will make it easier for the majority of us to answer correctly.

Thanks,

Koen

Re: Translating a code from SPSS to SAS

Tom — Mon, 12 Jul 2021 17:14:55 GMT

@Emma_at_SAS wrote:

I work with SAS and the other members of my team work with SPSS and I usually need to translate codes between SPSS and SAS. I wonder if someone may help me to translate this. I want to create new_var from var

I appreciate any hint that may help me to translate this. Thanks

STRING new_var (A200).

EXECUTE.

COMPUTE new_var=CHAR.SUBSTR(var,1,CHAR.INDEX(var,"?")-1).

IF NOT(CHAR.INDEX(var,"?")>0) new_var = var.

EXECUTE.

No one said what the code is supposed to do?

Looks like it is just trimming the data to the the first part before the first question mark. You could try to translate the existing logic into SAS, but why not just use the SCAN() function?

length new_var $200;
new_var=scan(var,1,'?');

Re: Translating a code from SPSS to SAS

ballardw — Mon, 12 Jul 2021 17:16:25 GMT

Literal translation if I remember my SPSS correctly:

length new_var $ 200; 
if index(var,'?')>0 then new_var = substr(var,1,index(var,'?')-1);
else new_var=var;

However if the purpose is to get everything before a single ? in the data

new_var= scan(var,1,'?');

The '?' tells SAS to only consider a question mark as a delimiter between string sections. If one is not found then the entire string is returned. New_var would inherit the length of the VAR variable if that is the first use. If that isn't desired then use a length statement to set an explicit length.

Re: Translating a code from SPSS to SAS

Emma_at_SAS — Tue, 13 Jul 2021 20:22:08 GMT

Thank you @sbxkoenk. Each observation for var is a text and now I know I need to cut the new_var to the portion before the ? mark (only including the text up to the ? mark). Thanks!

Re: Translating a code from SPSS to SAS

sbxkoenk — Tue, 13 Jul 2021 20:27:42 GMT

OK. Fine.

I guess your question was sufficiently answered by @Tom and @ballardw .

If indeed so, you can mark it as 'solved'.

Thanks,

Koen