About raveena

raveena · ‎02-03-2012

Hi all, I have a dataset 'Test' with the columns type, _freq_, _freq_p and change. Need to calculate the changes for prior count in percentage and in case if Current count is zero the change should display as 100%. Example: Type _freq_ _freq_p Anc 20 20 PCP 0 30 Spc 5966 5967 Output should be Type Currentcount Priorcount change Anc 20 20 0.00% PCP 0 30 100% Spc 5966 5967 (0.02%) I tried the below code, proc report data=test ls=256 headline headskip split='*' nowd column type _freq_ _freq_p change; define _freq_/sum "CURRENT COUNT " width=20 format=comma10. spacing=1; define _freq_p/sum "PRIOR COUNT " width=20 format=comma10. spacing=1; define change/computed 'CHANGE %' width=20 format=percent8.2 spacing=1; compute change; if _freq_p.sum='' then change='1'; else change=(_freq_.sum -_freq_p.sum)/_freq_p.sum; run; But am not getting an exact answer what am expecting ? please help me out to fix this issue. Thanks in Advance.

raveena · ‎12-08-2011

Hi, I have a dataset with vendor number containing invalid characters.I would not select any vendor numbers that contain characters other than A-Z,0-9 or dash(-).We can use compress function, but not sure what are the invalid characters in the data. Example: data test; input vendor ; cards; 111948722-070Ž 1119789^78A 789567890 908765TYR ; RUN; REQUIRED OUTPUT : Vendor 789567890 908765TYR Please let me know. Thanks in Advance.

raveena · ‎10-24-2011

Hi Art, DO NOT SELECT A ID WHEN THE ID IS EMPTY OR DOES NOT BEGIN WITH A – Z OR 0 -9 OR THE LENGTH OF ID= 1. This one for other requirement. Thanks for your help !!

raveena · ‎10-24-2011

Thanks Art..I need to clarify one more thing,If DOES NOT BEGIN WITH A – Z OR 0 -9 OR THE LENGTH OF ID= 1 then delete. Please let me know. Thanks

raveena · ‎10-24-2011

Hi, I have a field Id, if the id is length of provno less than 7 then delete.. data id; set id; cards;1 234-A35 1234567-d45 e453768 *123456789 *12345 ; run; Please let me know. Thanks

raveena · ‎10-03-2011

Hi , I have two tables Table 1 and Table 2, need to rollup from table 1 Covunit field value to Table 2 totunits field where rev=N Table 1: In table 1, we have ID that has multiple line no. ID LINENO pos covunit rev 1 1 23 1 N 1 2 23 1 N 1 3 23 1 N 1 4 23 1 N 2 1 23 1 N 2 2 23 1 N 3 3 23 1 N 4 5 23 1 Y Table 2: In table 2, the default value for lines is 0. ID lineNo totunits 1 0 2 0 3 0 4 0 Output should be: ID lineno Totunits 1 0 4 2 0 2 3 0 1 4 0 Please help me out on this logic. Thanks in Advance

raveena · ‎09-28-2011

Thanks Art !!

raveena · ‎09-28-2011

Thanks Art.. In case if i want to get all the rows as below, ID svc pos comp DRg 1 123 21 01 2 D234 23 01 3 D280 21 01 J280 4 D280A 21 09 5 280A 23 09 6 D567 21 04 Y280 Please let me know. Thanks

raveena · ‎09-28-2011

Hi , I have four fields in a table and have to create a new field called DRG..My criteria is 1. when the first character is a 'D' 2. last character is not 'A' 3. POS=21 and 4. when the above conditions are met,then the field is populated with a prefix plus the SVC minus the first character (D) 5. the prefix is based on the comp code.for comp 01 the prefix is 'J' and for comp 04 the prefix is 'Y' ID svc pos comp 1 123 21 01 2 D234 23 01 3 D280 21 01 4 D280A 21 09 5 280A 23 09 6 D567 21 04 Output should be: ID svc pos comp DRG 1 D280 21 01 J280 2 D567 21 04 Y567 Please help us on this issue. Thanks in Advance.

raveena · ‎09-28-2011

Hi Art, I would like to skip this question. Even I am not so clear with this requirement. Thanks for your valuable time in response for this question.

raveena · ‎09-27-2011

Art, In test 1 , the format for that field is best32. and test 2 the date format is MMDDYY10.

raveena · ‎09-27-2011

Yes Art..

raveena · ‎09-27-2011

Hi , I have two tables test1 and test2 and need to join two tables by id and birthdat (only by month and year not by date).The date formats are different in both the table. Test1: ID bthdat 1 19400420 2 19890929 5 19830624 Test2 : ID bthdat 1 20/04/1938 2 29/04/1938 3 11/27/1938 Please let me know. Thanks.

raveena · ‎09-27-2011

Hi kiwi, I am using SAS 9.1 ...Finally i have applied this logic to get the output without header records, data null; File "&drv14.\test" dsd dlm='~' lrecl=32767; Set output ; Put ( _all_)(+0); run; Thanks for all your responses.

raveena · ‎09-26-2011

Hi Art, I am getting an error as below, PROC EXPORT DATA= WORK.TEST 83 OUTFILE= "&drv2.\RGA14001\current\dd.dat" 84 DBMS=DLM REPLACE; NOTE: The previous statement has been deleted. 85 DELIMITER='~'; 86 PUTNAMES=NO; -------- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 87 RUN;

Online Status	Offline
Date Last Visited	‎09-25-2015 08:17 AM

Re: Regarding Macro Error

Regarding Macro Error

Re: Regarding Date logic

Regarding Date logic

Macro date logic

Regarding Substring

Re: Macro to read multiple txt files

Macro to read multiple txt files

Re: Create Dummy Number

Create Dummy Number

Re: Assign sequential ID by multiple groups

data select

Export data to dat file without header record

Help proc report

Remove invalid characters

length issue

length issue

length issue

Roll up Criteria

data select

data select

data select

joining the table by date field

joining the table by date field

joining the table by date field

joining the table by date field

Export data to dat file without header record

Export data to dat file without header record