cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Abhi1212
‎01-22-2018
  • 33 Posts
  • 9 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: comparing two excels

by Obsidian | Level 7 in SAS Programming
‎09-27-2017 06:01 AM
‎09-27-2017 06:01 AM
My two excel file has been imported. I am not sure about my next step of code.. ... View more

Re: comparing two excels

by Obsidian | Level 7 in SAS Programming
‎09-27-2017 05:51 AM
‎09-27-2017 05:51 AM
Hello Sir, Could you please provide the complete code for comparing two excels ? ... View more

Re: formating text in a PUT statement

by Obsidian | Level 7 in SAS Programming
‎05-17-2017 06:32 AM
‎05-17-2017 06:32 AM
Thank you. Let me try the same. ... View more

formating text in a PUT statement

by Obsidian | Level 7 in SAS Programming
‎05-17-2017 06:03 AM
‎05-17-2017 06:03 AM
Hello,   I want the below code to be formatted in such a way it has be displayes in tabluar form. And the invalid reason should be in Red colour. Code: Filename Mymail email subject="Test- &curmo." to=("xyz@tyy.com"); attach="/test/Abhi_&curmo..csv"; Run; Data _Null_; File Mymail; put 'PFA.'; Put 'Invalid Reason.'; put "&total_read observations were read."; put "&total_output were accepted."; put "&total_excluded were rejected."; run; My output should look like: Invalid Reason - 'In Red Colour" below the table which shows Records Read: 30 Total records :50 Rejected records: 20 Thanks, Abhi   Please help. ... View more

Re: Playaround with Merge

by Obsidian | Level 7 in SAS Programming
‎03-27-2017 05:12 AM
‎03-27-2017 05:12 AM
Anything is fine.. ... View more

Playaround with Merge

by Obsidian | Level 7 in SAS Programming
‎03-27-2017 03:49 AM
‎03-27-2017 03:49 AM
I have 2 data set Test and Prod. I have to compare both and get the list of common shipment which is available in test and prod but the rate value differs and then I need the list of shipments which is not matching. Please help me with a code. ... View more

Re: Removing Specific Prefix from a column in Excel

by Obsidian | Level 7 in SAS Programming
‎03-22-2017 04:10 AM
‎03-22-2017 04:10 AM
Sorry Kurt i udnerstood what you asked for. I rectified the error. I missed a ; in program that was the issue. I saw the output i got an extra column named count_X with o values. But i need something as in the log.   I need to send the below part in an email with invalid records file attached to it.   NOTE: There were 3508 observations read from the data set WORK.TEST. NOTE: The data set WORK.WANT1 has 3501 observations and 5 variables. NOTE: The data set WORK.WANT2 has 7 observations and 5 variables.   ... View more

Re: Removing Specific Prefix from a column in Excel

by Obsidian | Level 7 in SAS Programming
‎03-22-2017 04:02 AM
‎03-22-2017 04:02 AM
GOPTIONS NOACCESSIBLE; ________ 22 202 ERROR 22-322: Syntax error, expecting one of the following: ;, CANCEL, PGM. ERROR 202-322: The option or parameter is not recognized and will be ignored. ... View more

Re: Removing Specific Prefix from a column in Excel

by Obsidian | Level 7 in SAS Programming
‎03-22-2017 03:52 AM
‎03-22-2017 03:52 AM
ERROR 22-322: Syntax error, expecting one of the following: ;, CANCEL, PGM. ERROR 202-322: The option or parameter is not recognized and will be ignored. I get this error ... View more

Re: Removing Specific Prefix from a column in Excel

by Obsidian | Level 7 in SAS Programming
‎03-22-2017 02:43 AM
‎03-22-2017 02:43 AM
Lakshmi, My input values are given through excel. So first i should import and then i should play around. Also your code is seem to be more lengthy. Just IF statement will solve. Thanks for your response. ... View more

Re: Removing Specific Prefix from a column in Excel

by Obsidian | Level 7 in SAS Programming
‎03-22-2017 02:41 AM
‎03-22-2017 02:41 AM
Thanks for your reply Kurt. Meanwhile, Control totals should also be captured including: Totals records read, total invalid records excluded, total records output. How that can be done? ... View more

Removing Specific Prefix from a column in Excel

by Obsidian | Level 7 in SAS Programming
‎03-21-2017 06:59 AM
‎03-21-2017 06:59 AM
Hello, I have an excel file with 3 columns. Say A,B and C. Now the C column as some values like PPA249394893,PPA3949343904, CPA239483984,DEF948594 etc.. Now i need to remove the value which as prefix PPA from Column C. How to do that in SAS EG ? i have imported the file as below. I need the records which i removed(PPA Prefix records) as well in separae dataset. Please help me to proceed further.   PROC IMPORT OUT =Test datafile= "/Test/test_file.xlsx" DBMS = XLSX REPLACE; GETNAMES = YES; RUN;   Thanks ... View more

Re: Copying output .CSV file to Shared Drive

by Obsidian | Level 7 in SAS Programming
‎11-25-2016 09:44 AM
‎11-25-2016 09:44 AM
I am clear now. Thank you so much ##- Please type your reply above this line. Simple formatting, no attachments. -## ... View more

Re: Copying output .CSV file to Shared Drive

by Obsidian | Level 7 in SAS Programming
‎11-25-2016 02:36 AM
‎11-25-2016 02:36 AM
Hi, could you please help me in explaining me this code, as I am new to SAS I would like to understand what it does. Meanwhile, I tried your code. It doesn't work. Please help. ... View more

Re: Copying output .CSV file to Shared Drive

by Obsidian | Level 7 in SAS Programming
‎11-24-2016 10:53 AM
‎11-24-2016 10:53 AM
Hi, The code is not copying the file from SAS server to the local system(shared drive). Could you please brief me about the code and help me to fix the issue. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-22-2018 04:40 AM
Group Hubs for Abhi1212
View All
Likes given to
View All
Likes from
View All
Quick links