Well, that's a lot of separate questions there: 1) its prompting to save file. This is likely due to the ods outputting results.  Turn this off by adding the statement before your tagset one: ods noresults; 2) its not giving desired output file. Sorry, you will have to clarify here.  The purpose of tagsets are to create markedup output, the Excel one uses XML which is a flat text file which Excel can parse and display.  This is similar to the latest versions of Office which use compressed folders with XML files within. 3) it not proving suporting version of excel file What version of Excel are we talking about?  Most versions should be able to to parse XML. 4) and main issue is , its doing strange behaviour. providing missing missing value of computed variable for particular record for date 01jan2014. Please provide specific test data/example output of what is happening.  Excel does a great job of hiding most things behind the scenes, so it could be A) you options missing is setup wrong, B) Excel reads a value it doesn't like and changes it, C) the displayed data doesn't fit with general format hence its hidden etc. It may be as simple as setting the style to set the excel format for that cell. ... View more

Hi, Not sure what your structure is there, what do the /// reference?  What are the variables? At a guess: data want;      attrib id format=best. age format=$20. otherbit format=$20.;      infile "...\your_file_here.txt" dlm=" " dsd missover;      input id age $ otherbit $; run; ... View more

Yes, you can do a macro, however you can't use lag like that as that's a datastep function so; data kommune_s;   attrib id kom1995 kom1996 kom1997 format=best. ;   id=1; kom1995=6; kom1996=4; kom1997=3; output; run; %macro year;      %do year=1996 %to 1997;             data s%trim(&year.);   /* I would include trim as otherwise you will get spaces preceding */                set kommune_s;                keep id kom%eval(&year.-1) kom%trim(&year.);           run;       %end; %mend; %year; ... View more

Sorry, why is ods tagsets.excelxp not working?  I would personally strongly recommend that over the html as you have far more control over Excel options.  Also, html doesn't have the concept of sheets as Excel does, so you will struggle to get that to work. ... View more

Well you can have: data _null_;      do I=1995 to 2006;           call execute('data KOM'||strip(put(I,best.))||'_'||strip(put(I+1,best.))||';                                    set commune_s;                                    where '||strip(put(I,best.))||' <= year <= '||strip(put(I,best.))||';                               run;');      end; run; However I would suggest that you should remap your original dataset to a normalized table rather than transposed: ID          YEAR          RESULT 1            1996            47 1            1997             56 1            1998               34 ... The above will be a lot easier to work with than a large dataset with many variables, or lots of smaller datasets with partial info in them. ... View more

Yes, my partner had this.  you need to re-start your machine and go into the bios.  If you need help on that check your computer's help pages as the keys differ, on the on I mentioned it had a special key to hold during startup.  The bios is the thing that tells the OS what bits are in your machine.  One of the options in the Bios is to enable virtualization - you may have to look around a bit for it, maybe under a virtualization tab.  Set this to enabled then it should run.  Ensure you don't change anything else in bios unless you know what your doing though. Also a Google on "VT-x is disabled in the BIOS" may help. ... View more

Yep, sorry, typo there: %macro fetch (area=);      data some_new_dataset_&area.;           set sashelp.cars;      run; %mend fetch; data _null_;      area="AJ";      call execute(%nrstr('%fetch(area='||strip(area)||');')); run; ... View more

Its just a matter of slightly altering your original code: %macro fetch (area=);      data some_new_dataset_&area.;           set xyz;      run; %mend fetch; data _null_;      set aj.testcheck;      call execute(%nstr('%fetch(area=('||strip(area)||');'); run; For the way you were doing it your going to run in to various problems as your data has commas and quotes in and hence you are trying to force it by quoting/unquoting. ... View more

Hi, What's your intended use?  Personally I tend to avoid long macro variables in favour of storing in datasets.  So say for instance I want to produce a print separately for each of those areas I could do: data _null_;      set testcheck;      call execute('proc print data=some_data (where=(area="'||strip(area)||'")); run;'); run; This would generate a proc print for each observation in testcheck with the restriction. You could also do your macro call with the area: %macro your_macro (a=);      ... do something; %mend your_macro; data _null_;      set testcheck;      call execute(%nstr('%your_macro(a='||strip(area)||');'); run; ... View more