Hello Ssas, This could be a possible solution to our problem: [pre] data a; input p1 $ 1-2 v1 4-5 p2 $ 7-8 v2 10-11 p3 $ 13-14 v3 16-17; datalines; a1 5 a4 23 a1 12 a7 45 a5 21 b1 32 a3 36 c4 41 a3 52 b1 28 a3 35 d2 20 a4 52 d2 62 y4 43 a5 32 e1 21 g2 21 ; run; data b; set a(in=a1 keep=p1 v1 rename=(p1=p v1=v)) a(in=a2 keep=p2 v2 rename=(p2=p v2=v)) a(in=a3 keep=p3 v3 rename=(p3=p v3=v)); if a1 then var=1; if a2 then var=2; if a3 then var=3; run; proc sort data=b; by p; run; proc transpose data=b out=r prefix=v; var v; id var; by p; run; [/pre] Sincerely, SPR ... View more

Thanks to you both for your kind response. reg. forst question , I have 1500 responses just quoted from 1-5 for satisfied and 1-6 for informed. I mean i need to group them how many 1s,2s.... for satisfied and same for the informed and then plot the graph please guide me the right way to do ... View more

No idea how you get the sums in your examples with the data you give us. The following code might give you some hints of how to tackle this challenge: data have; infile datalines dlm=' ' dsd truncover; input paper1 paper2 paper3 paper4 web1 web2 web3 radio1 radio2 tv1 tv2 age gender; anytwopapers= (sum(of paper:)=2); radio= (sum(of radio:)>1); tv= (sum(of tv:)>1); web= (sum(of web:)>1); datalines; 1 0 1 0 1 0 0 1 1 0 1 2 1 1 1 0 0 0 1 0 0 1 1 1 3 2 1 1 1 0 1 1 1 0 0 0 1 4 1 0 1 0 1 1 1 0 0 1 0 1 1 2 0 0 1 1 0 1 0 1 0 0 1 2 2 run; proc format; value gender 1='Male' 2='Female' other='?' ; quit; proc tabulate data=have format=8. noseps; where anytwopapers=1 and (radio=1 or tv=1 or web=1); class age gender anytwopapers radio tv web; format gender gender.; keylabel n=' ' ; table age all='Total', (gender all='Total')*(anytwopapers radio tv web ) /rts=10; run; Message was edited by: Patrick ... View more

Because the data are in one row per person, you can get it with a FREQ TABLE statement like TABLES paper1*paper2; BY gender agegroup; then you just add up all the cells other than the 0-0 one for each age and sex category. With a DATA step, you could get at it more directly; DATA new; SET old; AnyPaper = paper1*paper2; RUN; PROC FREQ DATA=new; TABLES gender*agegroup*anypaper; RUN; ... View more

"but some of the variables are unable to read( with some wild chars.) " The variable name or the variable values? If it's the name then use in step 2 of the import wizard this option "....comply with SAS naming standards...". You could also try to export your SPSS data to Excel and import this - but according to the docu a .por file is the best way to go. Cheers Patrick ... View more

359! a.member_no,a.fee,a.surnames,a.title,a.pcode,a.expiry,a.joined,a.name,a.dob,a.email,a.cn 359! tr,a.postc, 360 b.member_no,b.fee,b.surnames,b.title,b.pcode,b.expiry,b.joined,b.name,b.dob,b.email,b.cn Which member_no do you want? Pick one or rename one like b.member_no as new_member. for each variable. Try select * from d1 intersect corr all select * from d2; ... View more

maybe you have columns in different orders. maybe something else. Reading the manual on line helps select the relevant section "set operators", just by searching from this page for "sql except operator" in "product documentation". I found "corresponding". It also shows that you don't use the "ON " syntax of a join. Have a look at the examples yourself. And next time, please post the ERROR: messages. good luck PeterC ... View more

Excellent, Thanks a lot for your help. Sukanya's and Cynth's suggestions are really helpful. Many thanks mate(s) ... View more

Hi SBB, Thanks for your help. I found the answer. I just used the dif function. data cctest1; set cctest; tix06=dif(tix_sold_in_06); tix07=dif(tix_sold_in_07); tix08=dif(tix_sold_in_08); if tix06 eq . then tix06=tix_sold_in_06; if tix07 eq . then tix07=tix_sold_in_07; if tix08 eq . then tix08=tix_sold_in_08; run; Thanks for your thought sams ... View more

Hello Sams1, It should be ok now. There are two possible solutions, I think, as proposed by Scott. Yoba proc sort data=test1 out=test2; by price; run; data test2(drop=notix); set test2; by price; if first.price then tot=0; tot+notix; if last.price then output; run; proc means data=test1 noprint nway missing; var notix; class price; output out=test3(drop=_TYPE_) sum(notix)=sum_notix; run; ... View more

Did you even try using the example SAS code that was provided by another forum subscriber? Scott Barry SBBWorks, Inc. ... View more

Sorry. It is my fault. I offer you the wrong code. It should use || instead of comma. call execute('%Readcsv(csvfile='||strip(fname)||')'); or try to use cats() function: call execute(cats('%Readcsv(csvfile=',fname,')')); Ksharp ... View more

Thanks for you help sams ... View more

Overview of the Time Series Forecasting System Introduction http://support.sas.com/onlinedoc/913/getDoc/en/etsug.hlp/tfintro_index.htm Scott Barry SBBWorks, Inc. ... View more

Sounds like the installation didn't finish successfully. If your local tech support can't help, it's time for a call to SAS tech support. If you don't have admin rights, or the local tech support only gave you partial rights, things like this can happen. You can do some limited testing. For instance, if you double click on a file with the .sas extension, does SAS come up. ... View more