About mansour_ib_sas

mansour_ib_sas · ‎11-02-2018

Hello, I want to use the mp connection technique to optimize the processing time. everything works except the libname. when I point the libname to a local windows folder, the process works. when I point to a server folder I get this error message: ERROR: Libref mib non attribué. I use this programm: %macro test(); %let srv_c=server port; %let user_c = **** ; %let pwd_c = **** ; options comamid=tcp remote=srv_c; signon user="&user_c" password="&pwd_c" ; rsubmit ; libname libora oracle PATH="****" SCHEMA="***" USER=*** PASSWORD="***" access=readonly defer=yes ; libname mib "/server/data/users/mib" ; endrsubmit; goptions reset = all device = ACTXIMG; option autosignon=yes ; OPTIONS SASCMD='"C:\Program Files\SASHome\SASFoundation\9.4\sas.exe"'; libname mib 'c:/data'; rsubmit process=task1 wait=no; libname mib "/server/data/users/mib" ; /*This work*/ libname mib 'c:\data'; /*This not work*/ libname mib '/server/data/user/mib'; /*Creation table enc_6po*/ proc sql; connect to oracle (PATH="****" USER= *** PASSWORD="****" ); create table mib.table as select * from connection to oracle ( select distinct * from oralib.table ) ;disconnect from oracle; quit; endrsubmit task1 ; signoff task1; %mend test; %test; can you help me please? Thank you

mansour_ib_sas · ‎10-30-2018

This now, work normaly libname tt 'C:\'; data tt.test; set sashelp.class;run; proc fedsql; create table test1 as select * from tt.test; quit;

mansour_ib_sas · ‎10-30-2018

Thank you, I remake the test: proc fedsql; select sex, avg(height) as avg_height, avg(weight) as avg_weight from sashelp.class group by sex; quit; Log: 1 proc fedsql; NOTE: Writing HTML Body file: sashtml.htm 2 select sex, avg(height) as avg_height, avg(weight) as avg_weight from 3 sashelp.class group by sex; ERROR: Table "SASHELP.CLASS" does not exist or cannot be accessed ERROR: BASE driver, schema name SASHELP was not found for this connection 4 quit; With rsubmit: rsubmit; proc fedsql; select sex, avg(height) as avg_height, avg(weight) as avg_weight from sashelp.class group by sex; quit; endrsubmit; Log: 455 proc fedsql; ERROR: General error ORA-28000: the account is locked ERROR: TKTS initialization failed. 456 select sex, avg(height) as avg_height, avg(weight) as avg_weight from 457 sashelp.class group by sex; 458 quit;

mansour_ib_sas · ‎10-29-2018

Hello, I use for the first time fedsql with rsubmit. I have i my log this error proc fedsql; ERROR: General error ORA-01017: invalid username/password; logon denied ERROR: TKTS initialization failed. I use this request %let srv_c=xxxxxxxx port; %let user_c = xxxxxxx ; %let pwd_c = xxxxxxxx ; options comamid=tcp remote=srv_c; signon user="&user_c" password="&pwd_c" ; rsubmit srv_c ; option obs=max nosyntaxcheck; libname myora oracle PATH="xxxxxx" SCHEMA="xxxxxxxx" USER="xxxxxxxxxxxxxxxxxxxx" PASSWORD="xxxxxxxxxxxxxxxxx" access=readonly defer=yes ; endrsubmit ; libname myora server = srv_c; rsubmit; proc fedsql; create table table as select a.* from myora.table as a ; quit; endrsubmit; can you help me thank you

mansour_ib_sas · ‎10-22-2018

Hello, I have a display problem with this method. When I set at the beginning embedded_titles = 'yes', I have two concerns 1 / at the beginning of the display I have this displayed #byval (sex) 2 / the title of the report below the value of the title byval If I remove embedded_titles = 'yes' in beginning, no title #byval in second report my objectifs are 1/ Insert the title of the report 2/ then, if there are titles that result from the #byval then it appears after the title of the report Thank you for your help proc sort data=sashelp.class out=class; by sex; run; ODS LISTING CLOSE; ods escapechar="~"; ods excel file="H:\newdirectory\test.xls" options(sheet_name='test' sheet_interval='none' suppress_bylines='yes' ); ods text="~{style[color=Black fontstyle=italic font_weight=bold] Report 1}"; proc report data= class ; run; ods text="~{style[color=Black fontstyle=italic font_weight=bold] Report 2}"; ods excel options(embedded_titles='yes' ); proc report data= class ; by sex; title j=l '#byval(sex)'; run; ods _all_ close; ODS LISTING CLOSE;

mansour_ib_sas · ‎10-19-2018

Hello, i have tagsets.msoffice2k to intaller et not tagsets.msoffice2k_x, i want to add the option panelcols = I thought about creating a new templete. Someone has already developed this templete? thank you

mansour_ib_sas · ‎10-19-2018

Thank you

mansour_ib_sas · ‎10-19-2018

I thought about this option. I consider that the subject is closed

mansour_ib_sas · ‎10-19-2018

