About sassharp

sassharp · ‎01-03-2013

At the bottom of that page is macro %dirlistwin this macro is for windows. Do need macro to work on UNIX directory/file.

sassharp · ‎01-03-2013

Anybody have a designed macro like this ? http://support.sas.com/kb/24/820.html this one is in windows. But do need on UNIX

sassharp · ‎12-21-2012

Still looking for effecient answers.

sassharp · ‎12-21-2012

Need to measure space occupied by SAS data sets in a given directory(x) and need to generate report every day in excel or email?? Obstacle: dont have permission to read every sub directory under given directory (x)? But have sudo privileges in command prompt to a given directory (x). Q) Can we done this task using SAS management console? or Using scripting only? Any literature appreciated. I saw some paper or tip to do this in SAS.com Now not able to find that paper or tip. Share if you have that paper. Thanks.

sassharp · ‎12-19-2012

Chris@SAS(R) Chris, I saw some paper/ Article written by you to know space occupied by each data set in directory and space usage by each user. Would you please post links here. I saw in sas.com thanks.

sassharp · ‎12-11-2012

did you ASSIGN the library from metadata side? When you right click on the library in EG you see assign. Choose assign.

sassharp · ‎12-11-2012

libname should be 8 characters long only

sassharp · ‎10-18-2012

https://communities.sas.com/thread/33633 I am sure this would help. Proc compare compares each column from table 1 to table 2 in a row. For example if there is a rundate in table1 and rundate in table2 need not be same even you started to run the code same time to get table1 and table2. For comparing two tables I am sure this is going to be usefulcode. /* first outer join table1 and table2*/ Proc SQL; Create table table1andtable2outerjoin as Select a.id as id_1, a.name as name_1, b.id as id_2, b.name as name_2 From table1 as a Full Outer Join table2 as b on a.id = b.id and a.name=b.name; Quit; /*to see rows only in table2 not in table1 you can add more columns for comparison*/ Data tablenew; Source = 'two'; Length Source $5; Set table1andtable2outerjoin ; if missing(id_1) and missing(name_1) then output; Format Source $5.; Informat Source $5.; run; /*to see rows only in table1not in table2 you can add more columns for comparison*/ Data tableold; Source = 'one'; Length Source $5; Set table1andtable2outerjoin; if missing(id_2) and missing(name_2) then output; Format Source $5.; Informat Source $5.; run; /*to see rows side by side*/ Data tablenewold; Set tablenew tableold; run;

sassharp · ‎09-19-2012

pos = index(intext, '2E0D'X) ; what is '2E0D'X? (is error hexadecimal coded?) txt = substr(intext, 8, pos - 😎 ; from this paper. http://analytics.ncsu.edu/sesug/2008/CC-037.pdf

sassharp · ‎08-14-2012

The last but not the least. http://www2.sas.com/proceedings/sugi29/258-29.pdf http://www2.sas.com/proceedings/sugi31/123-31.pdf http://www.nesug.org/Proceedings/nesug09/po/po02.pdf

sassharp · ‎08-14-2012

· Thanks for your explanation. I assumed this way. Number of days between 01/01/1960 to 08/14/2012( todays date) = 19219 %sysfunc(mod(%sysfunc(today()),7))= mathematically mod(19219,7)= 4 so the statement (%sysfunc(mod(%sysfunc(today()),7))= mathematically mod(19219,7)= 3) is not true . So, the macro is not saying hai today. But, first monday in August 2012 is on 08/06/2012 Number of days between 01/01/1960 to 08/06/2012 = 19211 %sysfunc(mod(%sysfunc(today()),7))= mathematically mod(19211,7)= 3 so this above one is true but the other logical statement %if %sysfunc(day(%sysfunc(today())))<=7 which is also true.(since day(today()) on 08/06/2012 is 6 which is less than 7) so the macro said hai on 08/06/2012 and is going to say hai on first monday of every month. I say thankful for all your(@Arthur) explanation. Correct me If I was wrong. thanks.

sassharp · ‎08-14-2012

proc sql; create table data.test as select * from connection to odbc ( select ID, DATE AS CREATION_DATE format=date20., from maintable ); quit;

sassharp · ‎08-13-2012

Is it right? options symbolgen; data test; format month date9.; format firstmonday date9.; format today date9.; month = intnx('month',today(),0); firstmonday = intnx('week',month,1)+1; today=today(); if firstmonday eq today then do; call symput('MyMacroVariable','RunIt'); end; else do; call symput('MyMacroVariable','NoRunIt'); end; run; %macro check2run; %if &MyMacroVariable eq RunIt %then %do; %put hai; %end; %else %do ; %put no hai; %end; %mend; %check2run;

sassharp · ‎08-13-2012

trying to get run the below macro only on first monday in any given month. Can anybody fix this macro? options symbolgen; data test; format month date9.; format firstmonday date9.; month = intnx('month',today(),0); firstmonday = intnx('week',month,1)+1; if firstmonday= today() then do; call symput('MyMacroVariable','RunIt'); end; run; /*the below macro only run on first of the monday in any given month*/ %macro check2run; %if &MyMacroVariable eq RunIt %then %do; %put hai; %end; %mend; %check2run;

sassharp · ‎07-07-2012

How or where to get the data sets for "predictive modelling using Logistic regeression" https://support.sas.com/pubscat/bookdetails.jsp?catid=1&pc=E2171 thanks.

Online Status	Offline
Date Last Visited	‎04-05-2016 03:59 PM

Re: copy column values to next row?

Re: copy column values to next row?

copy column values to next row?

Re: Inserting Date Column - SAS enterprise Guide

Re: Check files in landing Automation

Check files in landing Automation

Re: &&

email with attachment !!

Re: Simple date reformatting help

Re: duplicates check in a given library.

Re: macro to get first monday??????

Re: macro to get first monday??????

Re: macro to get first monday??????

Re: PROC PHOTO?

Re: PROC PHOTO?

Re: macro to get first monday??????

Re: Equivalent in UNIX????????

Equivalent in UNIX????????

Re: measuring space occupied by sas data sets in a given directory???

measuring space occupied by sas data sets in a given directory???

data set space measuring using EG

Re: SAS BASE CONENCTION TO METADATA SERVER

Re: SAS BASE CONENCTION TO METADATA SERVER

Re: PROC COMPARE

code clarification?

Re: How do you layout your PROC SQL code?

Re: macro to get first monday??????

Re: SQL Date Formatting

Re: macro to get first monday??????

macro to get first monday??????

need data sets???