In the column "event" My goal is to keep only 4010, but column event  has COMBINED VISIT (-334 & -324) (4010)   The code below returned only VISIT. But I am interested in 4010   data want; Set have; redundant=scan(event,1,' '); event=scan(event,2,' '); drop redundant ; run;   ... View more

Hi. In same data A, I would like to count those who answer the number of days to each question for the use of cigarette or marijuana which can range from 0-30 in QN1 and QN2, and code them into any_user . Please note apart from any number from 0 to 3 there are character options to question stem such as 'N' for not answered and 'Z' for skipped.   QN1: During the past 30 days, on how many days did you use e-cigarettes? N Z 0 1 2 3   QN2: During the past 30 days, on how many days did you use marijuana? N Z 0 1 2 3   Data A, if QN1 in (1-30) or QN2 in (1-30) then any_sub_user=1; else any_sub_user=2; run;   ... View more

Hi I am trying to transpose the population data below from long (data A) to wide (data B) Data A. age      pop  counties 1           10     A 2          5        A 3          7       A 1           6       B 2          4       B 3          5      B 1           8     C 2          9      C 3          6      C   I want to to look like this (counties, numeric of age (1 2 3), sum total of age by county (total): Data B.  Counties  1        2         3      total A               10      5        7       22 B               6        4        5         15 C              8         9        6         23   But the code below is not working. Thank you proc transpose data=A out=B; by counties; id age; var pop; run;                 ... View more

Hi. I am creating a dataset and I need a column to retain one decimal place for every value (including integers and thoses I rounded off to once decimal place). In the work library it retains the decimal point but it keeps reformatting integers to whole number when I export in csv. For example, I want 5 to be 5.0 and not 5. I tried these codes below  but the csv keeps formatting back to integers: 1, 5, 7 etc. data new; set old; format Measure 13.1; run; data new; set old; format Measure 13.1; Measure=round(Measure,0.1) run; proc export data=new dbms=csv outfile="C:\Desktop\new.csv." replace; run Thank you ... View more