Error Log: ERROR: The same category variable must be used for summarized plots. data men(rename=(name=name_m age=age_m sex=sex_m Weight=Weight_m height=height_m)); do i=1 to 10; set sashelp.class(where=(sex='M')); i=i; output; end; run; data women(rename=(name=name_f age=age_f sex=sex_f Weight=Weight_f height=height_f)); do i=1 to 10; set sashelp.class(where=(sex='F') ); i=i; output; end; run; data reg; merge men women;by i; col_vide=''; run; ods _all_ close; ods excel file="H:\Report3.xlsx" options(sheet_interval="none"); proc report data =reg; col('Men' name_m age_m sex_m Weight_m height_m) col_vide ('Women' name_f age_f sex_f Weight_f height_f); run; proc sgpanel data= reg; panelby sex_f sex_m/columns=2; title "Yearly Sales by Product"; vbar age_f; title "Yearly Sales by Product"; vbar age_m; run; ods excel close;

mansour_ib_sas · ‎10-19-2018

thank you for your answer, ideally I try to do like this. can we set the columns option at the beginning? ods _all_ close; ods excel file="H:\Report3.xlsx" options(sheet_interval="none"); proc report data =reg; col('Men' name_m age_m sex_m Weight_m height_m) col_vide ('Women' name_f age_f sex_f Weight_f height_f); run; proc sgpanel data= reg; panelby sex_f /columns=1; vbar age_f; panelby sex_m /columns=2 ; vbar age_m; run; ods excel close;

mansour_ib_sas · ‎10-19-2018

Hello, on the same excel page, below the proc report, I want to insert two graphs in two columns. I miss an option like columns = 2 for this two graphs. Could you help me please. data men(rename=(name=name_m age=age_m sex=sex_m Weight=Weight_m height=height_m)); do i=1 to 10; set sashelp.class(where=(sex='M')); i=i; output; end; run; data women(rename=(name=name_f age=age_f sex=sex_f Weight=Weight_f height=height_f)); do i=1 to 10; set sashelp.class(where=(sex='F') ); i=i; output; end; run; data reg; merge men women;by i; col_vide=''; run; ods _all_ close; ods excel file="H:\Report.xlsx" options(sheet_interval="none"); proc report data =reg; col('Men' name_m age_m sex_m Weight_m height_m) col_vide ('Women' name_f age_f sex_f Weight_f height_f); run; goptions device=png ; proc gchart data=reg; vbar age_m ; run; quit; proc gchart data=reg; vbar age_f ; run; quit; ods excel close; ODS LISTING CLOSE;

mansour_ib_sas · ‎09-25-2018

I answer for my data have; input var var1 var2; cards; 1 500 1000 2 0 500 3 100 2000 ; run; proc report data=have nowd out=test; columns var var1 var2 var3 ; define var/display; define var1/analysis sum; define var2/analysis sum; define var3/computed format=percent8.2; COMPUTE BEFORE; total+var2.SUM; ENDCOMP; COMPUTE var3; var3=var1.sum/total; ENDCOMP; RBREAK AFTER /SUMMARIZE ; RUN;

mansour_ib_sas · ‎09-25-2018

Hello, I have another question please. I want to calculate the ratio between var1 and the final sum of var2. I tried to do that, but it does not work. Thank you data have; input var var1 var2; cards; 1 100 1000 2 0 500 3 100 2000 ; run; proc report data=have nowd; columns var var1 var2 var3; define var/display; define var1/analysis sum ; define var2/analysis sum; define var3/computed ; rbreak after/summarize; compute var3; var3=var1/var2.sum; endcomp; run; I want data have; input var var1 var2 VAR3; cards; 1 100 1000 100/3500 2 0 500 0/3500 3 100 2000 100/3500 ; run;

mansour_ib_sas · ‎09-24-2018

Thank You

mansour_ib_sas · ‎09-24-2018

Thank you, I want to calculate this value (200/3500) too; after sum var1 and sum var2 var var1 var2 var3 1 100 1000 10% 2 0 500 0% 3 100 2000 5% TOTAL 200 3500 0.057

Online Status	Offline
Date Last Visited	‎02-29-2020 02:07 PM

first date monday and last day friday

Re: Optimisation request

Optimisation request

Transpose data whith array and conditions

Regular expression, loop, and macro variable

Re: Print whith FCMP

Print whith FCMP

Re: used multi go to in program

Re: used multi go to in program

used multi go to in program

Re: Regular expression, loop, and macro variable

Re: Finding the next value by group processing

Re: [macro] Used Lenght in loop

Re: Grouped macros variables and make arithmitics operations

Re: Grouped macros variables and make arithmitics operations

Re: Overlap in periods

Re: Splitting a macro variable into smaller macro variables.

Re: Using commas between intermediate tables

Re: Creating data in one line with multiple columns using two columns

Programing whith MP connexion

Re: rsubmit fedsql

Re: rsubmit fedsql

rsubmit fedsql

ODS EXCEL-Multireport- title for the first report- title for the secon...

Add panelcols to tagsets.msoffice2k

Re: Ods Excel proc report and 2 proc gchart

Re: Ods Excel proc report and 2 proc gchart

Re: Ods Excel proc report and 2 proc gchart

Re: Ods Excel proc report and 2 proc gchart

Ods Excel proc report and 2 proc gchart

Re: Proc report : rbreak after summarize and calculated ratio

Re: Proc report : rbreak after summarize and calculated ratio

Re: Proc report : rbreak after summarize and calculated ratio

Re: Proc report : rbreak after summarize and calculated ratio