Hi.Cynthia I think you have the right idea. and I totally agree with what you said. You are old expert with sas programming,So forgive me, I just want to write a solution. *^_^* ... View more

Hi. I think there are too many codes, One sql statement can do that. [pre] %let dd= 'tt' 'rr'; ods listing; data gg; input id name $2.; datalines; 1 tt 2 rr 3 gh ; data g_g; set gg; where name in (&dd); run; options mprint symbolgen; proc sql; select quote(name) into :inlist separated by ' ' from g_g; create table out as select * from gg where name in(&inlist); quit; proc print; run; [/pre] Ksharp ... View more

Hi. I think you can copy image from WORK catalog ,then can import it to excel file,and adjust it's size as you need. ... View more

Hi. I agree with Patrick.You need two sql statments. The first one to create your needed dataset by calculated variable. The second one to left jion. ... View more

Sorry. Respond it so late. But not see what your data look like and what your output look like. Is your contract duration numeric variable? It seems to be a format problem. But I am not sure whether the following is what you need. [pre] proc format; invalue pricefmt 0 = 5 12,24= 0; run; .................. price_two = input(contract_duration_value,pricfmt.); format price_two dollar4.; [/pre] Ksharp ... View more

Hi. Not understand your mean totally. It would be better to give what your output looks like. After Cynthia@sas ' s dataset. [pre] data coord; infile datalines; input person $ xval yval; return; datalines; alan 1 2 barb 1 3 carl 1 4 dave 2 5 edna 2 5 frank 2 6 georgia 2 6 harry 2 7 ida 3 2 jack 3 3 kathy 3 3 lewis 3 4 mary 3 5 norm 3 5 ophelia 4 3 peter 4 4 quentin 4 4 rose 4 5 steve 4 5 tara 4 6 umberto 4 7 victor 4 8 wilma 4 8 xavier 5 2 yarah 5 2 zack 5 3 ; run; proc freq data=coord; tables xval*yval / out=count list nopercent nocum; run; proc sql ; select a.person,b.xval,b.yval,b.count from coord as a right join count as b on a.xval = b.xval and a.yval = b.yval; quit; [/pre] Ksharp ... View more

HI. Your code should be like this: [pre] %let dd=%str('tt','rr'); data gg; input id name $2.; datalines; 1 tt 2 rr 3 gh ; run; %macro file1(ts); proc sql; create table out as select * from gg where name in(&ts.); quit; %mend; %file1(&dd.) proc print; run; [/pre] Because your global macro variable dd has a comma,so macro variable ts will resolve to have two parameters,then you need macro function %str() to quote it to avoid to resolve. Ksharp ... View more

Why not use function abs(), which will always give you a positive value! ... View more

Hi. I do not understand your purpose total. Plz, give an example and what target do you need to achieve. ... View more

After Patrick'code . [pre] data have; input jan feb mar apr may jun; cards; 1 2 3 4 5 0 9 8 7 0 6 5 4 5 2 5 0 9 9 0 9 8 7 6 run; data want; set have; tot=indexc(cats(jan,feb,mar,apr,may,jun),'0',-1); run; proc print data=want noobs; run; [/pre] Ksharp ... View more

try function : countc (); [pre] data _null_; freq=countc(' one, two , three ' , ','); put 'The count number of '','' is ' freq; run; [/pre] Ksharp ... View more

Although,I do not understand what your mean .The best way is to give your original data and what do you want data to look like. As far as i understand. [pre] select cd_number, case when cd_number=1 then cd_value end as lastname, case when cd_number=2 then cd_value end as firstname, ................................................ [/pre] Ksharp ... View more

HI . It is very weird. and also spent me a lot of time. But I finally have a resolution. It is a little trick. [pre] ods listing close; ods html file="c:\test.html" style=statdoc; title1 'This is a test'; footnote1 color=blue "test.sas" color=white "aaaaaaaaaaaaaaaaaaaaaa" color=blue "Generate on" ; proc print data=sashelp.class ; run; ods html close; ods listing; [/pre] Ksharp Message was edited by: Ksharp ... View more

Thanks. Peter. you get up early. [pre] proc format; picture pct low -< 0 = '09999.9' (prefix='-') 0 - high = '09999.9' (prefix='+'); run; data temp; input value; format value pct.; [/pre] Message was edited by: Ksharp ... View more

As far as i remember , there are two auto macro variables ( &syserrortext &syswarningtxt ) which include the last error text and the last warning txt. Ksharp ... View more