skallamp wrote: javascript:void(0); I do not want to add the result at the bottom. What I want is, how do we derive the table 1 detailed information from table 2 summary? I am OK if we do not get the negative values. Possible only if "total_qty" is constant for all obs in one group and no negative values are present. With a least one negative total_qty/rx_count the number of "restored" observations won't match the number of obs in the original dataset. data work.faked_original;        set work.QUERY_FOR_TESTTEST;               length rx_count total_qty i 8;        drop sum_of_: i;        do i = 1 to sum_of_rx_count;               rx_count = 1;               total_qty = sum_of_total_qty / sum_of_rx_count;               output;        end; run; ... View more

Writing to the work-library of another sas session is not possible - unless the server configuration lacks a proper configuration of write-access to the location in which then directories for the work-libraries are created. ... View more

An interesting mixture of macro and datastep code. You should spend some time reading the SAS 9.2 Macro Language: Reference (http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/viewer.htm#titlepage.htm), especially the section "Understanding and Using the Macro Facility". An untested idea: data _null_; /* you don't need a dataset */   if "&SysJobId" = "AC11895K" then call symputx("sub1"; "PROD");   else call symputx("sub1", "TEST"); run FILENAME OUTBOX EMAIL                         TO= ("XXXXXXXXXX")     SUBJECT="&sub1." ; ... View more

Untested and not efficient: %macro readin; %do i=1 %to &max; PROC IMPORT DATAFILE="&&read&i" OUT=data.&&dset&iv DBMS=DLM REPLACE; GETNAMES=YES; DELIMITER=","; GUESSINGROWS=10000; RUN; /* new code: */ data data.&&dset&iv;      length MemberKey $ 12; /* insert maximum length */      set data.&&dset&iv(rename=(memberkey = MemberKeyNum));      MemberKey = put(MemberKeyNum, z12.); /* fix format length */      drop MemberKeyNum; run; %end; %mend readin; %readin; I recommend moving the import proc to the data step. ... View more

"Add" to what? Do you need a new variable? Please post the dataset you want to create. ... View more

In the fifth step of the wizard you should be asked whether the results should be stored in an dataset or not. ... View more

Unable to reproduce the error using SAS 9.2. Code: data work.WithoutName;        set sashelp.class(drop=Name); run; data work.test;        set work.WithoutName sashelp.class; run; proc print data=sashelp.vcolumn(where= (memname = 'TEST' and upcase(name) = 'NAME')) noobs;        var libname memname memtype name type; run; Proc print shows: libname memname memtype name type WORK TEST DATA Name char ... View more

Afaik you will have to replace style/template, so have a look at http://www2.sas.com/proceedings/sugi30/132-30.pdf. ... View more

Can be done in one data step. Still ignoring public holidays? data work.have;     length CustomerName $ 10 TechVisitDay 8;     format TechVisitDay ddmmyyp10.;     informat TechVisitDay date.;     input CustomerName TechVisitDay;     datalines; John 02JAN2012 John 03JAN2012 John 05JAN2012 John 06JAN2012 John 09JAN2012 Mary 02JAN2012 Mary 03JAN2012 Sam 03JAN2012 Sam 04JAN2012 ; run; data work.want;     set work.have;     by CustomerName;     length         lastVisit saved day missingStart missingEnd 8         Flag $ 20;     retain lastVisit;     if first.CustomerName then do;          /* get first monday */         missingStart = nwkdom(1, 2, month(TechVisitDay), year(TechVisitDay));     end;     else do;         missingStart = intnx('DAY', lastVisit, 1);            end;     missingEnd = intnx('DAY', TechVisitDay, -1);     saved = TechVisitDay;     do day = missingStart to missingEnd;       /* 1 = Sunday, 7 = Saturday */         if 1 < weekday(day) < 7 then do;             TechVisitDay = day;             Flag = 'No Visit';             output;         end;     end;     Flag = ' ';     TechVisitDay = saved;     output;     lastVisit = TechVisitDay;     keep CustomerName TechVisitDay Flag; run; ... View more

sassharp wrote: I checked the table is there.  I queried the table also Hima. And you have the required permissions to perform a truncate on the table? ... View more

You can use the anyalpha-function: ... if anyalpha(variable) then output alphas; else output numerics; ... ... View more

Can you post the dataset you want to create? If i understood your request, you need something like this: LotId DuploWaferId Operation P110123 D02 1000-OxideDepostion!1!0 Maybe something like this: data _null_;     Ctx = &g_Ctx;     call execute('data work.Bill;');     do i = 1 to (countc(Ctx, ';') + 1) by +2;         Left = strip(scan(Ctx, i, ';'));         Right = strip(scan(Ctx, i+1, ';'));         call execute(trim(Left) !! ' = "' !! trim(Right) !! '";');     end;     call execute('run;'); run; In this example this are always pairs And what should happen, if this condition is not fulfilled. ... View more

The error message means that no data source named "rfdev" exists. Cherry wrote: What does it mean? can you please explain ? ... View more