Check if the variable IDA is of character- or numeric- type. Null values in character variables are assigned a blank ('') while in numeric variables it is a period (.) Hence if IDA is numeric, your condition will just be: if IDA = . But if IDA is character, your condition will be: if IDA = '' The only time you will need to use: if IDA = '.' is when a character variable intentionally has a period for a value. ... View more

You can try also to read the file as: filename binfile "<path and file name>"; data test; infile binfile truncover; input NUMBER 01-06 binary6. UUU 07-10 binary4. REQ 11 $binary1. DATE(DDMMCCYY) 12-19 binary8. AMOUNT 20-30 binary11. SIGN 31 $binary1. AMOUNT1 32-42 binary11. SIGN1 43 $binary1. TEST 44 $binary1. ; output; file log; put number = uuu= date= amount= amount1=; put req= $hex2. sign= $hex2. sign1= $hex2. test=$hex2. ; stop; run; compare the data acquired to a hard print of first record asked from file sender. Please post the hard copy, the result and the log; ... View more

@JJP1 wrote: Hi Iam having date valus as "25JAN2019:13:30:59.590000" in one of the SAS dataset. and iam using timepart(25JAN2019:13:30:59.590000) function and format and informat as tim8. Iam getting below time value 13:31:38 Iam unable to understand why 59 is getting changed to 38 please.please help how it reallly works I would expect to see a 13:31:00 if some rounding went on but strongly suspect some other manipulation to get 38 seconds. ... View more

Did you make sure BOTH datasets are sorted? Run a proc contents on both of the datasets. If in doubt, a simple data step with by will check if a dataset is correctly sorted.   Hint: when you anonymize a log, don't use just "data". Make sure we can see where the log was redacted by using something like XXXXXXX or REDACTED or similar. In SAS logs, you won't find a lowercase dataset name. ... View more

Sorry @Patrick,Thanks for correction,I have created new one please ... View more

@JJP1  I can't know how your source data looks like. Why don't you post a SAS Data step which creates a representative sample of your source data. Then show us how the two target data sets need to look like and explain the logic required for splitting. May be forget about DIS in the moment. Let's just get something working with simple SAS datastep code. Once we've got something working then converting the logic into DIS shouldn't be that hard anymore. ... View more

Yes.Thanks @Kurt ... View more

Hi    I think you need to perform a join with 3 tables and then one table loader and load the data based on the control table where you need to make something conditions based on the start and end date.   I hope you are aware about the control table parameters or else have a check with Google.   Because with SAS DI JOB design I might not help you from here.   Gud luck. ... View more

Thanks .Sorry to trouble you. Would you please help on code please.kindly have a look at below screen shot of transpose job please.But the value6,value7 ...till value12 data may be coming or may not be coming from source please. but it should create 12 values unde proc transpose output.if the values are not coming for value6,value7...value12.it should display output as null please.iam trying by taking user written node transformation after sort with below code.but still it is not created desired output but just created based on values only please (value1..value6).but the job should ceate output columns value7..value12 )please.if in case future data will be coming for value6 ..value12 then sas job should be taken care.please advise. data work.W1B6ODL4; set work.W8EDMBU2; count + 1; by NAME VALUE STATUS; if first.NAME then count = 1; if VALUE then count = 1; if STATUS then count = 1; run; ... View more

WOW.Thanks Jebjur for helping me ... View more

Thanks @Reeza .Tech support team provided below hotfix link   http://support.sas.com/kb/62/840.html       ... View more