About animesh123

animesh123

For this I did some more investigation to find out variable which causing issue So I found like 2 or 3 variable which have this issue pasting one as an e.g DECIS_CMT_TX vm for Karina, will need cash added to offering. see condition. future offerings may require a line of credit. I am getting this data from database itself like above pasted , As I am trying to write the same into text file the format is coming same as we fetched from database Is there anyway to fix this on variable itself?

animesh123

So this is for infile ,am not reading the file I am trying to write the data using this code DATA _NULL_; SET workdir.CCDUPSF; FILE '$CURRPATH/YGRT010.txt'; PUT @0001 PCEKEY $40. PUT @0041 FILL $2289.; RUN;

animesh123

Example:- with standard rate. Added room for backend. Trading open auto. Well pd autos and mtg. Additional household income evident. Please , Even tried to do the same with proc export ,but result is same

animesh123

yep I tried with this code ,still the same output even try to add strip and Compbl to remove any blank

animesh123

Can we add something here to fix this: Data workdir.CCDUPSF(keep = PCEKEY SORTKEY FILL); Set workdir.CCORX01WTEMP; LENGTH SORTKEY $42 FILL $2289; SORTKEY= COMPBL(PCEKEY || FILL2); FILL = COMPBL(FILL1 || FILL2 || FILL3); run;

animesh123

yes , I also try to add LRECL=2600 but still the line is breaking

animesh123

getting output data like this for FILL business, on bureau since '17. (Line brk) limited clean credit, a1 fcc hist. (Line brk) replacing unit. DBA: ROSE HILL (Line brk)

animesh123

I am trying to convert sas dataset(containg nearly 9 Mil records) to text file using below code In sas dataset also line is breaking Data workdir.CCDUPSF(keep = PCEKEY SORTKEY FILL); Set workdir.CCORX01WTEMP; LENGTH SORTKEY $42 FILL $2289; SORTKEY= COMPBL(PCEKEY || FILL2); FILL = COMPBL(FILL1 || FILL2 || FILL3); run; DATA _NULL_; SET workdir.CCDUPSF; FILE '$CURRPATH/YGRT010.txt'; PUT @0001 PCEKEY $40. PUT @0041 FILL $2289.; RUN; But while writing it to text file , getting line break on some of the obs. can anyone suggest to fix this line break. This is hapenning for some obs not all the obs

animesh123

Hey Guys , So after fixing the duplicate and missing value the append code were working fine for 10bs , But now since I tried to process the total (83.7 mil) data , its throwing error ERROR: CLI execute error: [IBM][CLI Driver] CLI0111E Numeric value out of range. SQLSTATE=22003

animesh123

I have like 70 variable and near about 1.3M Obs , using update statement I have to define all the variable .correct ?

animesh123

So since I have fix this missing value issue with below code if cmiss(char_vars[i]) then char_vars[i]=' '; if nmiss(num_vars[j]) then num_vars[j]='1'; Now as I tried to do the proc append am getting different error ERROR: CLI execute error: [IBM][CLI Driver][DB2] SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "YGRT1KL1" constrains table "0000004201" from having duplicate values for the index key. SQLSTATE=23505. Is there are any fix other than this ?

animesh123

Yes I dont want replace missing value , the reason i want to use proc append so it just get append

animesh123

yes there is a missing value , is there a way to handle this missing value or handle this type of error .

animesh123

Hi - I am trying to insert 10k data into DB2 table from SAS EG ran Proc append showing error ERROR: CLI execute error: [IBM][CLI Driver][DB2] SQL0407N Assignment of a NULL value to a NOT NULL column "*N" is not allowed. SQLSTATE=23502 Tried proc copy showing the same error is there a way we can use proc sql for this

animesh123 · ‎09-25-2024

So I have code where I want concat multiple(almost 30) variable with different variable name For now am using ; New = name||age||gender||sex||dob||addrees Like this I have 30 var to concat is there are any efficent way to do this

Online Status	Offline
Date Last Visited	yesterday

Re: Getting line break on some of the obs when writing to txt file

Re: Getting line break on some of the obs when writing to txt file

Re: Getting line break on some of the obs when writing to txt file

Re: Getting line break on some of the obs when writing to txt file

Re: Getting line break on some of the obs when writing to txt file

Re: Getting line break on some of the obs when writing to txt file

Re: Getting line break on some of the obs when writing to txt file

Getting line break on some of the obs when writing to txt file

Re: Trying to insert 10k data into DB2 table from SAS EG

Re: Trying to insert 10k data into DB2 table from SAS EG

Re: Getting line break on some of the obs when writing to txt file

Re: Extract First ,Middle , Last name from mail id ?

Re: while running the below code the output data in combined am gettin...

Re: Extract numeric value from a string

Re: Extract numeric value from a string

Re: Getting line break on some of the obs when writing to txt file

Re: Getting line break on some of the obs when writing to txt file

Re: Getting line break on some of the obs when writing to txt file

Re: Getting line break on some of the obs when writing to txt file

Re: Getting line break on some of the obs when writing to txt file

Re: Getting line break on some of the obs when writing to txt file

Re: Getting line break on some of the obs when writing to txt file

Getting line break on some of the obs when writing to txt file

Re: Trying to insert 10k data into DB2 table from SAS EG

Re: Trying to insert 10k data into DB2 table from SAS EG

Re: Trying to insert 10k data into DB2 table from SAS EG

Re: Trying to insert 10k data into DB2 table from SAS EG

Re: Trying to insert 10k data into DB2 table from SAS EG

Trying to insert 10k data into DB2 table from SAS EG

How to concat multiple variable with different name