Hi i have a table of variables with values missing for some and not missing for some.how to get not missing of these values for all rows. subject SODIUM_NLOW_VA SODIUM_NHIGH_VA POTASSIU_NLOW_VA POTASSIU_NHIGH_VA CARBDIOX_NHIGH_VA CHLORIDE_NLOW_VA CHLORIDE_NHIGH_VA CARBDIOX_NLOW_VA 1330 20 18 1330 50 30 1330 50 30 1330 1330 20 15 1233 80 63 1233 80 63 1233 1233 1233 53 23 1233 53 23 1233 thanks in advance
... View more
Hi i have variable names which have common variable like _high_va and _low_va like this SODIUM_NHIGH_VA POTASSIU_NHIGH_VA CHLORIDE_NHIGH_VA CARBDIOX_NHIGH_VA SODIUM_NLOW_VA POTASSIU_NLOW_VA CHLORIDE_NLOW_VA CARBDIOX_NLOW_VA 53 26 30 56 i would like to change this as SODIUM_HIGH for SODIUM_NHIGH_VA likewise for SODIUM_NLOW_VA as SODIUM_LOW which is the variable name and it has values the output should look like this : SODIUM_HIGH POTASSIU_HIGH CHLORIDE_HIGH CARBDIOX_HIGH SODIUM_LOW POTASSIU_LOW CHLORIDE_LOW CARBDIOX_LOW 53 26 30 56 please do suggest some alternative for this step.Thanks in advance
... View more
Hi i want to separate first two words in the following row Input looks like this This how the output should be populated Group --> Group Event manager --> Event manager Progression team --> Progression team Disease progressed due to the following --> Disease progressed Descriptive subject line --> Descriptive subject thanks in advance.
... View more
How to populate the string in reverse order. For example I have a variable under name Fname Praveen Kumar Gowtham Kuppal KK Hari Haran M I want the output to be in the required format: Fname Kumar Praveen KK Kuppal Gowtham M Haran Hari Thanks in Advance
... View more
how to populate date like this DAT from this format to this format 31DEC2019 31 DEC 2019 01MAR2020 01 MAR 2020 08MAR2020 08 MAR 2020 1JUN2020 01 JUN 2020 With space Thanks in Advance
... View more
How to remove extra :00 in time for eg: input: '2019-03-30T20:39:00' '2019-01-30T19:15:00' '2019-01-30' desried output: '2019-03-30T20:39' '2019-01-30T19:15' '2019-01-30' Thanks in advance
... View more
Hi, i have many raw data sets having date under same variable name in character and numeric format. How to set dates by changing all dates into character format without changing separately in each raw datasets For eg; in libraw.have has date in character format in libraw.have1 has date in numeric format while setting data want; set have have1; run; am getting error.since there are many datasets not able to find and chnage all numeric into character fomrat similarly i have many datasets Thanks in advance.
... View more
how to get the last two words using scan function in SAS? if i have visit as Visit 2 Week 4 Visit 12 Week 42 visit 1 day 1 visit 16 week 52 i want the ouptut as Week 4 Week 42 Week 52 Thanks in advance
... View more
