About bhu

bhu · ‎04-19-2019

Thanks for reply. Case I. Yes pass through is faster but I could not get the number of rows inserted. Case II. I have a situation where I ended with pulling these datasets inside the WORK folder.

bhu · ‎04-19-2019

I have a condition where I have to use "where not exists" in proc sql. The problem with this is, it runs extremely fast inside the SQL server, but this is very very slow using SAS. So I need an alternative for it in SAS. proc sql; insert into table1 select * from table2 a where not exists ( select * from table3 b where a.cond1=b.cond1 and a.cond2=b.cond2 ) ; quit;

bhu · ‎04-03-2019

HI Tom, thank you so much for your reply. Both of your methods need a line to be added before %include. Here I will run a series of run.sas, like %include "run1.sas"; %include "runA.sas"; %include "run2.sas"; %include "run45.sas"; So, I need a dynamic variable which can capture the file name which is being called not file name that is calling it. And, yes I am using SAS 9.4 editor in which "dm" is supported. I would like to know the alternative of dm if I need to run it other than Display Manager.

bhu · ‎04-03-2019

I have 2 sas programs: 1. D:\SAS\main.sas %include "run.sas"; 2. D:\SAS\run.sas %let outputfile = %qsubstr(%sysget(SAS_EXECFILEPATH),1, %length(%sysget(SAS_EXECFILEPATH))-4) ; dm 'log; file "&outputfile..log" replace '; dm 'log; clear'; If I run the run.sas separately without using %include, I can create run.log file. But if I call run.sas using main.sas then I get main.log instead. I need to call run.sas from main.sas using %include and need to create run.log.

bhu · ‎02-28-2019

Awesome Reeza. Thank you a lot for such an easy solution. I have changed the accepted solution to your reply.

bhu · ‎02-28-2019

This helped me: proc sql noprint; select name into :var_list separated by " " from sashelp.vcolumn where libname="WORK" and memname="TABLE1"; quit; PROC REPORT data=table1 nowd split='\' nocenter; COLUMN &var_list.; by fieldname1; TITLE1 "Comparison"; RUN;

bhu · ‎02-28-2019

Assuming dataset table1 has field1, how can I use proc contents inside proc report? Or is there any way to display all the columns of the dataset without actually specifying the field names? PROC REPORT data=table1 nowd split='\' nocenter; COLUMN ( proc contents data = table1 varnum short; run; ) by fieldname1; TITLE1 "Comparison"; RUN;

bhu · ‎02-28-2019

Hi Satish, Your solution works fine in a datastep. Thanks. Is there any difference between &variable. and &=variable?

bhu · ‎02-28-2019

%superq works like magic. Thanks.

bhu · ‎02-27-2019

I have a situation where I got field names for sql join condition but with a comma at last. I want to remove the last comma. The field_names1 is calculated generically that it has not quotes. %let field_names1=a.field1=b.field1 and a.field1=b.field2,; %put &field_names1; %let field_names=%substr(&field_names1,1,%length(&field_names1)-1); %put &field_names; it produces error: ERROR: Macro function %SUBSTR has too many arguments.

bhu · ‎02-27-2019

I have a macro: %generate_string(); %let string= apple; %put &string; %mend; I have a data step where I have to concatenate a value with this macro output: data _null_; %let output = This is an || %generate_string() ||.; %put &output; run; I need output as : This is an apple.

bhu · ‎02-14-2019

I found the solution: %let num1 = '1000'; %let num2 = %sysevalf(%sysfunc(compress(&num1.,"'"))-10); %let output = (&num1.,%tslit(&num2.)); %put &num1.; %put &num2.; %put &output.;

bhu · ‎02-14-2019

I have a macro variable which I first need to convert it to a number and do some mathematical calculation, then I have to cover it with a single quote and bracket. %let num1= 1000; %let num2= 1000 - 100; %let output = ('&num1.','&num2.'); I need output like this: ('1000','900')

bhu · ‎02-11-2019

Thank you all for replying and get the solution.

bhu · ‎02-11-2019

This works fine for sas datasets inside the WORK library. Changing the libname to SQL, shows 0 rows for all tables in sashelp.vtable.

Online Status	Offline
Date Last Visited	‎08-26-2019 08:06 PM

Re: Alternative data/proc step for sql not exists

Alternative data/proc step for sql not exists

Re: Use of %include and file path

Use of %include and file path

Re: proc report for all the columns in a dataset

Re: proc report for all the columns in a dataset

proc report for all the columns in a dataset

Re: substr and length in macro variable

Re: substr and length in macro variable

substr and length in macro variable

Re: proc report for all the columns in a dataset

Re: substr and length in macro variable

Re: substr and length in macro variable

Re: substr and length in macro variable

Re: concatenating a string(or characters) with a macro output

Re: Alternative data/proc step for sql not exists

Alternative data/proc step for sql not exists

Re: Use of %include and file path

Use of %include and file path

Re: proc report for all the columns in a dataset

Re: proc report for all the columns in a dataset

proc report for all the columns in a dataset

Re: substr and length in macro variable

Re: substr and length in macro variable

substr and length in macro variable

concatenating a string(or characters) with a macro output

Re: concatenate a macro variable with single quote

concatenate a macro variable with single quote

Re: Row by Row operation in a dataset

Re: Row by Row operation in a dataset