Dear all, I apologize for asking a similar question to one I asked sometime ago, but it does not work with string variables and that is what i need now.   I have a variable VAR which includes a series of words. I need to create a new variable multiple new variables which correspond to the frequencies of certain words in VAR.   In the example below, starting out with VAR, I need to create NEWRED, NEWBLUE and NEWYELLOW, which would have the values as indicated.   Example: OBS VAR NEWRED NEWBLUE NEWYELLOW 1 red blue red red blue yellow 3 2 1 2 red 1 0 0 3 blue yellow 0 1 1   Thanks in advance for your attention.   E ... View more

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 ... View more