Thank you so much! ... View more

can you please send me the details how to do Re: Dependency between drop down list .last step i didnt understand.i am new to sas ... View more

You may prefer next code (more simple then my previous solution): data temp; infile cards dlm='09'x truncover; input a_line $250.; cards; Name Code Hr Bid Department Called-In Abs Dept Seniority 27-JAN-2020 1 12-OCT-2019 / 2 8.000 A SMITH, JOHN P (999999) MECHANICAL [2] MECHANICAL [2] Name Code Hr Bid Department Called-In Abs Dept Seniority 29-JAN-2020 2 05-MAY-2018 / 2 8.000 A SMITH, JOHN R (999999) EMPLOYEE RELATIONS [3] PROCESSING [3] Name Code Hr Bid Department Called-In Abs Dept Seniority 21-JAN-2020 3 13-JUN-2009 / 6 8.000 A SMITH, JOHN J (999999) MECHANICAL [3] MECHANICAL [3] Name Code Hr Bid Department Called-In Abs Dept Seniority 20-JAN-2020 4 07-DEC-2006 / 2 8.000 A SMITH, JOHN O (999999) MECHANICAL [2] MECHANICAL [2] Name Code Hr Bid Department Called-In Abs Dept Seniority 19-JAN-2020 5 24-MAR-2001 / 8 8.000 A SMITH, JOHN C (999999) PROCESSING [3] PROCESSING [3] Name Code Hr Bid Department Called-In Abs Dept Seniority 30-JAN-2020 6 03-NOV-2002 / 4 8.000 A SMITH, JOHN G (999999) MECHANICAL [2] MECHANICAL [2] Name Code Hr Bid Department Called-In Abs Dept Seniority 10-FEB-2020 Name Code Hr Bid Department Called-In Abs Dept Seniority 11-FEB-2020 1 22-NOV-2001 / 8 8.000 A SMITH, JOHN S (999999) PACKING [2] PACKING [2] ; run; data tmp2 (keep=var1-var14); length line_out $200 var1-var14 $30; array vx {*} $ var1-var14; set temp; split_pos = index(substr(a_line,5),"Name"); if split_pos = 0 then do; line_out = strip(a_line); link out; end; else do; line_out = substr(a_line,1,split_pos+3); link out; line_out = substr(a_line,split_pos+4); link out; end; return; out: do i=1 to 14; vx(i) = scan(line_out,i,'09'x); if missing(vx(i)) then leave; end; output tmp2; return; run; ... View more

Please open new threads for new questions in future.   0 is a number ( is not a number 0.0 is a number ) is not a number   To get the two separate numbers then you need two variables, and string parse the string you have: data abc; input a $ b $; c=input(scan(b,"(",1),best.); d=input(compress(scan(b,"(",2),")"),best.); data lines; Normal 0(0.0) run; c takes the first number (i.e. the text before the opening bracket) and converts it to numeric using best format. d takes the second number (i.e. the text after the opening bracket), removes the closing bracket, then converts to number using best format.   I assume this is from clinical outputs where 0 is the count, and 0.0 is the percentage of population, you should be refering to the underlying data, not the produced output! ... View more

You could just set option missing to blank though. It'd definitely doable. option missing = ''; ... View more

data t; infile "...." dlm="," dsd; input c1 $ c2 $ c3 $ _c4 :$20.; length c4 $1; do i = 1 to countw(_c4,','); c4 = scan(_c4,i,','); output; end; drop i _c4; run; So you see you can do it in the input data step already. ... View more

Show use some values that are character. I suspect that you have something such as NULL, NA, N/A or similar in the data somewhere and occuring often enough that the GUESSING elment of Proc import says it is character. If you know the first 5 rows are actually numeric in appearance them perhaps use Guessingrows=5 (or what ever number of rows at the top work) but his may cause issues with lengths of other character variables.   Or write a data step. The proc import code generated one and it should be in the log that you could copy, paste into the editor and modify the informat to be best6. or similar instead of the extemely likely $6. . ... View more

To get just a little more information, you could try:   proc freq data=have; tables variable / missing; run;   Now you'll see how often each value appears in your data set. ... View more

data WORK.SAMPLE; infile datalines dsd truncover; input Offer:$194.; datalines4; save $1.00 w/purchase/any 4 or more mix & match save $0.73 w/Just For U (Limit: 1) save $1.00 w/purchase/any 4 participating items mix & match save $1.00 w/purchase/any 4 or more mix & match save $1.00 w/purchase/any 4 participating items mix & match "save $1.00 w/purchase/any 4 participating items mix & match, save $1.00 w/purchase/any 4 participating items mix & match" save $4.00 w/purchase/4 or more mix or match save $3.00 w/purchase/any6 participating items mix & match save $4.00 w/purchase/any 4 participating items mix & match save $3.00 (Limit: 5) save $5.00 w/purchase/5 participating items mix & match save $5.00 w/purchase/5 save $1.00 (Limit: 1) save $1.00 (Limit: 1) save $4.00 w/purchase/any 4 participating items mix & match save $4.00 w/purchase/any 4 participating items mix & match save $3.00 w/purchase/any 6 participating items mix & match save $0.50 w/purchase/any 4 or more participating items mix & match save $5.00 w/purchase/5 participating items mix & match save $5.00 w/purchase/any 5 participating items mix & match ;;;; data want; set sample; pid=prxparse('/(?<=purchase\/)(any)?\s*\d+/i'); call prxsubstr(pid, offer, position, length); if position ne 0 then quantity=input(compress(substr(offer, position, length),,'kd'),best.); drop pid; run; proc print;run; ... View more