About GPatel

GPatel · ‎10-30-2019

Thanks Cynthia for your response. data a; input ID $ a b c d e f g h; cards; ABC 1 2 3 4 5 6 7 8 XYZ 4 3 2 1 8 7 6 5 ; run; data _null_; set a; x='('; y=')'; xhy=cats(x,h,y); xey=cats(x,e,y); xfy=cats(x,f,y); xgy=cats(x,g,y); by id notsorted; file print notitle; if (first.id or last.id) then do; Put @10 id @20 a @35 b @50 c @65 d / @20 xey @35 xfy @50 xgy @65 xhy ; end; run;

GPatel · ‎10-30-2019

Given Data A; would like to have output shown below either in PDF/RTF file format. Any help? data a; input ID $ a b c d e f g h; cards; ABC 1 2 3 4 5 6 7 8 XYZ 4 3 2 1 8 7 6 5 ; run; Output PDF/RTF : ABC 1 2 3 4 (5) (6) (7) (8) XYZ 4 3 2 1 (8) (7) (6) (5)

GPatel · ‎10-28-2019

Please refer to following two papers : https://support.sas.com/resources/papers/proceedings/proceedings/sugi31/249-31.pdf https://support.sas.com/resources/papers/proceedings/proceedings/sugi30/001-30.pdf

GPatel · ‎05-29-2019

For “not equal”to operator.

GPatel · ‎05-29-2019

Use ^=

GPatel · ‎05-29-2019

PROC SQL; CREATE TABLE b(where=(SUBSTR(ID,1,1)='P')) AS SELECT * FROM a oRDER BY id; QUIT; PROC SQL; CREATE TABLE b AS SELECT * FROM a(where=(SUBSTR(ID,1,1)='P')) oRDER BY id; QUIT;

GPatel · ‎05-29-2019

DATA A; INPUT ID $; CARDS; PCR00026 NCR00025 PCR00027 NCR00033 NCR00055 ; RUN; PROC SQL; CREATE TABLE b AS SELECT * FROM a WHERE SUBSTR(ID,1,1)='P' oRDER BY id; QUIT; PROC PRINT; RUN;

GPatel · ‎12-27-2017

Thanks for your reply with suggestions. Will follow your advise and work it out. GPatel

GPatel · ‎12-25-2017

Hi All, Need help to fix the error shown in the attached "installerror_WEBSERVER_CONFIGURATION.zip" ("IMG_0245.jpg" ) file. Log file and configuration script file is also attached. Regards, GIRISH PATEL 703-582-3025

GPatel · ‎09-28-2017

Need help with these three concerns. Any suggestions, or comments? 1. SAS VA report needs to be refreshed, so instead of refresh icon, can it be changed to refresh button? 2. Missing data shows a red triangle at the bottom - how do we change that to display " Error msg :......." 3. Object Control- with a date field (example-two dates) result comes to with min date and max date. - how we change the order/hierarchy ? Regards, Girish Patel

GPatel · ‎09-03-2017

Can somebody assist me .....How following query can be translated into either SAS HASH code (preferred) or SAS QUERY code? Below is a given SQL NATIVE Query ( note that there is + sign in a where clause): SELECT DISTINCT A1.acod as acode, A1.descp as FDESC, catx(' - ', B1.scod,B1.tcod) as stcode FROM X X0, A A1, B B1, C C1 WHERE A1.OFFICEID(+) = X0.officeid AND B1.STATUSCD(+) = x0.STATUSCD AND C1.Post(+) = X0.Post AND C1.Pre(+) = X0.Pre AND X0.Pre(+) = C1.Pre AND X0.Post(+) = C1.Post ; Quit;

GPatel · ‎08-25-2017

Well, very good responses recieved from Reeza, ChrisNZ, Ron_Fehd_macro_maven, and Quentin. Each of them shed very intereting insights and comments. It was found that my dataset A has n=xxxx,xxxx number of UNIQUE records not observed in dataset B. Similarly, dataset B has n=xxx,xxx number of Unique records not observed in dataset A. So, I learned that Proc Compare should not be employed, but data step or SQL is a best solution. Case closed. Thanks to all who have responded. Girish Patel

GPatel · ‎08-23-2017

I did try it. No luck. Is there any way to isolate only n=13,480 records?

GPatel · ‎08-23-2017

Thanks for your insight and suggested solution. Proc SQL and Data Merge doesn't give me correct/exact counts. I need to create a SAS dataset of n=13,480 records as outlined by Proc Compare results. Number of Observations in WORK.N_402612 but not in WORK.N_389132: 13480. I hope somebody will shed some lights and offers desired solution.

GPatel · ‎08-22-2017

I am comparing two datasets, say A and B. My SAS code is : proc compare base=N_402612(Keep=receipt ) compare=N_389132(Keep=receipt ) out=check ; run; LOG: 23 GOPTIONS ACCESSIBLE; 24 24 ! proc compare base=N_402612(Keep=receipt ) compare=N_389132(Keep=receipt ) out=check ; 25 26 run; NOTE: There were 402612 observations read from the data set WORK.N_402612. NOTE: There were 389132 observations read from the data set WORK.N_389132. NOTE: The data set WORK.CHECK has 389132 observations and 3 variables. Results: Observation Summary Observation Base Compare First Obs 1 1 First Unequal 9 9 Last Unequal 389132 389132 Last Match 389132 389132 Last Obs 402612 . Number of Observations in Common: 389132. Number of Observations in WORK.N_402612 but not in WORK.N_389132: 13480. Total Number of Observations Read from WORK.N_402612: 402612. Total Number of Observations Read from WORK.N_389132: 389132. Number of Observations with Some Compared Variables Unequal: 389124. Number of Observations with All Compared Variables Equal: 8. Values Comparison Summary Number of Variables Compared with All Observations Equal: 0. Number of Variables Compared with Some Observations Unequal: 1. Total Number of Values which Compare Unequal: 389124. All Variables Compared have Unequal Values Variable Type Len Label Ndif MaxDif Receipt CHAR 13 Recipt Number389124 In the output dataset Check, I want to keep only n=13480 records in my output dataset check. Number of Observations in WORK.N_402612 but not in WORK.N_389132: 13480.

Online Status	Offline
Date Last Visited	‎05-17-2024 11:04 PM

Re: Abnormal characters in sas file

Re: Macro Quetion

Macro Quetion

How to create multiple excel file links in Job Execution

Re: Can HASH Object do the same job?

Re: Can HASH Object do the same job?

Re: Can HASH Object do the same job?

Re: Can HASH Object do the same job?

Re: Can HASH Object do the same job?

Can HASH Object do the same job?

Re: Updating JSON files….

Re: Finding a Specific letter in Specific position in text

WEB SERVER CONFIGURATION ERROR at STAGE # 11 DURING INSTALL

Re: Custom PDF/RTF Output

Custom PDF/RTF Output

Re: Feeding the top 25 diagnoses into the next program

Re: Finding a Specific letter in Specific position in text

Re: Finding a Specific letter in Specific position in text

Re: Finding a Specific letter in Specific position in text

Re: Finding a Specific letter in Specific position in text

Re: WEB SERVER CONFIGURATION ERROR at STAGE # 11 DURING INSTALL

WEB SERVER CONFIGURATION ERROR at STAGE # 11 DURING INSTALL

Can Visual Analytics components be customized?

SQL and HASH

Re: Proc Compare

Re: Proc Compare

Re: Proc Compare

Proc Compare