why don't we retain   data have; infile datalines missover; input id weight height vsdt:date10.; format vsdt yymmdd10.; datalines; 001 65 160 09MAR2017 001 65 . 06JUN2017 001 65 160 18JUL2017 002 55 158 13MAY2014 002 58 . 14SEP2014 002 58 158 15SEP2015 003 70 180 06AUG2017 003 70.5 . 01MAR2018 003 71 . 01FEB2019 ; run; proc sort data=have; by id vsdt; run; data want; set have; by id vsdt; retain height_; if first.id then height_=.; if height ne . then height_=height; run; ... View more

here path 1 represent the path or location of the folder from where you want to import the SAS dataset path 2 represents the location of the folder where you want to copy the same dataset.   So the below will copy the sas dataset from path1 to path2.   Here test is the name of the dataset that you want to copy/import from path1 to path2.   data two.test; set one.test; run; ... View more

I am not clear with the query, but you can try the below code   data have; input Starttime :time5. endtime :time5.; if Starttime>='19:00't then afterhout='afterhour'; format Starttime endtime time5.;; cards; 16:55 17:29 14:41 14:58 20:37 20:43 23:52 0:02 ; ... View more

Yes I agree with your understanding. When we use the words like low or high, it is implicit they refer to lower or higher values hence we do not need the '<' symbol. ... View more

data have; input Name $ ID code $ value; cards; A 1 x1 2 A 3 x2 22 A 5 x3 31 B 1 x1 4 B 3 x2 23 B 5 x3 1 ; data want; set have; by name id; retain cnt; if first.name then cnt=.; cnt+value; cnt2=lag(cnt); if first.name then cnt2=.; if last.name then cnt=cnt2*value; if last.name; drop cnt2; run; ... View more

I tried to shorten the code with arrays, hope it helps   data test; WKT1 = '"MULTIPOLYGON (((1909259740883)))";59701136;20190325101323;VMM;2019/03/25;;2027;GUP-44034-005;LOCHRISTI;Riolering;Gepland;Gemeente;;;2019/03/25;Fix;Riolering; '; array vars(*) $100. WKT id uploaddate source startdate enddate year sourcereference municipality activity status pilot sourceupload synductisid modifydate statussynductis sourceactivity gipodid; do i = 1 to dim(vars); vars(i)=scan(WKT1,i,';','m'); end; run;     ... View more

data wwk; do date ='01Jan2019'd to'31Dec2019'd ; if day(date) =5 then output ; weekday=weekday(date); end; format date date9. weekday DOWNAME9.; run; ... View more