About Jagadishkatam

Jagadishkatam · ‎04-22-2020

Please try the below code in %put you should use &&date&i however you used &date&i also if you want to create the macro variables as &date1 and &date2, we need to use the call symputx in the datastep which i have done in the code below. %let YYMMDD1=200421; %let YYMMDD2=200420; %macro mmacro; %do i=1 %TO 2; Data _null_; Y&i=input(SUBSTR(COMPRESS(&&YYMMDD&i.),1,2),best.); M&i.=input(SUBSTR(COMPRESS(&&YYMMDD&i.),3,2),best.); D&i.=input(SUBSTR(COMPRESS(&&YYMMDD&i.),5,2),best.); call symputx("date&i.",MDY(M&i.,D&i.,Y&i.)); Run; %put &&date&i.; %end; %mend mmacro; %mmacro;

Jagadishkatam · ‎04-22-2020

Here is an example which you can try However in arrays we need to take care that we can use only either all numeric variables or all character variables. In the below example i used all numeric variables to rename. proc sql; select cats(name,'_USD') into: names separated by ' ' from dictionary.columns where libname='SASHELP' and memname='CLASS' and type='num'; quit; %put &names; data class; set sashelp.class; array vars(*) age -- weight; array vars2(*) &names; do i = 1 to dim(vars); vars2(i)=vars(i); end; run;

Jagadishkatam · ‎04-22-2020

you can try something as below %let Vector=2001+2001+2002+2003+2003+2003+2004; data have; var="&vector"; count=countw(var,'+'); do i= 1 to count; var2=scan(var,i,'+'); output; end; run; proc sql; select distinct var2 into: vector separated by '+' from have; quit; %put &vector;

Jagadishkatam · ‎04-22-2020

The simple code below will work proc sort data=have ; by pt_id descending diabetes descending hypertension; run; data want; set have; by pt_id descending diabetes descending hypertension; if first.pt_id; run;

Jagadishkatam · ‎04-22-2020

Could you please provide some sample data with expected output to get better response.

Jagadishkatam · ‎04-21-2020

please try the below code data test; date1 = '2019-04-01' ; call symputx("date2" , cats("'",put(input(date1,yymmdd10.),date9.),"'d")); run; %put &date2;

Jagadishkatam · ‎04-21-2020

Alternatively try the merge statement as well as below proc sort data=enroll; by patient dateassigned; run; data calendar; length patient $8.; set calendar; patient=substr(patientID,1,7); dateassigned=datetracked; run; proc sort data=calendar; by patient dateassigned; run; data want; merge enroll(in=a) calendar(in=b); by patient dateassigned; if a and b; run;

Jagadishkatam · ‎04-21-2020

you can try something as below without use of any pipe symbol 1) use the x command with unix commands like du -h with the path of the directory for which we need to identify the size and also direct the size of directory to a file txt file with symbol >. 2) import the txt file with the filesize 3) use scan function to get the size into a separate variable. x "du -h ¬path > ¬path/text.txt"; proc import datafile='¬path/text.txt' out=have dbms=dlm replace; getnames=no; run; data want; set have; size=scan(var1,1,'/'); run;

Jagadishkatam · ‎04-21-2020

Another issue with the code is when we call the macro variable please call in double quotes and not single quote. In the code the macro variable is called in single quote due to which it will not resolve. Try calling the macro variable with double quotes. gg= '&giorno.';

Jagadishkatam · ‎04-21-2020

at the moment since there are no matching values the macro returns a dataset with zero observations. so please update the macro variables values to below and run the macro so it returns a dataset with 4 observations. %let smq=Anaemia|Diarrhoea|Insomnia;

Jagadishkatam · ‎04-21-2020

