cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Daily1
‎08-11-2025
  • 106 Posts
  • 12 Likes Given
  • 0 Solutions
  • 3 Likes Received

proc report line statement

by Quartz | Level 8 in SAS Enterprise Guide
‎07-18-2023 01:21 AM
1 Like
‎07-18-2023 01:21 AM
1 Like
data have; set sashelp.cars; where type = 'Sedan' and drivetrain = 'All' and msrp < 35000; sr=_N_; keep sr origin make model msrp; run; proc report data=have out=rect; columns sr origin make model msrp; define sr / order noprint; compute after sr; length linetext $200.; if sr=6 or sr=8 then linetext = ' '; line linetext $200.; endcomp; run; i want blank line after sr=6 and sr=8   ... View more

Re: proc report slash (/) missing on proc report result

by Quartz | Level 8 in SAS Enterprise Guide
‎07-17-2023 01:38 PM
2 Likes
‎07-17-2023 01:38 PM
2 Likes
Solution: data three; infile datalines; input a $ b $ x $ y $ z $ m $; datalines; A/A 21 22 23 24 25 AB 26 27 28 29 30 ; run; proc report data=three nowd; column a b x y z m; run;   ... View more

Re: proc report slash (/) missing on proc report result

by Quartz | Level 8 in SAS Enterprise Guide
‎07-17-2023 01:31 PM
‎07-17-2023 01:31 PM
https://communities.sas.com/t5/SAS-Enterprise-Guide/proc-report-slash-missing-on-proc-report-result/td-p/885016 ... View more

proc report slash (/) missing on proc report result

by Quartz | Level 8 in SAS Enterprise Guide
‎07-17-2023 07:27 AM
‎07-17-2023 07:27 AM
data three; infile datalines; input a $ b $ x $ y $ z $ m $; return; datalines; A/A 21 22 23 24 25 AB 26 27 28 29 30 ; run; proc report data=three; run; "/" is missing on my result. pls help. Thanks    i want this type output but i need A/A on result. why / is missing on result?     ... View more

Transpose

by Quartz | Level 8 in SAS Programming
‎07-07-2023 01:46 AM
‎07-07-2023 01:46 AM
hi i have SR ID S S_G TS TS_G 1 19 1 5 7 2 2 20 5 8 6 1 3 21 5 7 2 1 i want SR ID nw1 nw2 1 19 1 7 5 2 2 20 5 6 8 1 3 21 5 7 7 2 ... View more

Bar Chart

by Quartz | Level 8 in SAS Enterprise Guide
‎05-25-2023 03:20 AM
‎05-25-2023 03:20 AM
I write title on my code but reflect not white form . pls correct my code  data my_data; format amount percentn7.0; input barname $ 1-3 amount; datalines; 1a. 1.00 1b. 0.30 1c. 0.75 1d. 0.55 1e. 0.55 1f. 0.75 ; run; ods html file="aa.html"; title '1- Marine Protected Areas'; proc sgplot data=my_data noautolegend noborder pad=(left=12pct right=12pct); styleattrs datacolors=(cx1d94da cxe6eef7 cxc7e3ff cx89cbf2 cx03c9b9 cx1d94da); styleattrs backcolor=cx033567 wallcolor=cx033567; vbarparm category=barname response=amount / group=barname groupdisplay=cluster nooutline datalabel datalabelattrs=(color=white size=13pt weight=bold); yaxis display=(nolabel noticks noline) valueattrs=(color=white) values=(.2 to 1 by .2); xaxis display=(nolabel noticks) valueattrs=(color=white size=13pt weight=bold); run; code output    i want    ... View more

Ods makup to rtf report

by Quartz | Level 8 in SAS Enterprise Guide
‎04-19-2023 02:06 AM
‎04-19-2023 02:06 AM
proc template; define tagset tagsets.test; parent=tagsets.phtml; define event doc; start: put HTMLDOCTYPE NL NL NL; put '<html xmlns:o="urn:schemas-microsoft-com:office:office"' NL; put 'xmlns:x="urn:schemas-microsoft-com:office:excel"' NL; put 'xmlns="http://www.w3.org/TR/REC-html40">' NL; finish: put "</html>" NL; end; define event doc_head; start: put "<head>" NL; put VALUE NL; put "<style>" NL "<!--" NL; trigger alignstyle; put "-->" NL "</style>" NL; finish: put " <!--[if gte mso 9]><xml>" NL; put " <x:ExcelWorkbook>" NL; put " <x:ExcelWorksheets>" NL; put " <x:ExcelWorksheet>" NL; put " <x:Name>Sheet1</x:Name>" NL; put " <x:WorksheetOptions>" NL; put " <x:Zoom>100</x:Zoom>" NL; put " <x:Selected/>" NL; put " <x:Panes>" NL; put " <x:Pane>" NL; put " <x:Number>3</x:Number>" NL; put " <x:ActiveCol>1</x:ActiveCol>" NL; put " </x:Pane>" NL; put " </x:Panes>" NL; put " <x:ProtectContents>False</x:ProtectContents>" NL; put " <x:ProtectObjects>False</x:ProtectObjects>" NL; put " <x:ProtectScenarios>False</x:ProtectScenarios>" NL; put " </x:WorksheetOptions>" NL; put " </x:ExcelWorksheet> " NL; put " <x:WindowHeight>8070</x:WindowHeight> " NL; put " <x:WindowWidth>10380</x:WindowWidth> " NL; put " <x:WindowTopX>480</x:WindowTopX> " NL; put " <x:WindowTopY>120</x:WindowTopY> " NL; put " <x:ProtectStructure>False</x:ProtectStructure> " NL; put " <x:ProtectWindows>False</x:ProtectWindows>" NL; put " </x:ExcelWorkbook>" NL; put " </xml><![endif]--> " NL; put "</head>" NL; end; end; run; proc template; define style styles.mystyle; parent = Styles.Default; style body / background = white foreground = black ; style systemtitle / font_face = 'Times New Roman' font_weight = bold font_size = 12pt ; style systemfooter / font_face = 'Times New Roman' font_size = 8pt ; style data / fontfamily = 'Times New Roman' font_size = 10pt foreground = black ; style header / fontfamily = 'Times New Roman' font_size = 10pt foreground = Black /* font_weight = bold */ /* background = #A9D0F5 */ background = white ; style summary / fontfamily = 'Times New Roman' font_size = 10pt foreground = Black font_weight = bold /* background = #A9D0F5 */ background = white ; style table / cellpadding = 5px cellspacing = 0px borderwidth = 1px bordercolor = black borderstyle = solid ; end; run; ods markup file="sas.rtf" tagset=tagsets.test alias='normal' style=mystyle; title1 "Data Set"; proc report data=sashelp.cars(obs=5); col Make Model Type Origin DriveTrain; run; title1; title2 "Data Set1"; proc report data=sashelp.class (obs=5); run; title2; ods rtf close;       I want to two report seperate page start     ... View more

