Search code examples
sastransposequery-builderenterprise-guide

PROC Trasnpose/query builder in SAS Enterprise Guide

After I run Transpose in query builder, i get '.' for empty fields. Is there a way to avoid these '.' ? I can remove those in the next step by adding a case statement but doing this for more than 100 columns won't be a good idea.

123019  1   .   .   .
166584  .   1   .   .
171198  .   .   1   .
285703  .   .   .   1
309185  .   .   .   2
324756  .   .   .   1
335743  .   .   .   .
348340  .   .   .   .

Please help.

Thanks

Solution

  • Dot (missing) is identical to "blank" in SAS. If you're actually printing the data out, you can use the statement:

    options missing=' '; *or 0 or any other character;

    That will be shown for missing (null/blank) values. In some contexts that may not be preserved, in which case you either use a data step to convert to zero, or use PROC STDIZE:

    proc stdize data=mydataset missing=0 reponly;
run;

    which may be faster/easier to code, if you have SAS/STAT licensed.