Hello EG Users, I need advice trying to figure out if it is possible to layout this kind of format using tools available in SAS EG. Attached is snapshot of what I intend to build. It is void data. But what I would like to stress is the way certain rows are bold and the secondary description (Total FTE, Traditional CLasses FTE, etc). Also way to add the line between each section. I have been playing around with Summary Tables Wizard and List Data under Tasks but to no avail. Is this kind of reporting possible in Web Report Studio? Btw, this has been generated in Microsoft Excel Thanks, Dhanashree ... View more

Hello EG USers, Is it possible to embed small logo / .jpg file inside of SAS Report. Currently, I am using Electronics style. Thanks! Dhanashree ... View more

Hello EG Users, How can one store value that represents distinct rows of a variable in dataset into macro? Data have; Week   Activity 5          Pingpong 10          Badminton 15          Chess I would like to count distinct values for Week, which is 3 in this case and store it in macro Week_Distinct. I would appreciate your instructions on how to achieve that? Regards, Dhanashree ... View more

HEllo EG Users, I am looking for ways to check for non-existing columns in my intermediate datasets. For example, I calculate sum of two columns A and B as Total sum(t1.A, t1.B) is computed column Total. However in some scenarios, A might not just exist, and it by that I don't mean that the data is missing and saved as . for column titled A. Are there relevant IF statements in conditional category that can be used to these kind of checks? In theory, following code would have worked if I had both columns A and B and the data was missing (.) case when t1.A = '.' then sum(t1.B) when t1.B = '.' then sum(t1.A) else sum(t1.A, t1.B) end However how I do I go about checking for non-existing columns. Thanks, Dhanashree ... View more

HEllo SAS EG users, I intend to use program to delete permanent dataset once I read it into WORK library so that I can process new data and save it as the same permanent dataset at end of the session. What is the best way to: a) Replace existing permanent dataset using datastep? OR b) Delete existing permanent dataset using datastep? Thanks, Dhanashree ... View more

Hello EG Users, I am writing simple computed columns in SAS EG that calculate Total = sum(t1.var1,t1.var2) However, sometimes the dataset may end up not having var1 at all since this dataset is being put together after multiple filters, transpose and merges. So is there a way to determine if the column being used in the calculation exists before it is used in the equation? EXIST function is useful to verify if dataset exists, and not quite helpful in this scenrio. Any reference to var1 will give me error that says ERROR: Column var1 could not be found in the table/view identified with the correlation name T1 So does SAS Eg provide a way to check if column exists? Thanks, Dhanashree ... View more

Hello EG Users, I have following had-coded %Let statement: %LET birthdate = '01JAN2014'd; I would like to change it to be flexible and equal to another variable from dataset %LET birthdate = bdate; Now bdate is of format mmddyy8. How do I make sure that macro variable birthdate gets assigned value of variable bdate however is similar to '01JAN2014'd? In summary, I am trying to understand what that 'd does to value inside text? I tried using format birthdate mmddyy8.; as well as format birthdate DATE9.; but it did not work!? Thanks, Dhanashree ... View more