I think it's also the observation of ID=05.   proc sort data=have; by id; run; data want; set have; by id; if first.id and last.id; run; or   proc sql; create table want(drop=cnt id2) as select * from have left join (select distinct count(*) as cnt, id as id2 from have group by id) on have.id=id2 where cnt=1; quit; ... View more

Is it like this? If this is not what you intended, please be specific about what kind of data set you want.     data want(drop=i); set have; array unit[4] q1_2018_units q2_2018_units q3_2018_units q4_2018_units; array stdunit[4] q1_2018_stdunits q2_2018_stdunits q3_2018_stdunits q4_2018_stdunits; do i=1 to 4; if unit[i]=0 then stdunit[i]=0; end; run; Results:     ... View more

Are you running the SAS nls (National Language Support/Local language) version? Can you run SAS by "SAS(Unicode support)" short cut? The Excel file you are trying to work with contains unicode strings, so you should need SAS that can handle unicode, i.e. SAS unicode support. ... View more

Since you can't use the intck function in the proc step, I think you should first calculate the value in the data step and then output it in the proc print. ... View more

please try this code. I think the Excel file was created on a PC with wlatin1 character encoding. So, the encoding of the first filename needs to be wlatin1. The encoding of the next filename needs to be utf-8 so that emoji can be imported into SAS. You can use any file name you want, even temp.dat. The following code will create the file in the work library.   filename mon_f "%sysfunc(pathname(work))\temp.dat" encoding='wlatin1'; libname x xlsx "XXXXX\data_act.xlsx"; data _null_; set x.TWEET_ACTIVITY_METRICS_AG2RLMP_; file mon_f lrecl=1000000; if notdigit(scan(Identifiant_du_Tweet__Permalien,1,',')) and length(scan(Identifiant_du_Tweet__Permalien,1,','))>1 then put '|' @; else if length(scan(Identifiant_du_Tweet__Permalien,1,','))>1 then do; put; end; len=lengthn(Identifiant_du_Tweet__Permalien); put Identifiant_du_Tweet__Permalien $varying32767. len @; run; filename mon_f; filename mon_f "%sysfunc(pathname(work))\temp.dat" encoding='utf-8' nobom; proc import datafile=mon_f dbms=csv out=donnee replace; getnames=no; run; filename mon_f; libname x; ... View more

Basically, you can do this by sorting in descending order, since SAS can only retain the previous value using the retain statement. The procedure is to sort in descending order once, fill in the missing values, and then re-sort in ascending order. In this case, it is better to keep the observation number as the key, using _n_ in the previous data step.   /* remember number of variables */ data _null_; set sashelp.vtable; where libname=upcase('WORK') and memname=upcase('SAMPLE');/* modify this line to your library and dataset name */ call symputx('nvars',num_numeric+1);/* +1:for key variable */ run; data want(drop=i); set work.sample;/* modify your dataset name */ key=_n_; array _n{&nvars.} _numeric_; array _rn{&nvars.} 8 _temporary_;/* variables for keeping data of previous observation */ retain _rn:; do i=1 to dim(_n); if missing(_n{i}) then _n{i}=_rn{i}; _rn{i}=_n{i}; end; run; data sort; set want; run; proc sort data=sort; by descending key; run; data want(drop=i); set work.sort; array _n{&nvars.} _numeric_; array _rn{&nvars.} 8 _temporary_;/* variables for keeping data of previous observation */ retain _rn:; do i=1 to dim(_n); if missing(_n{i}) then _n{i}=_rn{i}; _rn{i}=_n{i}; end; run; proc sort data=want out=want(drop=key); by key; run;     ... View more