Hi @PaigeMiller ,
When I used only out=test1, it is not showing all the variables in the dataset. The variables can be seen in the output window, but I was not able to see them in the dataset where I can further process them. To further process them, I need them in the dataset instead in output window.
To find out which file is getting created at the background to store this information (which is available in output window), I used following code with ods trace on.
ods trace on; ods output onewayfreqs=xxx; proc freq data=one;
format _CHAR_ $missfmt.; /* apply format for the duration of this PROC */
tables _CHAR_ / out=test1 missing missprint nocum nopercent;
run; ods trace off;
As a result, I can now see the dataset in xxx but it is too complex to comprehend. It can be comprehended but there are other ways like macros to find out. I was thinking if there is any simpler way. I found the above approach simplest but that is not giving me information in dataset but only in output window and when I got the dataset which is creating that output window, it is again too complex.
Thank you.
- Dr. Abhijeet Safai
... View more