All,
I have a large dataset in which the majority of the cells are not populated, indicated by a '.'. This was a result of creating columns when I executed a proc transpose.
A | B | C | A + B + C (CALCULATION) | |
1 | . | 10 | 15 | . |
2 | 20 | 10 | 20 | 50 |
3 | . | . | . | . |
1. In datastep when I try to calculate A + B + C for row 1 in the above example, the returned value is . ,rather than 25. How do I perform a sum across columns when one or more of the fields is empty.
2. Alternatively, is there a quick way of doing an if A = . then A = 0 across two hundred columns, without having to do an if statement for all columns. Can this be done across the whole database.
3. Alternatively, is there something I can do in the proc transpose which populates the fields as 0s rather than . s
Any help would be greatly appreciated !
Regards,
Michael
Sum() function: Sum(a,b,c)
Better still leave out the transpose and just SUM the values using PROC SUMMARY using the same BY statement you used in PROC TRANSPOSE.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.