/*example1*/
data ex1;
set sashelp.class ;
run;
Note: (exmaple1) In above step backend PDV concept will be executed.
/*example2*/
data _null_;
set sashelp.class;
put _all_;
run;
my question is like in above step (example2) is backend PDV concept will be applied . i think not applied . Could you please guide me?
... View more
data rawdata ; input var1 total ; /*calculating percentages*/ percentage=put(var1,5.)||'('||put((var1*100)/total,5.1)||')'; cards ; 23 169 33 169 23.5 169 2 30 12 43 12.342 run;
I am calculating percentages and need to set correct alignement like while generating report part output alignment should be like:
Percentages 23 ( 50.2 %)
2 ( 3 %)
324 ( 99.23 %)
... View more
data rawdata ;
input id $ test $ result ;
cards;
101 bp 120
101 wbc 230
101 rbc 234
102 bp 120
102 wbc 230
102 rbc 234
run;
Note: we need to transpose the data in proc report only
ods rtf file="path" ;
proc report data=rawdata ;
column id test result ;
define test/across ;
define id/order ;
run;
ods rtf close ;
output should be like:
Analysis Variables
---------------------------------- id bp wbc rbc
101 120 230 234
102 120 230 234
my question is how to apply extra label for all test varibles "Analysis Variables" while transposing Note: We should do in proc report only (don't use proc tranpose)
... View more
ods rtf file='path' ;
proc report data=raw ;
columns cat col1 col2 col3;
run;
proc report data=raw ;
columns cat col4 col5 col6;
run;
ods rtf close; for above program I am getting page numbers like first page: 1 of 3 second page: 1 of 3
third page : 2 of 3 my question is how to continue page number for second page onwards
... View more
libname test1 'path1' ;
libname test2 'path2' ;
I have written code like above. By using that above code we can create 2 libraries test1 and test2 .
But question is:
how to create 2 libraries by using single libname statement?
I have tried below but it's not working.
libname test1 'path1' test2 'path2' ;
... View more
I have 10 variables like col1,col2,col3......col10;
I have print 5 variables in first page and next 5 variables in second rtf page by using proc report
I wrote code like...
ods rtf file='path' ;
proc report data=have ;
columns col1 col2..... col10;
define col1/id ;
run;
ods rtf close;
For your ref:
first page:
col1 col2 col3 col4 col5
--------
----------
second page:
col1 col6 col7 col8 col9 col10
--------
--------
... View more
I have one raw dataset :
raw data:
conti $ country $ state $ pop_count $ asia ind mh 300 asia ind ka 200 asia ind tn 200
how to get output report structure like below(in proc report only):
required output:
countrywise population conti:asia date:todaY_date ------------------------------------------------------------------- country state pop_count -------------------------------------------------------------------- ind mh 300
ka 200
tn 200
how to write code in proc report only:
... View more
id type score
101 testA 89
101 testB 89
102 testA 89
102 testB 89
I have one dataset like above how to transpose the data in proc sql ?
Output should be like see below example:
id testA testB
101 89 89
101 89 89
We should do in proc sql only.
... View more
I have clauses see below
select,from ,join,where ,group by, having,order by
My question is which clause is will execute first and explain their functionalities.
Please explain this scenario
... View more
