Hi,  I have a CSV file with multiple columns. While converting the CSV file into a dataset using Proc import, Some values in random columns are getting shrink.   For instance:  In CSV file there is an ID 'TNGPM000023662' After Import the data it has 'TNGPM00002366' (The last number is missed)   Likewise, some random columns read only the limited set of values in Proc Import. Kindly suggest a best method to read all the data values.   Thanks in advance! ... View more

I have a dataset to calculate by the given formulae. Kindly suggest a code to resolve it. data Have; input ID Val Type$; cards; 1 10.5 normal 2 12.4 abnormal 3 16.6 normal 4 10.8 normal 5 13.9 abnormal 6 17.1 normal 7 14.4 abnormal 8 11.2 abnormal run; Formula: count (abnormal)/sum(Val) * 1000 : i.e: 4/51.9*1000 ... View more

Hi, I have to concat the information given in different cell with same ID and Date. data Have; input ID Dt mmddyy10. Activity:$30. Act_freq:$30.; cards; 123 12/19/2010 Walking Daily 123 12/19/2010 NormalWalking Daily run; For instance: Have: ID  Date Activity Act_freq 123 19-12-2010 Walking Daily 123 19-12-2010 NormalWalking Daily   Want: ID  Date Activity Act_freq 123 19-12-2010 Walking, NormalWalking Daily, Daily   Kindly suggest a code to get this format. Thanks in advance! ... View more

I need to extract the value of drug dosage given in the Morning, Afternoon and Night for the calculation from the scratch set. Here I given the sample dataset and expected output for your reference. data have; input Drugs&$500.; cards; Variable_Dose Unit MORNING(V) x90 days Morning 28 unit, Afternoon 0 unit, Night 0 unit Variable_Dose Unit MORNING(V) , Morning 20 unit, , (Mor-Aft) , Morning 15 unit, Afternoon 12 unit, Morning 16 unit, Afternoon 10 unit, (Mor-Aft) , Morning 015 unit Afternoon 10 unit (Mor-Aft) , Morning 0 unit, Afternoon 0 unit, Night 15 unit, , , Night 15 unit (N) , Night 10 unit LAST DOST Expected Output: Morning Afternoon Night 28 0 0 20     31 32   15 10   0 0 30     10 (or) If it a huge process to SUM the unit values, at-least help me to extract the keyword like below as output: Col1 Col2 Col3 Col4 Morning 28 unit Afternoon 0 unit Night 0 unit   Morning 20 unit       Morning 15 unit Afternoon 12 unit Morning 16 unit Afternoon 10 unit Morning 015 unit Afternoon 10 unit     Morning 0 unit Afternoon 0 unit Night 15 unit Night 15 unit Night 10 unit         The extraction process should be done with in the Keyword/Syntax : Day Value Unit Any help will be appreciated.   ... View more

Hi Experts,    I need to create the group type in numbers for the following dataset   data have; input G_Type$10.; cards; ABI ABI BIG BIG BIG RET run; Expected output: G_Type Want ABI 1 ABI 1 ABI 1 BIG 2 BIG 2 BIG 2 RET 3     Thanks in advance! ... View more

Hi, I need to convert the texted date variable to a particular format. Eg: data have; input R_Date$20.; cards; 31/01/2000 15/3/2015 30-5-2010 30-12-2018 31/7/20 15/2/12 18/05/15 11-08-08 2000 1998 ; Expected result 01/31/2000 03/15/2015 05/30/2010 12/30/2018 07/31/2020 02/15/2012 05/18/2015 08/11/2008 01/01/2000 01/01/1998   Kindly suggest a code to get MM/DD/YYYY format. ... View more