Hi all, I want to merge 2 datasets where one of the by variables could be equal to any of the 2 variables in the other dataset Eg Dataset A variables: ID ,Amt, Serial1 Dataset B variables: ID ,Amt, SerialA, SerialB The by variable Serial1 in datasetA could by same as SerialA or SerialB. ID is also a by variable. Thanks, Amit ... View more

Hi all, I am using proc mapimport to convert a shapefile into SAS dataset. I am getting the following error. Can anyone tell me what the error message means. I was able to see the map on ArcExplorer. Thanks, Amit ERROR: Invalid data length. ERROR: Unknown error encountered while processing .shp file The code: proc mapimport out=AUS_zip datafile='C:\Documents and Settings\Desktop\\POA06aAUST_region.shp'; run; ... View more

Hi, I have made top margin = 0 in in option statement. I still got a lot of space on the top, which I would like to use. Kindly explain me what is the option to reclaim the top space. I have posted my code. Just have to change pdf file location. Thanks, Amit options nodate nonumber orientation=landscape; ods listing; data data1; input country $ metric1 pene; datalines; CAN 161 55 AUS 679 74 NZL 97 70 UK 272 57 MEX 479 49 JPN 844 97 ITA 298 58 ; run; ods listing close; goptions reset=all device=pdfc ftext="swissb"; options leftmargin="0 in" topmargin="0 in" rightmargin="0 in"; ods pdf file='C:\Documents and Settings\Desktop\report.pdf' notoc ; ods pdf StartPage=Never; ods escapechar='~'; title; footnote; ODS layout start; ODS region x=4 in y=0.5 in height = 0.5 in width = 10 in; ODS pdf text =" CUSTOME~mR METRICS OVERVIEW ~-2n Markets ~-2nOctober 2008"; ODS region x=0 in y=1 in height = 2 in width = 2.75 in; goptions htext=18pt ctext=black; goptions cback=white; axis1 label=none minor=(n=3)order=(0 to 1000 by 200); axis2 label=none order=(0 to 100 by 20) minor=(n=1); pattern1 v=solid color=cx17588A; *pattern1 v=solid color=cx006699; symbol1 v=dot i=join c=blue h=1; title1 "metric1 (000's) / PENETRATION (%)"; proc gbarline data=data1; bar country / axis=axis1 sumvar=metric1 midpoints="CAN" "AUS" "NZL" "UK" "MEX" "JPN" "ITA" discrete width=7.5 ; plot / sumvar=pene axis=axis2; run; quit; ODS region x=2.5 in y=1 in height = 2 in width = 2.75 in; title1 "metric1 (000's) / PENETRATION (%)"; proc gbarline data=data1; bar country / axis=axis1 sumvar=metric1 midpoints="CAN" "AUS" "NZL" "UK" "MEX" "JPN" "ITA" discrete width=7.5 ; plot / sumvar=pene axis=axis2; run; quit; ODS region x=5 in y=1 in height = 2 in width = 2.75 in; title1 "metric1 (000's) / PENETRATION (%)"; proc gbarline data=data1; bar country / axis=axis1 sumvar=metric1 midpoints="CAN" "AUS" "NZL" "UK" "MEX" "JPN" "ITA" discrete width=7.5 ; plot / sumvar=pene axis=axis2; run; quit; ODS region x=7.5 in y=1 in height = 2 in width = 2.75 in; title1 "metric1 (000's) / PENETRATION (%)"; proc gbarline data=data1; bar country / axis=axis1 sumvar=metric1 midpoints="CAN" "AUS" "NZL" "UK" "MEX" "JPN" "ITA" discrete width=7.5 ; plot / sumvar=pene axis=axis2; run; quit; ODS region x=0 in y=3.5in height = 2 in width = 2.75 in; title1 "metric1 (000's) / PENETRATION (%)"; proc gbarline data=data1; bar country / axis=axis1 sumvar=metric1 midpoints="CAN" "AUS" "NZL" "UK" "MEX" "JPN" "ITA" discrete width=7.5 ; plot / sumvar=pene axis=axis2; run; quit; ODS region x=2.5 in y=3.5 in height = 2 in width = 2.75 in; title1 " metric1 (000's) / PENETRATION (%)"; proc gbarline data=data1; bar country / axis=axis1 sumvar=metric1 midpoints="CAN" "AUS" "NZL" "UK" "MEX" "JPN" "ITA" discrete width=7.5 ; plot / sumvar=pene axis=axis2; run; quit; ODS region x=5 in y=3.5 in height = 2 in width = 2.75 in; title1 " metric1 (000's) / PENETRATION (%)"; proc gbarline data=data1; bar country / axis=axis1 sumvar=metric1 midpoints="CAN" "AUS" "NZL" "UK" "MEX" "JPN" "ITA" discrete width=7.5 ; plot / sumvar=pene axis=axis2; run; quit; ODS region x=7.5 in y=3.5 in height = 2 in width = 2.75 in; title1 " metric1 (000's) / PENETRATION (%)"; proc gbarline data=data1; bar country / axis=axis1 sumvar=metric1 midpoints="CAN" "AUS" "NZL" "UK" "MEX" "JPN" "ITA" discrete width=7.5 ; plot / sumvar=pene axis=axis2; run; quit; ODS region x=0 in y=6 in height = 2 in width = 2.75 in; title1 " metric1 (000's) / PENETRATION (%)"; proc gbarline data=data1; bar country / axis=axis1 sumvar=metric1 midpoints="CAN" "AUS" "NZL" "UK" "MEX" "JPN" "ITA" discrete width=7.5 ; plot / sumvar=pene axis=axis2; run; quit; ODS region x=2.5 in y=6 in height = 2 in width = 2.75 in; title1 " metric1 (000's) / PENETRATION (%)"; proc gbarline data=data1; bar country / axis=axis1 sumvar=metric1 midpoints="CAN" "AUS" "NZL" "UK" "MEX" "JPN" "ITA" discrete width=7.5 ; plot / sumvar=pene axis=axis2; run; quit; ODS region x=5 in y=6 in height = 2 in width = 2.75 in; title1 " metric1 (000's) / PENETRATION (%)"; proc gbarline data=data1; bar country / axis=axis1 sumvar=metric1 midpoints="CAN" "AUS" "NZL" "UK" "MEX" "JPN" "ITA" discrete width=7.5 ; plot / sumvar=pene axis=axis2; run; quit; ODS region x=7.5 in y=6 in height = 2 in width = 2.75 in; title1 " metric1 (000's) / PENETRATION (%)"; proc gbarline data=data1; bar country / axis=axis1 sumvar=metric1 midpoints="CAN" "AUS" "NZL" "UK" "MEX" "JPN" "ITA" discrete width=7.5 ; plot / sumvar=pene axis=axis2; run; quit; ods layout end; ods pdf StartPage=now; ods pdf close; ods listing; ... View more

