comp.soft-sys.sas - The SAS statistics package.
data dumptest; VIEW_ID=934; Commodity_class_id = 870000001; Geo_src_class_id = 70; Geo_dest_class_id = 1001; Bus_src_class_id = 72; Bus_dest_class_id = 72; Dp_key = '10101010'; Commodity_code = '1101'; Geo_src_code = '1'; Geo_dest_code = '0'; Bus_src_code = '99'; Bus_dest_code = '99'; Macro_pool = 113; Macro_model = 990; run; One record in the file. Need a Proc Report to produce a listing as follows. Well, a little more lined up than shown. Just a dump really. VIEW_ID: 934 Commodity_class_id: 870000001 Geo_src_class_id: 70 Geo_dest_class_id: 1001 Bus_src_class_id: 72 Bus_dest_class_id: 72 Dp_key: 10101010 Commodity_code: 1101 Geo_src_code: 1 Geo_dest_code: 0 Bus_src_code: 99 Bus_dest_code: 99 Macro_pool: 113; Macro_model: 990; I don't think it is possible, but if it is please advise. I need it as a Proc Report or Proc Print because it goes at the bottom of a group of activex graphs produced using ODS. Guess I should try a Data _null_; put .... first though. ? Or I probably have to do some heavy annotate lifting. :-( Thanks!
From one fish bowl to another.. An interesting problem on my part, but likely a simple answer. Background: I have variables from an input data set for which I assign a format and label. Ex. LABEL q1=If you plan on taking to trip to Europe, when do you intend to do so? q2=If you plan on taking to trip to Asia, when do you intend to do so? FORMAT (For both q1 and q2) 1 = One year from now 2 = Two years from now 3 = Three years from now 4 = Four years from now 5 = 5 years from now 6 = more than 5 years from now So when I run PROC FREQ DATA=blah TABLES q1 -- q2; RUN; I get a standard frequency table with a label to describe the variable AND the formats attached to their relative frequency (Ie. "If you plan on taking..." One year from now 1 ... More than 5 years 5 ) These tables are merely one-way frequency tables. PROBLEM: I've now been asked to take all of these variables and consolidate them into a table that would look like the following: Column 1 Column 2 .. Column 8 (Locale) One year from now ... More than 5 years Europe Asia Australia The requestor is basically asking that I flip the table and merge the results Is there a simple or straight-forward method of doing this? (Or am I going to be running multiple out options in Proc Freq followed by multiple Proc Transpose with a final data set to merge the results?) Signed a data step cruncher now lost in the wilds of SAS report writing.. Chris Amherst
A letter with a graphic image prints with a transparent background in MS Word but not when rendered as a pdf under SAS ODS Proc Report. The problem may occur in the method of display in the Adobe Acrobat reader or in the method specified by SAS. Has anyone encountered this problem and found a solution. Thanks in advance for any help that you might offer. Sig