Hi,   So when i was in 9.2, i had set up my settings so that everytime i opened a table it would default to the names of the columns, not the labels.   Now that we've upgraded to 9.4, i read that that process is different in 9.4.  Supposedly, if you just change it once (view --> column names), then that setting should stay for everything after that.   Mine isn't doing that.  Sometimes it does, sometimes it doesn't, sometimes within the same session some tables open with names, some open with labels, some sessions open tables with names every time.  I can go 3 days and have everything open with names and then, boom, labels.  And i don't know how to make this consistent!!!   I want to default my 9.4 settings to ALWAYS open with column names, never column labels.   Thanks Megan ... View more

Hi,   I'm trying to run a macro in the middle of a proc sql step, and this works just fine: proc sql; blah blah blah %macro c; %do i=4 %to 22;      a._c&i._ as c&i._prev,      b._c&i._ as c&i._curr,      ((b._c&i._-a._c&i._)/a._c&i._)*100 as c&i._percdiff format 5.2,      case when calculated c&year._percdiff ne .                 and (calculated c&year._percdiff  < -2                 or 2 < calculated c&year._percdiff) then 1 else 0 end as flag_c&i., %end; %mend; %c rest of proc sql; quit;   But i want to add a second variable without adding a second do loop.  I don't want it to cycle twice, just the once.  But when i do this, it skips the macro altogether.   %macro c; %do i=4 %to 22 year=1996 %to 2014;      a._c&i._ as c&year._prev,      b._c&i._ as c&year._curr,      ((b._c&i._-a._c&i._)/a._c&i._)*100 as c&year._percdiff format 5.2,      case when calculated c&year._percdiff ne .                 and (calculated c&year._percdiff  < -2                 or 2 < calculated c&year._percdiff) then 1 else 0 end as flag_c&year., %end; %mend; %c   And i can't seem to find the right search words for a google search on this.  I don't want a nested do loop. I only want the one.  I just want TWO variables in it.   Thanks Megan         ... View more

Hi,   I couldnt' even find the right words to google this, so i'm here.  I have a character field that has " (double quote) mixed in it and i need to make them a ' (single quote) instead, while keeping everything else the same.   For example: Have: Today is "awesome". Want: Today is 'awesome'.   And of course, they're all in different places, and some obs don't even have them, only some of them do.   Is there a function for this?   Thanks Megan ... View more

Hi,   I'd like to covert this to a proc freq for efficiency, but i can't seem to find code to be able to create a variable at the same time.  For all i know it's not allowed.  But i thought i'd ask.  I can rename stuff, keep stuff, use a where statement.  But i can't seem to find code to create a variable.   Convert...         proc sql;             create table junk.qc_hcfasaf_&year. as             select &year. as year,                 hcfasaf,                 count(hcfasaf) as count             from clms.allclaims_&year.             group by hcfasaf;         quit;           to.... proc freq data=clms.allclaims_&year.;    tables hcfasaf / out=junk.qc_hcfasaf_&year.; run;   But i don't know if i can create a variable during the step.   Anyone?   Thanks Megan ... View more