Hi, I want to find what the default margin settings are for ODS pdf. In general, how do I see the default values for all the options in ODS pdf. Thanks, Amit ... View more

Hi, I want no page number for first page. From second page onwards I want "page 1 of last page" . Total number of pages does not include first page. Thanks in advance for help, Amit ... View more

Hi, I want my title page to have portrait orientation, but I want landscape orientation for the next page. Thanks for the help in advance, Amit ... View more

Hi everyone, Can anyone guide me in importing actuate report which can be viewed with Actuate Viewer 6 service pack 1 patch 1. Also I have an html file which I wan to import in SAS. Apreciate all your help. Thanks, Amit ... View more

Hi, I dont know where to post this query. I am looking for SAS Data mining conference. Thanks for your help. Amit ... View more

Hi, Thanks for the help. I am trying to create a vertical stacked column chart using gghart. the subgroup variable 'type' has 2 values A and B. I want B to be on top of stack and A on bottom. Basically I want to control order of stacking. Data; input year type amount; 2005 A 1000 2005 B 35 2006 A 345 2006 B 500 Thanks, Amit ... View more

Hi everyone, Thanks for your help in advance. I want a vbar using proc gchart (if possible) for the following data: Type is main group, school is sub group and section are sub-sub group. I want the data for section stacked. type school section count A sh1 A 10 A sh1 B 15 A sh2 A 23 A sh2 B 17 B sh1 A 9 B sh1 B 22 B sh2 A 16 B sh2 B 7 Thanks, Amit ... View more

Hi, I am trying to get the level counts for the variable market in code listed below. But SAS gives me error. My sas version is SAS 9.1 TS Level1M3. Thanks in advance, Amit code: rsubmit; libname try ' library location ' ; proc freq data=try.temp nlevels; tables market; run; endrsubmit; error: ERROR 22-322: Syntax error, expecting one of the following: ;, (, COMPRESS, DATA, FC, FORMCHAR, NOPRINT, ORDER, PAGE. ERROR 200-322: The symbol is not recognized and will be ignored. ... View more