That sql is run on the data BEFORE the transpose. So there has to be a days_away since it is what you are transposing. Also you do not need the loop at all since you are just suming. SUM will sum up the values without worry about missings. Just use DAYS_AWAY_SUM = sum( of DAYS_WAY1 - DAYS_AWAY&lim); ... View more

Try this proc sql; select max(a.cnt) into :lim from (select count(days_away) as cnt, name from temp group by name) a ; quit; %let lim = &lim; data eight; set six; total = sum(of days_away1 - days_away&lim); run; ... View more

I can tell you half a dozen ways to do this, but don't know a macro function to just give you what you want. The simplest one I know of would be: data temp; input name $ days_away; cards; fred 12 fred 15 fred 17 fred 23 joe 5 joe 7 joe 12 run; proc sql; create table seven as select name, sum(days_away) as sumday from temp group by name; quit; PROC TRANSPOSE DATA=TEMP OUT=SIX (DROP=_NAME_) PREFIX=DAYS_AWAY; BY NAME; VAR DAYS_AWAY; RUN; data six; merge six seven; by name; run; Otherwise you are going to have to run a datastep or sql to find the maximum number of values by name or find the maximum suffix for the variable name from the sashelp views or dictionary tables. You can parse the variable name from them to get that value. ... View more

In your transpose you have a PREFIX= NR_DAYS option. You should also have an ID statement. Use that ID variable in the SQL I gave you then it should work. &lim is then the maximum value. If all you want is the sum, no looping is required. Show me your transpose code and I will have a better idea what you are doing. Message was edited by: Flip ... View more

If I am reading you right you have a variable that is being added to your prefix of NR_DAYS to form your new variable name. proc sql; select max(varname) into :lim from xxx; * your source data; quit; in your data step use x=sum(of nr_days1 - nr_days&lim ); I left out the OF Message was edited by: Flip ... View more

That depends on the data source, platform, is SHARE running and many other factors. ... View more

When an error causes OBS to be set to zero, it ia simply a way for SAS to continue checking syntax after stopping processing. OBS=0 is not a symptom of the error, simply a tool to help you debug. ... View more

Have you contacted Ommicomm to find out why their software is generating invalid files? ... View more

check this out http://support.sas.com/kb/11/728.html ... View more

%macro chkrun( var); %if &var = 1 %then %do; PROC SQL; SELECT * FROM TABLE; QUIT; %end; %mend; %chkrun( 1 ); ... View more

Try doing your join on something like where a.var1 = put(b.var1, best.) Um, well yea, what Daniel said. Message was edited by: Flip ... View more

We need a list of FPQ Frequently posted questions. ... View more

Check to make sure &row1 is global. It looks like a local variable to you macro. You would need to have %global row&i ; in your macro. ... View more

Cat will take numerics so use: if compress(cat(of _all_, ". ")) = '' then delete; ... View more

It can be done in one step. proc sql; create table new as select * from old o where not exists( select * from mark m where m.var1 = o.var1 and m.var2 = o.var2); quit; or in place as proc sql; delete from old o where exists( select * from mark m where m.var1 = o.var1 and m.var2 = o.var2); quit; ... View more