For each obs, I have 5 variables related to race (raceA, raceB, raceP, raceI and raceW).  If 4 of the variables = 'N' and one of them = 'Y' then coding the race is easy.  subgrp_race will be defined by the field that has the 'Y.'  However, if two or more fields = 'Y' then I will define a new variable (RaceO) to denote that two or more races were chosen by the student. Here's a proc freq below that shows the table raceA*raceB*raceP*raceI*raceW/ list; I know I can write a buttload of if then statements but there has to be something more elegant. raceA raceB raceP raceI raceW N N N N Y 3992 86.31 3992 86.31 N N N Y N 4 0.09 3996 86.40 N N N Y Y 21 0.45 4017 86.85 N N Y N N 1 0.02 4018 86.88 N N Y N Y 4 0.09 4022 86.96 N Y N N N 385 8.32 4407 95.29 N Y N N Y 157 3.39 4564 98.68 N Y N Y Y 3 0.06 4567 98.75 Y N N N N 36 0.78 4603 99.52 Y N N N Y 16 0.35 4619 99.87 Y N Y N N 3 0.06 4622 99.94 Y Y N N N 1 0.02 4623 99.96 Y Y N N Y 2 0.04 4625 100.00 ... View more

I used the code below to read an external Excel file and just noticed it only read the first 255 columns.  When I used PROC IMPORT, all 266 columns were read in.  Some of the column names are longer than 32 characters, so PROC IMPORT gave some variable names as VAR15, etc.  When I used the code below, it did not assign names such as this but instead, it would read the first 32 characters and truncate the rest, which makes renaming a bit easier. Is this expected?  I'm running SAS 9.4 on a PC. libname datain  'G:\Departments\Research\test scores\Aspire\2015\1936-3701-SPF-v1.xlsx'; data data1; set datain.'1936-3701-SPF-v1$'n; run; ... View more

The data I have (in one field): Name  Doe,  John  M.  The data I want (in 3 fields): Last     First     Mi Doe     John     M ... View more

I want to change the left and right margins in the pdf files I am outputting.  Actually, the real problem is that each obs requires more than one line, so I thought I would start with the orientation and margin width.  I would welcome suggestions for any other options that would allow me to output one record per line. partial code: %macro elemREP (num=); ods pdf body="G:\Departments\Research\Misc\EVAAS\1415\School Rosters\&num._Verify_Roster_EVAAS.pdf"; options orientation=landscape nodate pageno=1 leftmargin=.1 rightmargin=.1; proc print data=joinelem4 noobs ... View more