topic filter variable from SPSS file in SAS Programming

filter variable from SPSS file

emaneman — Tue, 15 Dec 2020 12:04:23 GMT

Dear all,

I imported an SPSS file using PROC IMPORT. The import ran smoothly.

One of the variables in the dataset was a filter variable in SPSS, and SAS kept its name: FILTER_$.

This variables has values Selected or Non Selected, and SAS tells me its TYPE is numeric (which is strange) and that its FORMAT is FILTER_A.

See attached PDF with two pages that contain snapshots of the SAS file and the variable info.

SAS does not recognize the variable name FORMAT_$ when i try to use it, and if I try to RENAME it, I get the error message detailed in page 3 of the attached PDF file.

Any idea of why it doest not recognize the variable name? My guess is that it has to do with the fact that it is considered a filter variable by SAS (hence the format that it gives it), but when I do a PROC FREQ without specifying any variable, it gives me a table for that variable, too! I simply cannot use its name - it's like Voldemort!

Any suggestion?

Eman

Re: filter variable from SPSS file

s_lassen — Tue, 15 Dec 2020 13:01:14 GMT

If the variable name contains "illegal" characters, or begins with a number, you can refer to it in programs like this:

'FILTER_$'n

- just put the name in quotes and put an "n" afterwards.

I am not familiar with SPSS output and filter variables, but it looks like it is a logical value, which is 1 or 0 in SAS. So my guess is that the format shows "Selected" when the value is 1, and "Not selected" when it is 0.

You can see the numeric values by using another format in e.g. PROC PRINT:

proc print data=<SPSS_Import>(obs=20);
  format 'FILTER_$'n best32.;
run;

Re: filter variable from SPSS file

Kurt_Bremser — Tue, 15 Dec 2020 13:03:11 GMT

To use such variable names in SAS, you need to have

options validvarname=any;

set and use a "name literal":

'FILTER_$'n

Your variable is most probably a boolean type in SPSS, with a proper format attached to translate the two possible numeric values (1 or 0) to the strings you see. AFAIK, the SPSS import should create that format, but you may have to set the FMTSEARCH option.

Re: filter variable from SPSS file

emaneman — Tue, 15 Dec 2020 13:09:07 GMT

Thank you.

I renamed the variable by adding:

rename 'FILTER_$'n=filter;

and now the new variable called simply filter, which can be then used.

'FILTER_$'n