var1 = substr(str, 1,1); var2 = substr(str, 2,1); var3 = substr(str, 3,2); ... View more

SUBSTR(string, position<,length>) ... View more

Yes, there is. ... View more

You are missing the BY ACCOUNT MONTH; statement after the SET statement. ... View more

I get the feeling we are being used as tutors in a basic SAS class. ... View more

Read your log. You can't have a space in the middle of a dataset name. ... View more

Compare today() to input(put(yourdtvar, 8.), anydtdte8.) That should put both in SAS date form. ... View more

Proc append simply does what it says, adds one dataset to the end of the other. The FORCE option will make it append with differing variables, but your data has none in common. My guess is that you want to merge the datasets not append. so sort both then do. data new; merge period2A period 2B; by TransactionID; RUN; ... View more

You need to output the sorted data to the permanent lib. proc sort data = period1 out = sc.period1; By DateofSale; RUN; ... View more

You create sc.period2A but I do not see where you create period2A. So it does not exist. Do you have a library sc defined, it is not in this code. Also put in some run; statements and you will have better luck reading your log. ... View more

It is impossible to answer your question without seeing the data that is causing the problem. Since your formats representvalues up to 100 I find it hard to believe that a sum of these would be less than 12. I would assume that 267 would be more reasonable. Or were you expecting the sum of numerics to somehow represent the sum of the formated values. The correct way to handle this would be more like: var1=input(put(WebRank,FmtWbRnk.), best.); var2=input(put(PressRank,FmtPrRnk.), best.); var3=input(put(TVRank,FmtTVRnk.), best.); ... View more

The "widespread notion" is a fact. Perhaps your origional values could not be automatically converted to numerics, but the formatted ones could. ... View more

If you are talking about EG then use Tools/Schedule Project ... View more

I don't know where the informat of the output data would do anything in EG, but if you open that file in the VIEWTABLE window in SAS that is the informat that is recognized when entering new values. ... View more

www.cdisc.org ... View more