About pp2014

pp2014 · ‎10-25-2019

Regarding date, I will have dataset with current_date field in it which gets updated every month when data gets updated. So current month is Sept 2019. I want to see Date field also while transposing..

pp2014 · ‎10-25-2019

I have the following Rx monthly data. Rx1 being the latest month data. In my case it Sept 2019 data. data have; infile cards expandtabs truncover; input id $2. rx1 rx2 rx3 rx4 rx5 & 2.; cards; 1 5 6 8 10 4 2 0 2 4 7 6 4 1 1 3 9 2 7 3 2 4 6 3 6 4 2 5 6 8 ; I want the output to be as below id Date1 Rx 1 Sept-2019 5 1 Aug-2019 6 1 Jul-2019 8 1 Jun-2019 10 1 May-2019 4 2 Sept-2019 0 2 Aug-2019 2 2 Jul-2019 4 2 Jun-2019 7 2 May-2019 6 4 Sept-2019 1 4 Aug-2019 1 4 Jul-2019 3 4 Jun-2019 9 4 May-2019 2 7 Sept-2019 3 7 Aug-2019 2 7 Jul-2019 4 7 Jun-2019 6 7 May-2019 3 6 Sept-2019 4 6 Aug-2019 2 6 Jul-2019 5 6 Jun-2019 6 6 May-2019 8

pp2014 · ‎06-22-2018

I have the product field with following info: Product Atrilin Amox HC Retin-A Micro Tobi Cream Luzu Cream I want the output as follows: Product Atrilin AmoxHC Retin-AMicro TobiCream LuzuCream I tried compbl function but it does not work. I would appreciate any help with this.

pp2014 · ‎01-17-2018

I am trying to use the above code in macro as follows: %macro test; data testdata; set lib.testdata; array trx(106) trx1-trx106; array nw(106) nw1- nw106; %do i=1 %to 106; nw(&i)=0; %end; %do i=106 %to 1 by -1; %if trx(&i) ne 0 %then %do; nw(&i) = 1; leave; %end; %end; run; %mend; %test; I get the following error. ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: 1 by -1 ERROR: The %TO value of the %DO I loop is invalid. ERROR: The macro TEST will stop executing. I would appreciate any help in this..

pp2014 · ‎01-16-2018

Thanks Reeza for the help. It worked..

pp2014 · ‎01-16-2018

I have the following sample data for 5 weeks by doctor_ID data have; input id rx1-rx5; cards; 12 1 0 4 0 3 13 0 2 0 0 0 14 0 0 3 1 0 15 2 1 0 0 2 I want to get the new writers each week. rx1-rx5 is the Rxs the doctors wrote for 1 thru 5 weeks. Rx1 being the latest week. Rx5 is oldest week. Output should be as below: ID nw1 nw2 nw3 nw4 nw5 12 0 0 0 0 1 13 0 1 0 0 0 14 0 0 0 1 0 15 0 0 0 0 1 I would appreciate any help in this

pp2014 · ‎11-07-2017

Thanks a lot. It helped...

pp2014 · ‎11-06-2017

Sometimes particular ID may have missing tr2 Value and have only tr1 value. In that case keep only tr1 value and leave tr2 blank for example 15 AB4D 15 AB4D

pp2014 · ‎11-06-2017

I have following data: data have; input id $2. tr1 $4. tr2 $4.; cards; 12 AB4D 12 AB4D MN2X 13 AB4D MN2X 13 MN2X 14 AB4D MN2X 14 AB4D MN2X run; I want the output as follows: ID t r1 tr2 12 AB4D MN2X 12 AB4D MN2X 13 AB4D MN2X 13 AB4D MN2X 14 AB4D MN2X 14 AB4D MN2X Can anybody help me in getting the missing values filled using SAS? Thanks

pp2014 · ‎06-19-2017

Hi Tom, I have the following headers : Survey Name|Contact Name|Follow-up History|Last Follow-up Date|Last Follow-Up Comment Altogether 4 pipes in between. How to read the file with pipe delimited having carriage control.. Thanks

pp2014 · ‎06-19-2017

Hi Tom, I tried to use your code to get rid of linefeed characters. Somehow it is not working for me. I have Pipe delimited csv file and it has linefeed characters. I would appreciate if you can help me how to read pipe delimited file with Linefeed characters. Thanks

pp2014 · ‎05-15-2017

I am trying to save .csv file to read it back into SAS using PROC IMPORT. The reason I am doing this is that it gives me INVALID string error if I try to read the file directly using PROC IMPORT. If I save the file and then use PROC IMPORT, I don't get that error. Is there any other way I can save the file. Please let me know. Thanks

pp2014 · ‎05-15-2017

I am trying to save the .csv file with the same name using following data _NULL_. But my system hangs up when I use the following statements. I am using SAS 9.2 Can anybody help me in finding a solution? filename exl dde 'excel|system'; options noxwait noxsync; x "'C:\Program Files\Microsoft Office\Office15\EXCEL.EXE' C:\Temp\test.csv"; data _NULL_; x=sleep(5); run; data _null_; file exl; put '[SAVE()]'; put '[CLOSE()]'; run; data _null_; file exl; put '[QUIT()]'; run;

pp2014 · ‎03-29-2017

Anybody knows the solution...

pp2014 · ‎03-29-2017

I am using following export procedure to export data to .xlsm extention file. It does the export but creates new sheet instead of replacing the old one. It creates sheet called output1. Can anybody help me with this? Below is the code: proc export data=extract outfile="C:\temp\testXYZ.xlsm" dbms=excel2000 replace ; sheet='output'; run;

Online Status	Offline
Date Last Visited	‎04-15-2020 05:53 PM

Re: Help with Transposing Columns into rows

Help with Transposing Columns into rows

Help with Removing Blanks in the field

Re: Help in finding the New Rx Writers

Re: Help in finding the New Rx Writers

Help in finding the New Rx Writers

Re: Filling up and down missing values with non-missing values

Re: Filling up and down missing values with non-missing values

Filling up and down missing values with non-missing values

Re: Carriage Returns - Need to be removed

Re: Filtering URL addresses

Re: How to subtract hours from datetime Variable in proc sql

Re: Help with Transposing Columns into rows

Help with Transposing Columns into rows

Help with Removing Blanks in the field

Re: Help in finding the New Rx Writers

Re: Help in finding the New Rx Writers

Help in finding the New Rx Writers

Re: Filling up and down missing values with non-missing values

Re: Filling up and down missing values with non-missing values

Filling up and down missing values with non-missing values

Re: Carriage Returns - Need to be removed

Re: Carriage Returns - Need to be removed

Re: Problem in SAVING csv file using Data _NULL_

Problem in SAVING csv file using Data _NULL_

Re: Problem in export the data to .xlsm file

Problem in export the data to .xlsm file