Hi All, I reckon everyone is doing great. I require your assistance on something like. I've a CSV file and I imported into sas so, the data in that CSV file looks like the below one. And it is completely a json data so, from this I would like to create a table whose fields are Batch no, Goodsname, Quantity, Infotype and please closely observe this data as you see there's a value named  NEWLY, this value doesn't come often but when it comes the values under this has to be the fields like D_Infotype, D_Typeid,  D_Quantity. I'll explain you how this to be analysed, here BatchNo is an end point for every record so, until a new BatchNo comes the values should be treated as one records data.  Any help much appreciated. Thankyou. Required output; BatchNo GoodsName Quantity Infotype D_Infotype D_Typeid D_Quantity 001 Nikeshoes 3 Sneakers 001 Pants 5 Trackpants RAQ 109 0 009 Nikeshoes 3 Sneakers 009 Pants 5 Trackpants 011 Jackets 3 Topwears RAQ 109 0 """BatchNo"":""001"""" """Goodsname"":""Nikeshoes"""" """Quantity"":""3"""" """Infotype"":""Sneakers"""" """Goodsname"":""pants"""" """Quantity"":""5"""" """Infotype"":""Trackpants"""" """Newly"":"""""" """Infotype"":""RAQ"""" """TypeId"":""109"""" """Cause"":""Broken"""" """Quantity"":""0"""" """BatchNo"":""009"""" """Goodsname"":""Nikeshoes"""" """Quantity"":""3"""" """Infotype"":""Sneakers"""" """Goodsname"":""pants"""" """Quantity"":""5"""" """Infotype"":""Trackpants"""" """BatchNo"":""011"""" """Goodsname"":""Jackets"""" """Quantity"":""3"""" """Infotype"":""topwears"""" """Newly"":"""""" """Infotype"":""RAQ"""" """TypeId"":""100"""" """Cause"":""Broken"""" """Quantity"":""0""""   ... View more

Hi All, I hope everyone is doing great. I've two variables named X, Y whose types are X - numeric of length 8 Y - Date of length 8. However whenever there's empty rows in both the variables the type and length automatically changing to Character 1. May I know how to resolve this issue. Even if the rows are empty the types should be of numeric and date of length 8. Thankyou!. ... View more

Hi Everyone, I'm looking for some assistance from you all regarding the topic which is: I've a numeric column named AMOUNT Required output: name Amount X 12345 Y 5709 Z 56 A 10 Sum 18120 Data have; Input name $5. Amount 10.; Datalines; X 12345 Y 5709 Z 56 A 10; which has 4 values. I would like to add the sum of these 4 values as the 5th  value  of this existing column and table. Please advise. Thanks in advance. ... View more