11-27-2019
Vish33
Lapis Lazuli | Level 10
Member since
01-04-2012
- 148 Posts
- 31 Likes Given
- 7 Solutions
- 31 Likes Received
-
Latest posts by Vish33
Subject Views Posted 1181 11-27-2019 09:04 AM 1186 11-27-2019 08:57 AM 2330 11-14-2019 09:46 AM 1542 08-30-2019 10:08 AM 900 07-01-2019 10:27 AM 910 05-08-2019 10:06 AM 1345 05-14-2018 08:58 AM 1371 05-14-2018 05:23 AM 3598 05-09-2018 09:37 AM 1075 05-09-2018 07:55 AM -
Activity Feed for Vish33
- Got a Like for Re: Merging two datasets with alternating variables. 11-27-2019 12:37 PM
- Posted Re: Merging two datasets with alternating variables on SAS Programming. 11-27-2019 09:04 AM
- Posted Re: Merging two datasets with alternating variables on SAS Programming. 11-27-2019 08:57 AM
- Posted Re: appending .csv files onto a dataset daily on New SAS User. 11-14-2019 09:46 AM
- Liked Re: export dataset rows into multiples files .txt for Ksharp. 09-03-2019 09:05 AM
- Liked Re: Make macro variable for values of a variable for Tom. 09-03-2019 08:55 AM
- Posted Re: Make macro variable for values of a variable on SAS Programming. 08-30-2019 10:08 AM
- Posted Re: How to combine two proc sql table and then export them as ods html? on SAS Programming. 07-01-2019 10:27 AM
- Posted Re: proc report summarize on ODS and Base Reporting. 05-08-2019 10:06 AM
- Posted Re: Dynamic Parameters on SAS Enterprise Guide. 05-14-2018 08:58 AM
- Posted Re: Dynamic Parameters on SAS Enterprise Guide. 05-14-2018 05:23 AM
- Liked Re: SAS Output help for novinosrin. 05-10-2018 03:13 AM
- Liked Re: SAS Output help for ChrisNZ. 05-10-2018 03:13 AM
- Liked Re: How to add quarters in SAS? for sasstats. 05-09-2018 09:55 AM
- Posted Re: How to add quarters in SAS? on SAS Programming. 05-09-2018 09:37 AM
- Posted Re: Proc Means and output statement on SAS Enterprise Guide. 05-09-2018 07:55 AM
- Liked Re: Proc Means and output statement for RW9. 05-09-2018 06:22 AM
- Posted Re: Proc Means and output statement on SAS Enterprise Guide. 05-09-2018 06:17 AM
- Posted Re: An unexplained warning with a macro variable. on SAS Programming. 05-09-2018 05:41 AM
- Posted Re: Concatenate datasets as it get created on SAS Programming. 05-08-2018 05:48 AM
-
Posts I Liked
Subject Likes Author Latest Post 1 1 1 1 1 -
My Liked Posts
Subject Likes Posted 1 11-27-2019 08:57 AM 1 05-07-2018 09:05 AM 1 05-04-2018 06:53 AM 1 05-04-2018 06:28 AM 1 05-03-2018 06:25 AM
05-02-2018
08:43 AM
Hi,
I would suggest to create a new data set when there is a data manipulation. I always prefer to retain the original data and keep sub sets of data into new temp tables.
Thanks,
Vishnu
... View more
05-11-2017
10:44 AM
Thank you for your inputs. I will look into the Logistic documentation.
... View more
05-11-2017
08:53 AM
Hello all,
I want to create a basic model which would identify/predict customers those are eligible to get the loan so that these customers would be targeted by the customer care people.
Please find the attachments for sample documents. I am new to modelling , so i would like to know how this can be done in SAS.
And i want to automate this finally to run on weekly/monthly basis.
Thank you.
Vish
... View more
02-10-2017
08:03 AM
Try ODS region to place multiple garphs/reports with in a single report. I never tried in Power point but this works with other formats.
... View more
02-10-2017
07:29 AM
By using ODS you can create and send reports in any of the formats like Excel, pdf,rtf, csv, powerpoint etc..
Check the below link for how you can send a graph to powerpoint.
http://blogs.sas.com/content/sastraining/2013/07/12/send-your-sas-graphs-directly-to-powerpoint/
... View more
02-09-2017
09:00 AM
1 Like
sum(of diag1-diag9) >=1 OR max(of diag1-diag9) >=1 should work.
... View more
02-09-2017
08:14 AM
I am little surprised how this date value is 'END' ..is it character variable in the dataset?
... View more
02-08-2017
09:48 AM
Try this.
data have;
infile cards dlm=" ";
input ID $3. Neighbor $3. Distance @;
cards;
X1 X45 0.1
X1 X44 0.2
X1 X20 0.2
X5 X32 0.3
X5 X59 0.4
X5 X20 0.4
X5 X12 0.4
X3 X56 0.1
X3 X43 0.2
X3 X32 0.2
X2 X5 0.2
X2 X21 0.3
X2 X13 0.3
X7 X4 0.2
X7 X13 0.3
X7 X21 0.3
X7 X32 0.4
;
run;
proc transpose data=have(drop=distance) out=want(drop= _NAME_ neighbor4) prefix=neighbor ;
var neighbor;
by id notsorted;
run;
... View more
01-20-2017
04:53 AM
Can you please elaborate your requirement?
... View more
01-17-2017
05:18 AM
can you paste the picture in message itself, I am unable to download it.
... View more
01-13-2017
08:08 AM
Try this way ..
%Macro test(libname=,prefix=,newvar=);
/**listing the data from a particular library where the actual data resides and by giving proper condition**/
proc sql;
create table listData as
select memname
from dictionary.tables
where libname="&libname" and memname like "&prefix%" ;/*here prefix or suffix how you are identifying data set*/
quit;
/**Count of total no.of data sets **/
proc sql;
select count(*) into :cnt from listData;
quit;
/**create macro variables for each data set..lets say in your case it is 36**/
/**like memname1=12012 memname2=22012......memname36=122014**/
proc sql;
%do i=1 to &cnt.;
select memname into :memname&i.-memname&cnt. from listData;
%end;
quit;
/** calling one by one using do loop and create the required new varibles**/
%macro all;
%do i=1 to &cnt.;
%let memname=%sysfunc(compress(&&memname&i.)
data new_&memname.;
set &memname.;
/*sort */
&newvar=;/*apply logic here if this is common for all*/
run;
%end;
%mend;
%all;
%mend;
/*invoke the macro by giving your library name and prefix or suffix*/
%test(libname=,prefix=,newvar=);
... View more
01-13-2017
06:58 AM
3 Likes
Are you sure on the existing data set names like 12012, 21012 ..and so on.
Data set name should start with either '_' or a 'character' . Clarify on the existing source data.
... View more
01-13-2017
04:09 AM
Yes..I hope this is the right way to do this ..instead of loading every thing at one point daily i could have used Delta and append . Earlier we did the same thing in DI delta load which is very dynamic> First time i am working on this migration to SSIS which i have no idea.
But i need to check with the team about this approach.
Thanks @Kurt_Bremser and @Patrick for your valuble suggestions.
--Vish
... View more