Hi,   I have a dataset that I would like to output in a csv file after rounding the average of a variable to one decimal place. I also would like whole numbers to appear like this '10.0'. I used a format in my SAS dataset to ensure that whole numbers would keep that trailing zero, but when I export out into a csv file, the trailing zeros are lost.   Is there a way I can ensure that the trailing zeros won't be lost once it is converted into a csv file. I am using proc report to generate my csv file.   Thank you!     data all2; set all1; avg=round(average,0.1); format avg 5.1; run; %let rptfile=Average; %let outpath=\\desktop\; ODS _ALL_ CLOSE; ods csv file = "&outpath.&rptfile..csv" options ( SHEET_NAME="Report" AUTOFILTER = "all" EMBEDDED_TITLES ="yes" ORIENTATION ="landscape" frozen_headers='3' absolute_column_width='8, 10, 16, 12' ) ; title2 "Report Generated"; proc report data=all2 nowd split="~" style(Header)=[just=left font_weight=bold font_size=10pt] style(column)={just=left vjust=center font_size=10pt font_face=times background=white foreground=black bordercolor=black}; columns subnum avg ; define subject/"Subject"; define avg/"Average"; run; ods excel close; ... View more

Hi, I am trying to round an average to one decimal place without losing the trailing zero if it rounds to a whole number.   For example 8.255 --> 8.3 10.01--->10.0 (instead of 10, which my program is currently outputting)   data x; set y; avg=round(average,0.1); run;   Thank you, any help is much appreciated ... View more

Hi, If I would like to round up or down for a specific variable in a dataset under these two conditions, what would be the best/easiest way to do this in SAS?   For decimal value outcomes < X.5, round down to the nearest integer For decimal value outcomes ≥ X.5, round up to the nearest integer   I've seen it done as a do loop, but that seems overly complicated.   Any help is much appreciated, thank you! ... View more

Hi, I have a fairly complicated issue that I have been trying to work and wanted to see whether anyone had a better way of going about this. I have a dataset that includes weight, systolic BP, and diastolic BP that has been collected on different days of the year. I would to calculate the percent change of the WEIGHT, SBP, and DBP variables at each previous date. I first created a count variable to order the dates from oldest date to newest date for each subject, and now I am trying to find a way to tell SAS to calculate the percent change for the weight, SBP, and DBP records for every date using the records from the date that comes before it. So COUNT 2-1, 3-2, 4-3, etc....   My dataset looks like this: Subject          DATE                WEIGHT          SBP            DBP              COUNT 154              30NOV2016             102              120             80                     1 154              15DEC2016             102              115              75                     2 154               02JAN2017             110              120              80                     3 104               20SEP2016             145             120              80                     1 104               02JAN2017              110            120              80                      2 104               20FEB2017             145             120              80                     3 104               02MAR2017           110              120              80                      4 104               20APR2017             145             120              80                     5        Any help would be greatly appreciated! Thank you! ... View more

Hi, I would like to create a list of 25 randomly generated numbers that start with the two letters "AB----" ex: AB14587, AB65899, AB36525, etc.   I looked into the RAND function, but can't seem to figure out how I would incorporate the "AB-" in there.   Any help would be much appreciated! ... View more

Hi, I have a variable called "comment" that contains a string of words that are separated by '~'   example: comment text text text text ~ text text text text text text text ~ text text text ~text text    I would like to extract the text after the first ~ without losing the text behind the second or third or fourth ~ etc.   I tried using this code: cm=scan(comment,1,"~");   But it only extracts the text after the first ~ and then stops once it reaches the second ~   Any help is much appreciated! ... View more