Re: ods markup to rtf

by Quartz | Level 8 in ODS and Base Reporting
‎04-17-2023 06:07 AM
‎04-17-2023 06:07 AM
ods markup for multi purpose..just like Excel Output ... View more

ods markup to rtf

by Quartz | Level 8 in ODS and Base Reporting
‎04-17-2023 05:54 AM
‎04-17-2023 05:54 AM
I have multiple proc reports with header ...i need to output on every report next page  ods markup file="/sasreports/sas.rtf" tagset=tagsets.test style=mystyle charset='utf-8';       ... View more

Re: update table from another table in sas

by Quartz | Level 8 in SAS Enterprise Guide
‎02-01-2023 02:24 PM
‎02-01-2023 02:24 PM
proc sql; update sample1 set exp= (select n.exp from sample2 n ) where n.id=sample1.id and n.code =sample1.code; quit; Please correct query ... View more

Re: update table from another table in sas

by Quartz | Level 8 in SAS Enterprise Guide
‎02-01-2023 02:16 PM
‎02-01-2023 02:16 PM
proc sql; update sample1 set exp= (select n.exp from sample2 as n ) where n.id=sample1.id and n.code =sample1.code; quit; log proc sql; 29 update sample1 set exp= (select n.exp from sample2 as n ) 30 where n.id=sample1.id and n.code =sample1.code; ERROR: Unresolved reference to table/correlation name n. ERROR: Unresolved reference to table/correlation name n. ERROR: Expression using equals (=) has components that are of different data types. ERROR: Expression using equals (=) has components that are of different data types. 31 quit; ... View more

Re: update table from another table in sas

by Quartz | Level 8 in SAS Enterprise Guide
‎02-01-2023 01:50 PM
‎02-01-2023 01:50 PM
Sql Code  Result this code not working on sas eg ...please help  ... View more

Re: update table from another table in sas

by Quartz | Level 8 in SAS Enterprise Guide
‎02-01-2023 01:42 PM
‎02-01-2023 01:42 PM
proc sql; update sample1 set exp= select n.exp from sample2 as n where n.id=sample1.id and n.code =sample1.code; quit; Please Help ... View more

update table from another table in sas

by Quartz | Level 8 in SAS Enterprise Guide
‎02-01-2023 12:34 PM
‎02-01-2023 12:34 PM
update sample1 from another sample2 in sas match id and code then exp update  example.363823 and 52 matched then put 5. i want this type of query ..Pls help sample data  data sample1; input ID 1-6 code 7-9 exp 10-11; datalines; 363823 52 0 363823 53 0 293556 50 0 293556 51 0 293556 52 0 293556 53 0 ; data sample2; input ID 1-6 code 7-9 exp 10-11; datalines; 363823 52 5 363823 53 8 293556 50 9 ;  I want this type of output   ... View more

Re: proc report

by Quartz | Level 8 in SAS Enterprise Guide
‎09-20-2022 07:33 AM
‎09-20-2022 07:33 AM
i want append two proc report  data three; infile datalines; input a $ b $ x $ y $ z $ m $; return; datalines; AA 21 22 23 24 25 AB 26 27 28 29 30 ; run; data have; set three; group='color1'; group1='color2'; run; proc report data=have ; column group ('red' a) ('blue' b) ('green' x) ('black' y); define group /group noprint; Compute before group; Line @1 group $50.; endcomp; run; proc report data=have ; column group1 ('red' a) ('blue' b) ('green' z) ('black' m); define group1 /group noprint; Compute before group1; Line @1 group1 $50.; endcomp; run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-11-2025 05:19 AM
Group Hubs for Daily1
View All
Likes given to
Likes from
View All
Quick links