topic Re: Results Table with blanks? in SAS Programming

Results Table with blanks?

Silvertreetops — Thu, 28 Aug 2014 20:23:08 GMT

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?

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

Regards

Re: Results Table with blanks?

data_null__ — Thu, 28 Aug 2014 20:35:02 GMT

What is the FORMAT associated with REGSAM?

Re: Results Table with blanks?

Silvertreetops — Thu, 28 Aug 2014 20:51:50 GMT

Hi data_null_;

Thanks for helping out. The format is BEST12.

Re: Results Table with blanks?

data_null__ — Thu, 28 Aug 2014 20:54:15 GMT

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

Re: Results Table with blanks?

Silvertreetops — Thu, 28 Aug 2014 21:00:42 GMT

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

Re: Results Table with blanks?

ballardw — Fri, 29 Aug 2014 15:23:34 GMT

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.