About dkanand86

dkanand86 · ‎07-17-2015

Ok thanks

dkanand86 · ‎07-01-2015

Please can you share the code for this, as i tried this, but didnt work as expected.

dkanand86 · ‎07-01-2015

Sometimes, when i run dictionary.columns on large dataset, the query hangs. Is there any alternative way of doing this? Thanks for this solution.

dkanand86 · ‎06-30-2015

Hi, Please can someone explain with a simple dataset merge and proc sql example the difference between following scenarios: 1. if a 2. if b 3. if a and not b 4. if not a and b Thanks

dkanand86 · ‎06-30-2015

Hi All, I want to subset the proc contents results for a specific variable. How can i do that? Note: Keep in mind that the dataset have 10000 variables, and so i do not want proc contents of all 10000 variables, instead juist require contents info for specific variable. thanks

dkanand86 · ‎01-27-2015

thanks it worked

dkanand86 · ‎01-27-2015

I am running code on SAS 9.3 windows. My ODS listing is off, but earlier it used to route the LST in LST file, but not now. Please can you send the code so that i can ttry again.

dkanand86 · ‎01-27-2015

Hi All, I am trying to create LST output file at my location, but the LST fiel created is empty. I dont know why. Please help. proc printto print="location/p1.lst" new; run; Regards

dkanand86 · ‎01-22-2015

Then, guys, suggest the sas code for exporting the file in csv format, opening the file and saving it as XLSX format.

dkanand86 · ‎01-22-2015

Hi, When i run this above macro code, it gives following error: ERROR: Email: The connection was refused Regards

dkanand86 · ‎01-22-2015

Hi All, I urgently require a generic sas macro code for sending emails through SAS. Please provide code and possible solutions to this problem. Thanks and Regards,

dkanand86 · ‎01-22-2015

Hi all, What is the code for creating xlsx extension excel file through ODS? Whenever i try to use basic ODS command for this purpose, i am unable to create the XLSX file. Please provide code and solution to this problem. Thanks Regards

dkanand86 · ‎11-02-2014

The following code is giving a date format issue: I have created format (named datex) for loan_issue_date variable. But, when i run following code, the code gives error stating "DATEX format not found". Please help.! Code: proc format library=deep fmtlib cntlout=deep.fmts; picture datex (default = 10) low-high = '%d-%b-%y' (datatype = date); run; options fmtsearch=(deep work); data deep.customer_loan_detail; infile cards; input cust_id 4. acct_number $8. customer_loan_type : $8. loan_issue_date datex. loan_amount 5. loan_flag $3.; format loan_issue_date date9.; datalines; 1034 C734459 CAR 05-APR-12 22789 YES 2498 C657568 HOME 05-MAR-12 100387 YES 6523 C673121 HOME 04-SEP-05 87982 YES 8677 C367420 HOME 19-SEP-13 35876 YES 5487 C784509 CAR 02-AUG-11 14990 YES 8496 C741298 PERSONAL 12-JUL-10 5500 YES ; run;

dkanand86 · ‎11-02-2014

The following code is giving a date format issue: I have created format (named datex) for loan_issue_date variable. But, when i run following code, the code gives error stating "DATEX format not found". Please help.! Code: proc format library=deep fmtlib cntlout=deep.fmts; picture datex (default = 10) low-high = '%d-%b-%y' (datatype = date); run; options fmtsearch=(deep work); data deep.customer_loan_detail; infile cards; input cust_id 4. acct_number $8. customer_loan_type : $8. loan_issue_date anydtdte. loan_amount 5. loan_flag $3.; format loan_issue_date date9.; datalines; 1034 C734459 CAR 05-APR-12 22789 YES 2498 C657568 HOME 05-MAR-12 100387 YES 6523 C673121 HOME 04-SEP-05 87982 YES 8677 C367420 HOME 19-SEP-13 35876 YES 5487 C784509 CAR 02-AUG-11 14990 YES 8496 C741298 PERSONAL 12-JUL-10 5500 YES ; run;

dkanand86 · ‎10-27-2014

Just tweaked a bit! its works now. Thanks! proc format; picture datex (default = 10) low-high = '%d-%b-%y' (datatype = date); run; data have2; input (date1 date2) (:anydtdte.); format date1 datex.; format date2 date9.; datalines; 12-JAN-14 12-JAN-2014 ;

Online Status	Offline
Date Last Visited	‎01-06-2019 09:35 AM

Reasons behind break in Rank Ordering?

I/O Processing did not complete error

Re: Code error in SAS Studio

Code error in SAS Studio

Product Category vs Product Category matrix output required

Outliers treatment methods

Missing Value Imputation

Re: New User of SAS Studio 3.5

Want to Include external SAS Statements into the sas code

Implicit vs Explicit SQL Pass through SQL Query in SAS

Re: Subset Proc contents results!

Re: Subset Proc contents results!

Re: LST file created is empty. Why?

Re: Subset Proc contents results!

Re: Subset Proc contents results!

Re: Subset Proc contents results!

What is the difference between if a and if a and not b

Subset Proc contents results!

Re: LST file created is empty. Why?

Re: LST file created is empty. Why?

LST file created is empty. Why?

Re: What is the code for creating xlsx extension excel file through OD...

Re: What is sas macro code for sending emails through SAS?

What is sas macro code for sending emails through SAS?

What is the code for creating xlsx extension excel file through ODS?

Re: Read following date formats

Re: Read following date formats

Re: Read following date formats