please try the below code **********what I have**********; data have; input subjid $ 1-7 aeseq 8 aestdtc $ 10-19 AEDECOD $ 20-57; cards; 01-004 1 2018/10/8 Anaemia 01-004 2 2018/10/8 Hyperkalaemia 01-004 3 2018/10/8 Peritoneal dialysis complication 01-006 1 2018/11/27 Blood phosphorus increased 01-007 1 2018/12/18 Faeces discoloured 01-016 1 2019/3/26 Diarrhoea 01-016 2 2019/3/29 Diarrhoea 01-018 1 2019/4/16 Arteriovenous fistula occlusion 01-018 2 2019/3/13 Faeces discoloured 01-018 3 2019/4/16 Hyperparathyroidism 01-018 4 2019/4/24 Rash 01-020 1 2019/3/19 Pruritus generalised 01-031 1 2019/6/13 Constipation 01-032 1 2019/7/20 Mouth ulceration 01-033 1 2019/8/12 Herpes zoster 01-037 1 2019/8/8 Vertigo 01-040 1 2019/8/9 Diarrhoea 01-040 2 2019/8/30 Insomnia 01-042 1 2019/9/11 Faeces discoloured 01-043 1 2019/9/11 Faeces discoloured ; run; ***here just list three kinds of smq to test the code; %let smq=anal fissure haemorrhage|anal haemorrhage|Anal ulcer haemorrhage; ***find the smq in the AEDECOD; %macro find_smq(in, out); data &out; set &in; if prxmatch("m/&smq/oi",aedecod) then aesifl='Y'; if AESIFL="Y"; run; %mend; %find_smq(have, want);

Jagadishkatam · ‎04-20-2020

please try %let v1 = 10; %let v2 = 15; %let v3 = 13; data z; input Var$ value; cards; a 20 b 17 c 30 ; proc transpose data=z out=z1; id var; var value; run; %macro test; data z2; set z1; array diff{3} diff1-diff3; array vars{3} a b c; %do i = 1 %to 3; diff(&i) = vars(&i)-&&v&i; %end; run; %mend; %test;

Jagadishkatam · ‎04-20-2020

please try the below code without the proc rank data have; input Variable1 Variable2 ; cards; 10 100 20 100 20 200 30 100 ; proc sort data=have; by Variable1 Variable2; run; data want; set have; by Variable2 notsorted; retain rank; if first.Variable2 then rank=1; else rank+1; run;

Jagadishkatam · ‎04-20-2020

in your code 'from' used twice , remove one 'from' try this proc sql; select acctno,trnsdt,max(trnsamt) as max from customer1 group by acctno,trnsdt;

Jagadishkatam · ‎04-20-2020

please try the below code data have; input Name$ Report_Date:ddmmyy10.; format Report_Date date9.; vars=1; cards; A 04/02/2020 B 04/02/2020 C 04/02/2020 D 04/02/2020 B 4/3/2020 C 4/3/2020 D 4/3/2020 E 4/3/2020 ; proc sort data=have; by name; run; options missing=0; proc transpose data=have out=want; by name; id Report_Date; var vars; run;

Re: 2023 Customer Awards: WCG Clinical Endpoint Solutions - Visual Sto...

Re: next date as end date by subject

Re: next date as end date by subject

Re: Fill in missing IDs

Re: Help with charts - clustered bar graph (?)

Re: SGplot x axis ticks without lumping or losing data

Re: Proc transpose help

Re: Remove x axis percent values in proc sgplot

Re: defining before and after dates using changing dates

Re: unending lines in the series plot of proc template

Re: Remove x axis percent values in proc sgplot

Re: How to remove words in a column by another column values

Re: Assign values to a new var by 1st valid value of another var for a...

Re: Unicode for superscript b

Re: remove words from string if the word length is lower than 4

Re: SAS advanced Guide Chapter 1 quiz Q7

Re: Extract VARIABLE NAME and concatenate with other variable names ba...

Re: How to find the week number of a month?

Re: How to find the week number of a month?

Re: Removing quotation marks

Re: Error in creating macro vars

Re: Can I create an add a suffix to a pre-defined array?

Re: distinct values of macro varaible (vector)

Re: Long to wide format

Re: hyperthesis test in two blank column return true

Re: character YYMMDD10 to DATE9

Re: Join two tables together based on similar but not equal columns in...

Re: Size of a directory

Re: IF condition in a 'call symput'

Re: how to find whether string1 is in the string2 or not?

Re: how to find whether string1 is in the string2 or not?

Re: Calculations in array with macro variables

Re: Using PROC RANK for Groups of the Same Variable

Re: Proc sql error , ERROR: File WORK.FROM.DATA does not exist.

Re: Transpose with Dummy Coding