What to do when our spam filter traps your post

[BeverlyBrown]

Sometimes you hit “post” and our platform whisks your stuff to our spam quarantine. Unfortunately technical content, with code and arcane symbols, is susceptible to being detained.

Good news: It’s now easy to alert community admins to release falsely imprisoned posts. You have two options:

1) View your new message or reply. If you see the following, click “abuse report” where indicated below to notify us:

 Bad news: your post smelled like spam.

Just ask, we'll release it for you.

2) Or you can email us at communities@sas.com.

Our filter does an amazing job of keeping real spam out of our communities. You’d be shocked at what and how much junk spammers try to sneak through!

More good news: Our filter is getting “smarter” as time goes on. Each time a community admin releases a wrongly jailed post, it becomes less likely the filter will detain another like that.

[dane77221]

This post was not spam how do I I get it back up?

I  have a weekly report I am running where I need to take an unknown number of columns that I need to convert to a running total.

Please try to keep in mind I created this very simple example, the data including the headers are much more complicated,  Also I am trying to automate this so I never would have to actually look at the the file to run my program. Variable names will never be the same from day to day 

Below is the code I have started with

please let me know what I am doing wrong, Macros are not my specialty so I am very open if I am going the wrong way about this.

DATA HAVE;
infile datalines delimiter=',';
INPUT 
SALES_ID $ MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY SATURDAY;
DATALINES;
A1,45,61,60,14,74,35
A2,65,72,68,79,70,30
A3,24,17,16,69,29,18
A4,81,84,46,82,49,34
A5,81,38,67,40,88,11
A6,52,89,47,48,68,70
A7,62,10,41,73,49,42
;
RUN;

PROC CONTENTS DATA = have OUT = COL_STEP1;
RUN;
/*The varnum greater than one will always be know, however the total number of columns will can not be hard coded*/
PROC SQL;
	CREATE TABLE COLS AS
	SELECT DISTINCT
	NAME AS COL,
	VARNUM AS COL_NUM
FROM COL_STEP1
WHERE VARNUM > 1
ORDER BY VARNUM;
QUIT;


PROC SQL NOPRINT;
	SELECT DISTINCT MAX(COL_NUM)-2 INTO :N
	FROM COLS;
QUIT;

PROC SQL NOPRINT;
	SELECT DISTINCT col INTO :col1
	FROM COLS
	having col_num = min(col_num);
QUIT;
DATA IFILE (KEEP = COL);
	SET COLS;
	WHERE COL_NUM > 1;
	IF &N = 1 THEN STOP;
RUN;


%PUT NOTE: &N columns to aggregate &col1;
PROC SQL;
	CREATE TABLE ID_TABLE AS
	SELECT
	SALES_ID,
	&COL1,
	&COL1 AS TOTAL
FROM HAVE;
QUIT;

%MACRO TEST;

%DO X = 1 %TO &N;
DATA _NULL_;
		SET IFILE (FIRSTOBS=&X OBS=&X);
		CALL SYMPUT ('COL', STRIP(COL));
	RUN;
PROC SQL;
	CREATE TABLE ID_TABLE AS
	SELECT A.SALES_ID,
	B.&COL + A.TOTAL AS &COL,
	B.&COL + A.TOTAL AS TOTAL
FROM ID_TABLE AS A 
LEFT JOIN HAVE AS B
ON A.SALES_ID  = B.SALES_ID;
QUIT;
%END;
%MEND TEST;
%TEST;

[BeverlyBrown]

Hi @dane77221, your post is published now. Apologies for the inconvenience!

[dane77221]

Thank you!

[art297]

@BeverlyBrown: I have to ask! What caused that post to be spam filtered?

I know I had one, sometime back, that was altered because I had the names (without the asterisks) T * o * m, D * i * c * k and H*a*r*r*y

Art, CEO, AnalystFinder.com

[BeverlyBrown]

No idea, @art297. @dane77221 is a fairly new member, and I've noticed the filter sometimes singles out their posts. Sometimes a string of edits a short time apart seem to be the trigger. Maybe you just gotta close one eye and smirk just right. 😉

[Chuck_IV4]

Put a post up for help with proc HTTP and it was marked as spam. Please put it back. I really need some help on my topic.

**EDIT**

Thank You for returning it to the boards.

[AnnaBrown]

Hi @Chuck_IV4,

I just released your post. Thanks for using the communities!

Anna

[CC_SAS]

Below post is not a spam, how do i get it back?

Re: PROC Report - Repeat Header on a new page

Thank you for the help 🙂

[jfer]

Very fast turn-around time to get my post out of limbo - much appreciated!

[avner]

my post is not a spam, can anyone help to get it back asap, I was troubled by this problem for several days.  

