DATA have; INPUT ID Time1 $ 6-13 Time2 $14-22 Time3 $23-31; CARDS; 1234 Current Current 5678 Current Current3 Current 3456 Corrent Past Current 2345 Current ; RUN; DATA want1; if _n_=1 then do; length k $ 100; declare hash h(); h.definekey('k'); h.definedone(); end; SET have; ARRAY x{*} $ time1-time3; do i=1 to dim(x); if not missing(x{i}) then do;k=x{i};h.ref();end; end; flag=(h.num_items=1); h.clear(); drop i k; RUN; ... View more

@mlogan  You can help us help you by always providing the SAS Log part which shows the first ERROR message.  Removing the delimiter statement as @Reeza proposes creates valid Proc Import syntax for a csv file.   Is the ERROR you get by any chance  ERROR: Physical file does not exist   If so then always be aware that any file you want to import via SAS code must be referenced as the machine "sees" it from where your SAS code executes. If you don't have a local SAS installation then that's SAS on your server machine and all paths must be as on your server - which is not your local C: drive.   If you're using SAS EG then there is an upload task to move a file from a local to a server environment and then execute Proc Import against the path on the server. Even easier with EG is to use the Import task (File/Import) as this will both upload your data to the server and generate valid SAS code to read the data in one go. I believe there are similar options available with SAS Studio. ... View more

Thank you sir @Kurt_Bremser   for the beautiful and encouraging words. I like that amazing attitude in wise not old folks like you in filling new folks in the spectrum. While I acknowledge and agree, I must opine arguably older are not older rather wiser and on the contrary the younger ones across the globe are mostly chaos(me very much included being naughty-- not willing to listen and learn) barring a selected disciplined few. Well well, we see that everyday in our streets, metro trains and all walks of life.   Sometimes, I wonder how my parents managed to raise their only child and am glad they are seeing changes though late than never. For what I remember, had I been sincere, attentive and disciplined early on, I would have probably enjoyed finer things in life much earlier.   Well, Good things are happening to me by chance, I wish it happened to me by choice and attentive en-devour. On that note a funny but real and serious truth. I was a fork lift driver at IKEA, Wednesfield in England while attempting to do my undergrad to get that damn degree to keep my parents happy with no interest in it. Anyway, So, Pub was daily routine and we were all well over tipsy. A guy asked -"what do i do for a living". Feeling embarrassed to tell the truth that I am blue collar worker, I replied I work in supply chain logistics haha to sound like a white collar. Then he says, learn SAS and that will be helpful, and much to my surprise it really has been a better addiction than play station/Xbox. His name was Marcin and he was from Munich,  since then paulaner dark dunkel continues to be my favorite 🙂   Thank you for reading!     .       ... View more

FYI - I've moved your posts to the ODS reporting forum, as that's more relevant and combined your double posts into one. Not sure if that was intentional on your part or not. ... View more

FYI - I've moved your posts to the ODS reporting forum, as that's more relevant and combined your double posts into one. Not sure if that was intentional on your part or not. ... View more

Yes, that’s correct. ... View more

If you have a license for the SAS Data Quality procedures I'd look into match code generation to solve this type of problem. http://support.sas.com/documentation/cdl/en/dqclref/70016/HTML/default/viewer.htm#n1597gcbsehaokn1j500v6ius99p.htm ... View more

Function dcreate() creates all parent directories when you create the bottom one.   ... View more

Hi Kiranv, Thanks for the code, but it is not producing the output according to the logic. It is highlighting the total column. With the logic IF _c2_>_c3_, the cell containing 1,982.00 should be highlighted only, but it is not working that way. Would you please look into it. Thanks. ... View more