About mauri0623

Ksharp · ‎01-04-2020

data have; input str $10.; cards; 5000000 4000000 3000000 ; data want; set have; length want $ 8; want=left(str); want=translate(right(want),'0',' '); run;

novinosrin · ‎12-16-2019

Hi @ed_sas_member Appreciate your details but it can be much more concise with the use of format rather than compress YYMMDDn8. put(intnx("day",(intnx("month",input(Invoice_date,YYMMDD10.),-1)),27),YYMMDDn8. -l); - l --> just left aligning the result

gamotte · ‎11-15-2019

Hello, If you only want to get rid of the minus sign when you display results in reports but without losing the information in the dataset, you can use a format as follows : proc format; value noneg other=[abs()]; run; data have; x=-1; run; proc print data=have; format x noneg.; run;

mkeintz · ‎10-15-2019

@mauri0623 wrote: 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. Maybe you don't have to get rid of the trailing "C". Since the other variable would match everything but the trailing C, you could match based on the "EQT" (equal-truncated) operator, as in data table1; input id @13 matchval $11. ; datalines; 09120192019 0800000 C 047 X4540001 C 013 X4512000 C 02020192019 0919000 C run; data table2; input name $4. matchval $11.; put (_all_) (=); datalines; DAVE 0800000 MARK X4512000 ALEX ABCDEF run; proc sql; create table want as select t1.*,t2.name from table1 as t1 inner join table2 as t2 on t1.matchval EQT t2.matchval; quit;

andreas_lds · ‎10-11-2019

Instead of telling scan to search from right to left by using a negative index, you could use the fourth parameter: part = scan(string, 1, ', ', 'b');

ballardw · ‎10-08-2019

It is pretty easy to see that you have duplicate values for OBLIGATING_DOC_NO with the same IPAC value. This is from the first 3 data lines of your B7600s.csv, which I have to assume is related to your TableB. IPAC OBLIGATING_DOC_NO TAS ACCOUNTING 89000001 89233119SNA000165 08920192020 0251000 01278.2019.01.100260.2510 89000001 89233119SNA000165 089 X0251000 01250.2019.01.100260.2510 89000001 89233119SNA000165 08920192020 0240000 70052.2019.60.300602.2510 Subqueries used like the highlighted need to return a single value proc sql; update pips_data p set obligating_doc_no = (select obligating_doc_no from tableB b where p.ipac = b.ipac ) like the error message says. So you need an additional filter on your data to ensure you get one and only one value of the variable from the subquery for the value of Ipac.

Tom · ‎10-03-2019

So you want to truncate the first column to only 10 characters and the last column to only 25 characters? data test; infile csv dsd truncover firstobs=2; row+1; do col=1 to 4 ; input value :$200. @; length=lengthn(value); output; end; run; proc means min max n mean ; class col; var length; run; Analysis Variable : length N col Obs Minimum Maximum N Mean 1 98 6.0000000 15.0000000 98 8.1530612 2 98 0 20.0000000 98 12.0204082 3 98 0 19.0000000 98 13.0306122 4 98 0 114.0000000 98 43.9693878

PeterClemmensen · ‎09-30-2019

data table1; input ALC $ 1-21 TAS $ 10-23 ODN $ 25-41 FundingCode $ 43-48; datalines; 89000001 08919/200243 89303019SEA000002 20EA01 89000001 089X0243 89303019SAU000016 20AU01 89000001 089-17/20-0321 89243419SEE000038 20GO01 89000001 089-17/20-0243 89303019SLM000012 20LM01 89000001 089-X-0319 89243219SNE000007 20ID01 ; data table2; input ALC $ 1-21 TAS $ 10-23 ODN $ 25-41 FundingCode $ 43-48; datalines; 20EA01 20AU01 20GO01 20LM01 20ID01 ; data want(drop=rc); if _N_=1 then do; declare hash h(dataset:'table1'); h.definekey('FundingCode'); h.definedata('ALC', 'TAS', 'ODN'); h.definedone(); end; set table2; rc=h.find(); run;

ballardw · ‎09-23-2019

@mauri0623 wrote: Opening the .csv file in notepad ++ still shows the leading zeros missing. If you first opened in Excel and then saved it, such as after widening columns to see values then Excel likely "corrupted" the values. You did not say that you never opened the file in Excel.

GS2 · ‎09-19-2019

I have run into the concern you have mentioned where the same intended variable is a character in 1 data set and numeric in the other. What would be the best method to convert the numeric variable into a character? The final variable should be character but in one data set it is entered as a binary 1/0 for yes/no so what would be the best way to convert to character without losing the numeric data? Thank you

PeterClemmensen · ‎09-06-2019

Do like this. I just create an example data set a data a; a=1; run; proc datasets lib=work nolist; change a=b; run;quit; So in your case, it will be something like proc datasets lib=work nolist; change real_alcs=Psudo_alcs; run;quit; If your data is not in the work library, then change the lib= part

novinosrin · ‎08-21-2019

Hello @mauri0623 I am pleased you received an nice LOCF straight forward and neat solution. I would like to suggest to use missing function rather than representing with a ' '(character) or . (numeric) constant. It's much safer and convenient besides reading ease and does the job of course. When you check for ordinary missing numeric values, you can use code that is similar to the following: if numvar=. then do; To check for a missing character value, you can use a statement that is similar to the following: if charvar=' ' then do; The MISSING function enables you to check for either a"character or numeric missing value",as in: if missing(var) then do;

mauri0623 · ‎08-07-2019

Than you for the quick response. I accepted your solution.

ScottBass · ‎07-02-2019

I answered your question as you originally posted. I'll leave it to others to answer your new question. Or perhaps you can modify what I posted to suit your actual requirements. Good questions == good answers. The reverse is also true.

tsap · ‎06-28-2019

This should accomplish the results you are looking for: DATA WORK.HAVE; FORMAT ALC $7. ODN $7.; INFORMAT ALC $7. ODN $7.; INPUT ALC ODN; INFILE DATALINES DLM='|' DSD; DATALINES; 7007001|GA0131a 7007002|KA0131a 7007120|ZZ0131a 7003120|DA0131a 5689020|CA0131a 4738590|PB0131a 8302345|GA0131b 8302345|ZZ0131a 8302345|DA0131a 8302345|ZZ0131a 5790234|KK1Y90 |KFGG80 5892034|ZZZ1809 |ZZB1809 |MMN09 |CVGqQ2 |GXPPO0 ; DATA WORK.Have (DROP= ALC2); SET WORK.Have; RETAIN ALC2; IF ALC NE ' ' THEN ALC2=ALC; ELSE IF ALC = ' ' THEN ALC=ALC2; RUN; PROC SQL; CREATE TABLE WORK.Exceptions AS SELECT ALC, COUNT(ODN) AS Total_ODN FROM WORK.HAVE GROUP BY ALC HAVING COUNT(ODN) >1 ORDER BY ALC; QUIT;

Online Status	Offline
Date Last Visited	‎03-28-2024 04:51 PM

date_manipulation

Adjust PROC SUMMARY output

simple where statement.

Re: Dates manipulation

Re: Date forward and backward.

Dates manipulation

Date forward and backward.

Re: question

Re: question

Re: question

Re: convert

Re: convert

Re: sas subtraction

Re: string issue

Re: Date Calculation

Re: get rid of negative sing

Re: String manipulation

Re: How to get part of a string

Re: Updating column of one table with another

Re: .csv file issue

Re: filliong out missing data

Re: leading zeros

Re: Merging datasets

Re: replacing

Re: filling out missing with the previous value

Re: Table look up using merge

Re: SAS timestamp

Re: Data Step