Am try outed this but it shows as "There are no records in a dataset" also when the data set contain observation ... View more

> Thanks for the reference. I had found that Note > earlier and I concluded it was possible if the > DLM='09'X was specified. Does that only work with > certain operating systems? A secondary issue that MIGHT affect this code is whether your settings in the editor are set to convert tabs to spaces on saving the file. ... View more

Unfortunately, you might have to create the legend by annotation to do this, or make sure the legend and annotations are in diffferent places/don't overlap (by moving the legend?). ... View more

I'm not sure I understand the utility of this solution. The output assigns the value 10 to all percentiles between 0% and 33%. I would expect the 10 value to be assigned just to 0%. Using the formula in my first post, the percentile would be 0% and not any other values. The second value, 40, would be assigned a percentile of 50%, not all the percentiles between 34% and 66%. ... View more

should be careful with this kind of data. why do these special values occur? Possibly they mean something. Check with someone who knows that data source, or the service provider good luck PeterC ... View more

Hi: That's one way. Or, if you are going to create your counter for unique stores up in the data step, you could just do the entire report in the DATA step -- by just testing whether you're at the end of file -- you can have the DATA step accumulate your totals and then only write them out one time. The END= option lets you name a variable that you can test to detect when the end of the input file has been reached. The value of your variable (EOF) is 0 for all the rows and then EOF=1 on the last row. cynthia [pre] ods listing; ods html file='c:\temp\data_null.html' style=sasweb; title 'With Data Step'; data _null_; set tmp end=eof; length Distinct TotVisit 8; by store; retain distinct totvisit 0; if first.store then do; Distinct + 1; end; totvisit + visitors; if eof = 1 then do; file print ods=(variables=(distinct totvisit)); put _ods_; end; label Distinct = 'Number of Stores' Totvisit = 'Total Visitors'; format Distinct Totvisit comma6.; run; ods html close; [/pre] ... View more

Just to update everyone, the EXECUTE statement worked when using the SAS pass-through facility. ... View more

Worked perfectly. Thanks. ... View more

These are all great suggestions. Thanks for your help. ... View more

I am a user of SAS on a server who cannot use SAS on a local machine. Several times I did wish for a local license. Don't know all the technical and cost issues, but I'll throw my 2 cents in as a user. 1) Large projects run faster, but small projects can take longer. Considering my datasets, I'm sure I have saved weeks because of the server, yet it seems to know when someone else is watching my computer waiting for the results. 2) Codes with data imports require me to FTP my data to the SAS Server. If someone gives me an updated Excel file every week, I can't put it in My Documents and expect my import to be able to find it. If all your data is on other servers, then you are good. 3) I am in regular contact with my IT department to help me solve various issues that would be easy to solve if I ran SAS locally. The documentation I can understand is usually geared toward local licenses. 4) If the server is down or I am travelling, I am can't even open my SAS data sets. 5) My computer can easily handle being 3 or 4 of the users on the SAS server without any notable issues. Saves a lot of time when I know 1 project will take 5 minutes to process. 6) Microsoft Add-in - Can people use this without a server? Great way to give data to people who barely know Excel. ... View more

:If you want a macro to treat a date constant as the corresponding number-of-days-since 1960, use the %sysevalf() like [pre] %if %sysevalf( %&sysdate9"d ) gt %sysevalf( "&my_date"d ) %then %do; [/pre] Good Luck PeterC ... View more

Have you tried to break the query into smaller parts? For example if you are hitting 5 tables can you try to break it into 2 proc sql steps? I find that helps when I get that error ... View more

Hi Olivier, Thanks for your explanation. You code even resolved the issue as post 22 where some column headings has on numeric and SAS imposes the 'F' in front. I also want to THANKS everyone for their input to this thread that help me to resolve my problem. Regards Kwok ... View more

Hi: That's good. Glad it worked out. cynthia ... View more