Results Table with blanks?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 14
Accepted Solution

Results Table with blanks?

Hello,

I'm using PROC SURVEYFREQ in SAS EG, but when the results come through I'm getting blank cells next to the respond options. What am I doing wrong?

Picture1.JPG

(in the first column of the 2nd table, under 'REGSAM' I would expect the various response options, in this case 1,2,3...)

Regards


Accepted Solutions
Solution
‎08-28-2014 04:54 PM
Respected Advisor
Posts: 3,852

Re: Results Table with blanks?

Posted in reply to Silvertreetops

Change it to something with smaller W best3. perhaps.  or just remove it completly.  In your proc step add FORMAT regsam;

View solution in original post


All Replies
Respected Advisor
Posts: 3,852

Re: Results Table with blanks?

Posted in reply to Silvertreetops

What is the FORMAT associated with REGSAM?

Occasional Contributor
Posts: 14

Re: Results Table with blanks?

Posted in reply to data_null__

Hi data_null_;

Thanks for helping out. The format is BEST12.

Picture2.jpg


Solution
‎08-28-2014 04:54 PM
Respected Advisor
Posts: 3,852

Re: Results Table with blanks?

Posted in reply to Silvertreetops

Change it to something with smaller W best3. perhaps.  or just remove it completly.  In your proc step add FORMAT regsam;

Occasional Contributor
Posts: 14

Re: Results Table with blanks?

Posted in reply to data_null__

Bingo - thank you for your help. I guess then that there were effectivly 11 spaces after the single digits, pushing them out of view?

Super User
Posts: 13,583

Re: Results Table with blanks?

Posted in reply to Silvertreetops

actually more like trying to right justify 12 characters in space for fewer though I haven't seen this happen in BASE SAS so it may be an EG thing with different display characteristics.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 285 views
  • 0 likes
  • 3 in conversation