[manonlyn]

My post is not spam 

https://communities.sas.com/t5/New-SAS-User/Cumulative-sum-subtraction-dependent-on-flag-and-account...

Please can you unblock this asap, I'm on a strict time constraint. thanks!

[ShelleySessoms]

HI @manonlyn,

I have put this back into the community. Sometimes things are marked as spam if you edit them after posting. Sorry you got caught in this.

Best,

Shelley 

[deltron]

Still waiting for moderators to take my post out of spam quarantine. I provided sample code and screenshots of output. Title of post is, "

Using PROC FORMAT & PROC FREQ with mixed results - County Data"

[BeverlyBrown]

Hi @deltron, apologies for the delay! Your post is live now. 

[deltron]

Awesome! Appreciate it.

[babykxy]

My post is not spam 

https://communities.sas.com/t5/New-SAS-User/how-to-label-both-value-and-percentage-values-inside-bar...

Please  check my post,  can you unblock this,  thanks!

[kwil]

My post was incorrectly identified as spam as well - the title is 'How to get a set of returns with replacement if data stops?'

any help would be appreciated 

[BeverlyBrown]

@kwil I have released your post. Apologies for any inconvenience!

[Leo_SAS]

Kindly ask to release my post, it's not spam.
https://communities.sas.com/t5/Administration-and-Deployment/Stored-Processes-are-endlessly-in-progr...

[ChrisHemedinger]

We got you @Leo_SAS 

[Angel24]

Hi,

My post got marked as spam. Can someone please help me to get my post back? I urgently need help. 

[BeverlyBrown]

@Angel24 It's posted now.

[silversky9]

Hi, my post 'Complex aggregate calculation help' was marked as spam as soon as I posted.  I don't see any message in my profile about it, but it is not in the forum.  Can you please put my post back up?  It is not spam, and I really am looking for help with my question.

Thank you.

[BeverlyBrown]

@silversky9 It's posted now. Sorry for any inconvenience!

[silversky9]

Thanks so much for your prompt reply @BeverlyBrown, greatly appreciate it!

[BeverlyBrown]

@silversky9 We're here to help. Posts disappearing is a pain...it's happened to me too. But better an over-zealous spam filter and a slack one, right? Thank you for being a member.

[pdwivedi08]

I've posted couple of times today and all my posts are getting marked as spam. It's super frustrating. 

I'm stuck at a place and really need community support but the spam detection some how keeps marking my post as spam. 

Could you please help admin @BeverlyBrown, or whosoever is moderating the forum. 

[elton_]

Kindly ask to release my post, it's not spam.

https://communities.sas.com/t5/Administration-and-Deployment/A-connection-to-the-SAS-Compute-Server-...

[ChrisHemedinger]

We got you @elton_ 

[sophielr]

Hi,

I just post a question about sas, why is this a spam?

[etrock]

my post got marked as a spam. Could you please help @ChrisHemedinger 

https://communities.sas.com/t5/New-SAS-User/SAS-Viya-Deployment-on-Openshift-Locally-in-Windows-usin...

[BeverlyBrown]

Hi @etrock your post has been released from the spam filter. Apologies for the inconvenience!

[tan1721]

Hi, 

my post was marked as spam. 

could you please help @communities@sas.com.

The title is "sample size for the categories of a nominal variable".

[StrugglingStats]

I didn't have success with either of these methods for my post that was flagged. I got spam blocked for adding additional context to my topic question, and submitted and email to get out of spam jail, but looks like it's incarcerated. 

[norachanisara]

Dear community manager,

My post was marked as spam but I am sure I have not included anything inappropriate. Even the code itself was based on a hypothetical situation I came up myself. 

My post is called "Combination of VRP and Scheduling problem based on Home Healthcare Problem".

https://communities.sas.com/t5/Mathematical-Optimization/Combination-of-VRP-and-Scheduling-problem-b...

[ChrisHemedinger]

@norachanisara Got you -- released this now.

[cheroij]

Hi Community managers,

My post was marked as spam. It does not have any inappropriate information. I emailed and filled the form but no response yet.

[Rebecca_K]

Hello!  My post was marked as spam, could you please release?  I'm pretty sure there's no inappropriate content, but let me know if there's an issue.  I posted this last week as well, and received the "Spam" blockage, and tried to request it released, but no response yet.  thanks for your help.  

User:  Rebecca_B

Topic:  How to write the contents of a table to an email

[ShelleySessoms]

Hi @Rebecca_K 

I have released your post now. I initially couldn't find it in the quarantine last week. I do apologize for the delayed response. And thank you for using the SAS Community.

[Rebecca_K]

Thank you very much!