Hi: You CANNOT use a Windows drive path with SAS University Edition in a Virtual Machine. SAS in a Virtual Machine is delivered as a Unix install. The ONLY location that SAS University Edition can write to is your shared folder location. You set up this shared folder location as the last step of installing SAS University Edition and importing it into the Virtual Machine hosting software. You can tell you are using SAS University Edition because the top folder is called "My Folders".. however, the full path to this "My Folders" location is /folders/myfolders -- assuming you set up your shared folders correctly. So, if you have made a folder called all_output under this "My Folders" location then the path to all_output is NOT a Windows path, but would be /folders/myfolders/all_output. Hope this explains why the E: drive reference will NEVER work with SAS University Edition. Cynthia ... View more

Hi:   Here's an example using SASHELP.CLASS. Suppose you want to put the students into 2 categories -- Yes or No -- are they eligible for Driver's Ed based on their age. You can do that with a user defined format:   Now the user-defined format is just the beginning. It only defines how the ages get broken up into categories. Now the format needs to be used. This is the output I want to create: Notice that I have a sub-category of M and F for the male and female students and I'm getting a count of each gender within each age category. I've also added subtotals of count and a grand total for all students at the bottom of the report.     Here's the PROC REPORT code that does everything in one step. Since age is a numeric variable, I wanted to make a helper column to hold the category value and the longer text on the break lines. That was all accomplished in the COMPUTE block for AGECAT, my helper variable: Hope this helps point you toward one possible solution with PROC REPORT. Cynthia ... View more

 My typo - code for &ID with more than one varaible should be:       if varname not in ("&IDS") then output; As you defined only one variable variable: subid the code need be  changed into:      if varname not = "&IDS"  then output;   ... View more

When the data step compiler compiles the code, it sets variable attributes from the first encounter of a variable where the attribute can be deduced. In your case this is the statement where the 6-character string "luxury" is assigned; subsequent changes in the length are ignored. Make it a habit to put attribute-setting statements (ATTRIB, LENGTH, FORMAT, but also SET, MERGE, UPDATE) into the top of your data step code. ... View more

@Kurt_Bremser Nice one. I "felt" already while writing the code that there must be a simpler approach but didn't have a better idea at the time. ... View more

Replace the sql step with: proc sql noprint; create table temp as select a.*, b.* from words as a, texts as b where index(lowcase(row),strip(substr(lowcase(word),1,3))); run; ... View more

OK, then you would do like @Patrick indicated.   data results.nomatch09; set results.nomatch08; drop ex: ; run; /* or */ data results.nomatch09; set results.nomatch08 (drop=ex: ); run; ... View more