cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
GPNaveen
‎06-17-2020
  • 6 Posts
  • 0 Likes Given
  • 1 Solutions
  • 3 Likes Received

Re: Error while reading special characters

by Fluorite | Level 6 in SAS Programming
‎03-17-2017 01:43 AM
‎03-17-2017 01:43 AM
Hello,   This serves the purpose but not sure if this is how you wanted it.   Example:   data test; input price comma10.2.; price2=compress(price,,'kd'); datalines; 825,563.25 ; run;   proc print data=test; run;   Thanks GP ... View more

Re: Analysis of month to month screening performance by organization

by Fluorite | Level 6 in SAS Programming
‎03-16-2017 07:40 AM
‎03-16-2017 07:40 AM
Hello,   I tried using Proc tabulate for the same after creating a variable to capture Month value. The code is as below for the proc tabulate. Please run this code and check if this serves the purpose.   Example:   Proc Tabulate data=have; class _OrganizationTax month HepCscreeningdone HCVresult / missing; table _OrganizationTax='Organistaion' , HepCscreeningdone='HCV Screening' , month =' ' * HCVresult='HCV status' ; KEYLABEL N=' '; run;   Thanks GP ... View more

Re: How to use macro along with into:?

by Fluorite | Level 6 in SAS Programming
‎03-16-2017 04:43 AM
2 Likes
‎03-16-2017 04:43 AM
2 Likes
Hello,   Before we use a macro value obtained from SQL we need to trim the blanks. That is, Macro Variable : cPOSModeCNT would have leading and trailing blanks which needs to be taken off before we use it alongside a literal.   The code should work with this small change as below:   *get the number of distinct cPOSMode; proc sql; select count(distinct cPOSMode) into :cPOSModeCNT from have; quit; %let cPOSModeCNT=&cPOSModeCNT; *generate the macro variables based on the previous number; proc sql; select distinct cPOSMode into :cPOSMode1-:cPOSMode&cPOSModeCNT. from have; quit; I hope this would be helpful. Thanks GP  ... View more

Re: Merging Issue

by Fluorite | Level 6 in SAS Programming
‎03-16-2017 01:37 AM
‎03-16-2017 01:37 AM
Hello,   I see the code to be fine, may be that while the New dataset is being read into a dataset the missing fields are not considered in the expected way.I would suggest to use MISSOVER option in the infile and then try the code .It must do your job.   Example:   Data New; infile datalines missover; input Location_id Area$ Phone; datalines; 1234 2345 1233 5543 ; run;   Data Old; Input Location_id Area$ Phone; Datalines; 1234 NYC 55555 2345 ABC 77777 ; run;   proc sort data=New nodupkey; by Location_id; Run; proc sort data=Old nodupkey; by location_id; Run; data New1; merge New(in=a) OLD(in=b); by location_id; if a; run;     Thanks, GP ... View more

Re: Sort rows while keeping one fixed

by Fluorite | Level 6 in SAS Programming
‎03-15-2017 07:36 AM
‎03-15-2017 07:36 AM
Hi,   If we need to sort any variable within another variable (nested sorting) ,we could get this done with the help of PROC SORT. We can use the By variable and get the task done.   Example:   Data try; Input NAME$ AGE NET REG LOSS; Datalines; home 300 200 50 . home 100 300 . 5 TDR 80 500 . 3 TDR 100 200 5 . ; run; Proc sort data=try out=try2;by net age; run;   Now the variable NET is sorted first within which the variable Age is sorted.   Thanks , GP ... View more

Re: Print duplicates of each record

by Fluorite | Level 6 in SAS Programming
‎03-15-2017 04:33 AM
1 Like
‎03-15-2017 04:33 AM
1 Like
Hello,   data have; input sno age sex$; datalines; 1 23 M 2 45 F 3 25 M 5 25 F 4 24 M ; run;   proc print data=have; Title " Input data set values"; run;   data want(drop=i j); do i=1 to tot; set have nobs=tot; do j=1 to i; output; end; end; run;   proc print data=want; Title "Required Dataset"; run;     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-17-2020 09:19 PM
Likes from
Quick links