BookmarkSubscribeRSS Feed
What to do when our spam filter traps your post
BeverlyBrown
Community Manager

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.Bad news: your post smelled like spam.

 

Just ask, we'll release it for you.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.

 

 

34 Comments
dane77221
Fluorite | Level 6

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 

image.pngBelow 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
Community Manager

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

dane77221
Fluorite | Level 6

Thank you!

art297
Opal | Level 21

@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
Community Manager

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
Obsidian | Level 7

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
Community Manager

Hi @Chuck_IV4,

 

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

 

Anna

CC_SAS
Obsidian | Level 7

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
Calcite | Level 5

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

avner
Calcite | Level 5

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

manonlyn
Obsidian | Level 7

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
Community Manager

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
Fluorite | Level 6

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
Community Manager

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

deltron
Fluorite | Level 6
Awesome! Appreciate it.
babykxy
Calcite | Level 5

 

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
Fluorite | Level 6

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
Community Manager

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

Leo_SAS
Calcite | Level 5
ChrisHemedinger
Community Manager

We got you @Leo_SAS 

Angel24
Calcite | Level 5

Hi,

 

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

BeverlyBrown
Community Manager

@Angel24 It's posted now.

silversky9
Calcite | Level 5

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
Community Manager

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

silversky9
Calcite | Level 5

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

BeverlyBrown
Community Manager

@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
Fluorite | Level 6

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_
Calcite | Level 5
ChrisHemedinger
Community Manager

We got you @elton_ 

sophielr
Fluorite | Level 6

Hi,

 

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

etrock
Calcite | Level 5
BeverlyBrown
Community Manager

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

tan1721
Fluorite | Level 6

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
Calcite | Level 5

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.