Since it's monthly rate for each year from 2017-2021. Numerator would be number of visits per month while denominator should be 12 for each year seperately. ... View more

To schedule EG projects in SMC you first need to export your projects to SAS programs. These can then be scheduled in SMC via Schedule Manager. I suggest you reach out to your SAS administrator regarding the scheduling setup for your SAS installation.  ... View more

I've used ddmmmyyyy for a number of years, so today would be 01Dec2022. I've never had a problem with it, but I haven't tested it exhaustively either. ... View more

Hi!  First of all:  I use SAS Studio - which is in Linux. (NOT CAS - I was quite wrong). My falut!  Mea culpa!   Your comment is QUITE good! I will look into that! Many thanks   Anders   ... View more

Tom, thank you for your very clear help with the code for this question. With a few adjustments, I think I will be able to capture what I need and pass it to name my exported files, even when my query does not turn up any rows. Rita, thank you for raising this topic. I've been looking for a solution like this for passing the user entry so that I can reference it during the export. ... View more

Your LIBREF must be no more than 8 characters - sqldatabase. Shorten it to just SQLDATA and see how you get on. ... View more

@DanielaNRW wrote: When you open datasets you cannot change values or the data type because of read access. If you try to change a value a popup window opens and asks if you want to switch to update mode. Now you can change the properties of the column and the drop down menu for Type is not greyed out any more. This does not make much sense.  The only reason to "open" a dataset would be to check the values so you can plan how you want to analyze it.  Do you mean you are trying to treat your data as if it was in an insecure environment like an Excel Spreadsheet?      To work with your data and derive new information to use in your analysis write a program.  Now you know exactly what you did and can recreate it or explain it to others.   To your original issue, if you are reading data from a text file then skip the guessing process and just write your own data step to read the file. Then you have full control over how the variables are defined and how to text into the file is converted into variable in a dataset. ... View more

You can suppress the output data. Go to Tools:Options:Results:Results General. In box "Maximum number of output data set to add to the project" set 0.    https://blogs.sas.com/content/sastraining/2015/06/17/sas-enterprise-guide-suppress-output-data-tab-when-programming/     ... View more

GDI+ are your graphics drivers. I would make sure your graphics/printer/pdf drivers are up-to-date. Run Windows Update as well.   Start there then call tech support. ... View more

How are you 600 variables to be used? Like Id and Class as grouping variables, or summed (apparently) like Value within the groups?   The question of do you want a report, people read these, or a data set , used for input to analysis or other processing is very critical. One reason is that sort of report is relatively easy, depending on how your 600 variables are to be used, and structures of data sets for further analysis depend on the type of analysis planned. That example output is generally a poor structure for many forms of analysis. ... View more

@SASKiwi I was going back on my emails and they did requested those logs, I sent it to them but hasnt gotten any positive outcome.  This was about a month ago, hence the reason I didn't remember.   ... View more

In my opinion, SPDS should be used in situations where you're finding it too slow to access your data. It's a lot of work to set it up, but once done you should see significantly faster access to your data.   If you're happy with your data access performance right now, stick with SAS datasets. They are much easier to create and manage.   Tom ... View more

@THALLA_REDDY  - The high-level approach would be to convert your first process flow into a SAS program using EG's export to SAS code function. Then replace the first process flow to a single SAS code node that looks something like this: %include '\\MyServerName\MyServerFolder\MySASMacroProgram.sas' Then your MySASMacroProgram.sas file would contain this: options nosource nomprint; %macro MySASMacro; < SAS statements> %mend MySASMacro; %MySASMacro; The good part about using macro is it can reference your EG project's input parameters. ... View more

I thought of some things that could be done to find suspect customers: sudden change in consumption up. Could mean someone tapped into that somebody's line sudden change down. Could mean somebody bridged the meter, or tapped into someone else's line If you have hierarchical data that includes metering on a district level; if the measured consumption is significantly higher than the sum of the individual measurements, someone's cheating. Could also be used to find defects ... View more