Hi All,
I met a problem which confused me a lot. I'm using ods option and PROC REPORT to output a dataset in excel format. However, in my dataset, I assign a variable with period "." as missing value. The variable is character and it contains two values such as "1500" and ".". When proc report process done, in SAS EG output window, the result display as . and 1500 while in excel file, it display as 0 and 1500. Attachment are the snaps.
Snap1.png is the screenshot of result window in SAS EG ,variable cc is displayed as period and 1500
Snap2.png is the screenshot of reporint dataset, variable dose_act(which is cc) is shown as . and 1500 for charater variable
Snap3.png is the screenshot of output excel file, variable dose_act is shown as 0 and 1500.
By the way, in snap3.png there are two more variables LIMIT and CENS, these two variables also contains period as charater variable but in excel file can display as . also
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: