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: 
mauri0623
‎03-28-2024
  • 94 Posts
  • 3 Likes Given
  • 2 Solutions
  • 0 Likes Received

string issue

by Quartz | Level 8 in SAS Programming
‎01-03-2020 11:51 AM
‎01-03-2020 11:51 AM
I have a character string that look like the following 5000000 4000000 3000000   I want it to show as 05000000 04000000 03000000   I know I can concatenate a leading zero to fix this, but There are many rows in the dataset that are missing this leading zero. I am looking for some kind of formating. ... View more

Date Calculation

by Quartz | Level 8 in SAS Programming
‎12-16-2019 10:52 AM
‎12-16-2019 10:52 AM
I need to compute invoice date based on the following logic,   Logic: 28th day of the prior month as compared to the "Invoice Date" (i.e. if invoice date = 20191213 then date = 20191128. This is fine until you get to the Jan month and gets tricky. ... View more

get rid of negative sing

by Quartz | Level 8 in SAS Programming
‎11-15-2019 10:29 AM
‎11-15-2019 10:29 AM
How do I get rid of the negative sing. -123490 I have and I want 123490.   amt = -123490;   I want amt1 = 123490 without the negative sign. ... View more

String manipulation

by Quartz | Level 8 in SAS Programming
‎10-15-2019 09:40 AM
‎10-15-2019 09:40 AM
I have the following strings. I want to get rid of the C at the end. This is because another file that has this variable does not contain the C and when it is merged creates problem. I want to get rid of the C at the end. 09120192019 0800000  C 047        X4540001  C 013        X4512000  C 02020192019 0919000  C . . .       ... View more

How to get part of a string

by Quartz | Level 8 in SAS Programming
‎10-10-2019 01:06 PM
‎10-10-2019 01:06 PM
Hello all.,   I have the following strings that I am only interested in getting the 20AL05, 20AL03, 20AL09. AB290363, 20AL05 IA000074 20AL03 PIV#IA000080 20AL09   Please help me with what function and how I will be able to achieve this. ... View more

Re: Updating column of one table with another

by Quartz | Level 8 in SAS Programming
‎10-08-2019 01:42 PM
‎10-08-2019 01:42 PM
That is how the data is. No date. ... View more

Updating column of one table with another

by Quartz | Level 8 in SAS Programming
‎10-08-2019 11:10 AM
‎10-08-2019 11:10 AM
good morning,   Either sql or data step is fine with me.   I am trying to update the obligating_doc_no rom pips_data with obligating_document_no from B7600 table. I get an error indicating that " ERROR: Subquery evaluated to more than one row. NOTE: Correlation values are: IPAC='89000001' ." I used the code below.   proc sql; update pips_data p set obligating_doc_no =   (select obligating_doc_no from tableB b where p.ipac = b.ipac   ) where obligating_doc_no in   (select obligating_doc_no from tableB ); quit;       ... View more

.csv file issue

by Quartz | Level 8 in SAS Programming
‎10-03-2019 11:05 AM
‎10-03-2019 11:05 AM
Good morning,   I have the attached .csv file that when I use proc import the column length are not coming up the way I want them. I need Agency Location Code (ALC) to be of a character of length 10, Order Tracking Number (ODN) to be a character of length 17, Agency TAS to be a character of length 27 and Line of Accounting (LOA) to be a character of length 25. I do not to use the proc import.   Thank you!   -mauri ... View more

filliong out missing data

by Quartz | Level 8 in SAS Programming
‎09-30-2019 09:40 AM
‎09-30-2019 09:40 AM
Please see the attachment. ... View more

Re: leading zeros

by Quartz | Level 8 in SAS Programming
‎09-23-2019 10:56 AM
‎09-23-2019 10:56 AM
I am putting out a .csv file and not an excel file. I found the solution and it work. Basically using options will solve the issue.   ods _all_ close; %let my_csv_file = C:/users/Mauri.Esfandiari/Documents/Missinginfo_to_Validate_&timestamp..csv; ods csvall file = "&my_csv_file." options (prepend_equals="yes" quote_by_type="yes"); proc print data = sas_perm.miss_ipac_odn_acc_0919 noobs; title "Missing IPACs, ODNs, Accounting, and psudo IPACs"; run; ods csvall close; ... View more

Re: leading zeros

by Quartz | Level 8 in SAS Programming
‎09-23-2019 10:41 AM
‎09-23-2019 10:41 AM
Opening the .csv file in notepad ++ still shows the leading zeros missing. ... View more

leading zeros

by Quartz | Level 8 in SAS Programming
‎09-23-2019 10:20 AM
‎09-23-2019 10:20 AM
I create a .csv file from a SAS dataset. When I do this I loose the leading zeros on columns IPAC where the IPAC starts with 0000 and then the number.   Example, 00003801 will becomes 3801 and I loose the first 4 zeros. Any ideas how to see the leading zeros in the .csv file. ... View more

Re: Merging datasets

by Quartz | Level 8 in New SAS User
‎09-18-2019 09:59 AM
‎09-18-2019 09:59 AM
It seems you want to stack them. That means concatenating them using set instead of merge. ... View more

Re: replacing

by Quartz | Level 8 in SAS Programming
‎09-06-2019 09:53 AM
‎09-06-2019 09:53 AM
Yes but how? ... View more

replacing

by Quartz | Level 8 in SAS Programming
‎09-06-2019 09:06 AM
‎09-06-2019 09:06 AM
Hello and Happy Friday,   I have two tables that I want to replace the values of one by another. I need to replace the values of table Psudo_alcs with the values of real_alcs. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-28-2024 04:51 PM
Likes given to
Quick links