Hi:   I still think you should work with Tech Support. I think it might be possible to do some of what you want with a style template change, however, you might also need to update your version of TAGSETS.EXCELXP, first. http://support.sas.com/kb/38/282.html (talks about grid lines) However, I did NOT have to use a custom style template to get gridlines when I used EXCELXP. So I really think that Tech Support is your best bet for additional help.   I do remember that in the early days of TAGSETS.EXCELXP, it was possible to get a gray background to the sheet and no interior table lines, but as you see in my screenshot, when I use version  v1.122 of the EXCELXP tagset and SAS 9.3 and Excel 2010, I don't have a gray background and I do have interior lines.   Tech Support can work with you to figure out the solution. cynthia ... View more

Another option is to create an informat which is then used to convert the data.  The following code creates informats for all months from Jan 2000 - Dec 2012, obviously you can easily increase this range in the loop. proc format; picture dt_pic low-high='%B %Y' (datatype=date); run; data dt_infmt; retain fmtname 'dt_in' type 'J'; do i=0 to 155;   label=intnx('month','01jan2000'd,i);   start=strip(put(label,dt_pic15.));   output; end; run; proc format cntlin=dt_infmt; run; data want; set have; new_date=input(date,dt_in.); format new_date date9.; run; ... View more

hi ... data have; value='xxasdxfg';output; value='xxxxqwerxxt';output; run; data want; set have; new = substr(value,verify(value,'x')); run; data have; x = '123456789'; run; data want; set have; x2 = substr(x,length(x)-3); run; ... View more

If you really have numbers then you can use SAS formats. data two ;   set one;   x=put(input(x,7.),z7.);   y=put(input(y,7.),z7.); run; If you want to change the spaces to zeros and the values aren't really numbers then you might use translate function. data two ;    length x y $7.;   set one;   x=translate(right(x),'0',' ');   y=translate(right(y),'0',' '); run; ... View more

or it should be: b = put(catt(substr('xxxxxxxxxx',1,10-length(a)),a),$10.); ... View more

How about: data need ; set sashelp.class; where name contains 'Jo' or name contains 'Ro'; run; Ksharp ... View more

I don't think the WINDOW command has that much power.  It should be the top window for the current SAS session, but if you are running multiple other programs on your computer then they could cover your SAS windows. What are you trying to do?  You might get the control you want using SAS/AF programming or even more using newer web based SAS solutions. ... View more

The base code was stolen from Astounding: using Macro to generalize your task: %macro cpy (dname=,var=,i=); data want;    set &dname;    output;    if age=&var then       do _n_=1 by 1 to &i;       output;       end; run; %mend; %cpy (dname=sashelp.class,var=15,i=2) Haikuo ... View more

That is fantastic! Thanks! Mike ... View more

Try using Range option in Proc Import. Something like this: proc import file='c:\temp\op.xls' out=op dbms=xls replace; Range = "E10:K20"; getnames=yes; run; ... View more

hi ... that's not a valid URL on the SAS web site if you try that URL in a browser you get the attached error valid URLs work, for example ... filename foo url 'http://support.sas.com/techsup/support.html'  ;      data _null_; infile foo; input; put _infile_; if _n_ eq 15 then stop; run; ... View more

I have found a post at this link that helped me to solve the problem. It is not elegant, but it works. https://communities.sas.com/thread/33890?start=0&tstart=0 SAS should provide an option for the user to control how many rows to scan instead of relying on the windows registry. Good luck. ... View more

Quentin has provided the answer.  Your first method does not create a valid character expression, so it fails.  The being said, when calling macro statements in a data step with call execute I prefer to wrap them with %nrstr so that they will run sequentially after the datastep completes instead of in place.  This is not always important but I find it to be a good practice to follow: data _null_; set sashelp.class; call execute('%nrstr(%global zzz' || name || ';)'); run; Another way to do this would be using call symputx: data _null_; set sashelp.class; call symputx('zzz'||name,'','g'); run; ... View more

Thanks, and type the digit on number pad ... View more

That's the behaviour I would expect. ... View more