@Guptashwe can you provide an example of this task? Preferably with some example data and what you expect the result to look like from that data? Makes it much easier to provide a usable answer with code. ... View more

@Tom wrote: It is the LENGTH and not the format is that will cause truncation for those two character variables. Formats just effect how a variable is displayed. Since no formats are attached the format cannot cause any truncation.    Perhaps you meant the informat?  But when reading using LIST mode SAS will ignore the width on the informat specification.  So even if there was too short a width on the informat it wouldn't cause truncation.   However since no length for the variable has been set SAS will need to decide on its own how to define the length.  And since there is also no informat with its associated width for SAS to base its guess on it will use the default length of 8 characters (bytes actually).   Correct and I mentioned the informat in the second bit. Edited above. ... View more

Hi @Guptashwe  Note that I've updated the subject line of your question to be more descriptive. Please use a more descriptive subject line in the future. This is to allow other future users to search for a topic and find the relevant answers more easily.    @Guptashwe wrote: data t1; input cinfno carte$; datalines; 1 caba 1 cb 2 cb 3 caba 4 cb 4 caba 5 caba ; run;   Using data steps write a code to display the number of customers having  carte: CB Carte: caba carte : both   ... View more

FYI - I've changed the subject in your thread to be more related to your question. 'Need help' is very vague and doesn't indicate the subject of your question.      Here's a similar example of something I tried a while back for data analysis.  https://github.com/statgeek/SAS-Tutorials/blob/master/text_analysis.sas   *Create sample data; data random_sentences; infile cards truncover; informat sentence $256.; input sentence $256.; cards; This is a random sentence This is another random sentence Happy Birthday My job sucks. This is a good idea, not. This is an awesome idea! How are you today? Does this make sense? Have a great day! ; ; ; ; *Partition into words; data f1; set random_sentences; id=_n_; nwords=countw(sentence); nchar=length(compress(sentence)); do word_order=1 to nwords; word=scan(sentence, word_order); output; end; run; *Add happiness index and pos; proc sql ; create table scored as select a.*, b.happiness_rank, c.pos, c.pos1 from f1 as a left join ta.sentiment as b on a.word=b.word left join ta.corpus as c on a.word=c.word order by sentence, word_order; quit; *Calculate sentence happiness score; proc sql; create table sentence_sentiment as select distinct sentence, sum(happiness_rank) as sentiment from scored group by id; quit; @Guptashwe wrote: we need to calculate the score for each day for each tweet. Where we have a word polarity sheet with score and a sheet with tweets data.       ... View more

Assuming that your data already embodies much of the work that needs to be done:   The observations include only cough-related observations The observations are already subset for the years 2007 through 2009 The observations are in order by ENROLID SVCDATE   All that remains is to identify patients that have 3 observations within a 120-day window.  Here is an approach to do that:   data want; id_counter=0; chronic='N'; do until (last.enrolid);    set have;    by enrolid svcdate;    id_counter + 1;    if dif2(svcdate) <= 120 and id_counter >= 3 then chronic='Y'; end; do until (last.enrolid);    set have;    by enrolid;    output; end; drop id_counter; run;   The top loop processes observations for one ENROLID, setting CHRONIC to Y or N.  The bottom loop processes the same observations, outputting them with the assigned value for CHRONIC. ... View more

data have; input Enrolid Index_Therapy $40.; datalines; 114101 Sorafenib,Sorafenib,Sorafenib,Erlotinib 2086103 Sorafenib,Sorafenib,Sorafenib 102950901 Sorafenib,Sorafenib 117102901 Sorafenib,Radio,Radio ; run; data want; set have; array x{999} $ 80 _temporary_; length want $ 200; call missing(of x{*}); n=0; do i=1 to countw(Index_Therapy,','); temp=scan(Index_Therapy,i,','); if temp not in x then do;n+1;x{n}=temp;end; end; want=catx(',',of x{*}); drop n i temp; run; ... View more

Given your data are grouped by brand, this is a classic double DOW task in the data step. Read a group once to calculate the needed value.  Re-read the group using that  value an outputting the data:   data have; infile datalines; input id brand $ loan; return; datalines; 1 mini 70 2 mini 30 3 mini 20 4 mini 10 5 toyota 80 6 toyota 40 ; run; data want (drop=_:); do until (last.brand); set have; by brand; if _loan=. then _loan=loan; else _loan=_loan-loan; end; do until (last.brand); set have; by brand; if _loan^=. then loan=_loan; output; _loan=.; end; run; ... View more

Can you post what your desired result looks like? Makes it much easier to help you 🙂 ... View more

If all you really want to do is PRINT the data, then a single DATA _NULL_ step works:   DATA TEST; INPUT DEPARTMENT $ PRODUCTS $; DATALINES; D1 X1 D1 X2 D2 Y1 D2 Y2 D2 Y3 D3 Z1 D3 Z2 D3 Z3 D3 Z4 run; data _null_; file print; set test; by department; if first.department then put / department @5 products @; else put +(-1) ',' products @; run;   The PUT /   says to advance a line. The trailing @ in a put statement tells SAS to hold the column pointer. So the next PUT statement will not automatically start a new line.  Instead it write to the location of the pointer. The "else put +(-1)" ordinarily uses the + sign to move the column pointer forward.  But in this case it's actually "+(-1)" which tells sas to move BACK one column.  That's necessary because the trailing @ after a variable name (as opposed to a character literal) actually advances one blank prior to holding the pointer.  This overwrites that blank. ... View more

So the variable GROUP will always have the value '2'.   Can you explain why? ... View more