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: 
Jagadishkatam
  • 2,054 Posts
  • 499 Likes Given
  • 241 Solutions
  • 894 Likes Received

Re: To run multiple programs by a single code

by Amethyst | Level 16 in SAS Programming
‎06-16-2020 06:37 AM
‎06-16-2020 06:37 AM
Instead of %include, you can use the batch file to run , please let me know if your sas session is in unix/linux ... View more

Re: How to display full markers in SAS GTL

by Amethyst | Level 16 in SAS Programming
‎06-16-2020 06:19 AM
‎06-16-2020 06:19 AM
If you are using the proc gplot then on the xaxis axis statement, use the offset = (3,0) option and check it resolves the issue. ... View more

Re: How to display full markers in SAS GTL

by Amethyst | Level 16 in SAS Programming
‎06-16-2020 06:05 AM
‎06-16-2020 06:05 AM
Could you please share the graph code which you used to generate this graph, it will help you to get better response. ... View more

Re: sas setting table in a loop

by Amethyst | Level 16 in SAS Programming
‎06-16-2020 05:57 AM
‎06-16-2020 05:57 AM
alternatively you can try the below code with do loop   data _null_; set test nobs=obs; call symputx("test"||strip(put(_n_,best.)),cats('test',date_loop)); call symputx("obs",strip(obs)); run; %put &test1 &test2 &obs; %macro test; data want; set %do i = 1 %to &obs; &&test&i %end;; run; %mend; %test; ... View more

Re: Conditional sum

by Amethyst | Level 16 in SAS Programming
‎06-15-2020 08:29 AM
‎06-15-2020 08:29 AM
Sum is the variable name , if we keep sum+value, it is do the summation in a cumulative way by retaining the values. So we do not have to retain the variable separately. ... View more

Re: Conditional sum

by Amethyst | Level 16 in SAS Programming
‎06-15-2020 08:21 AM
‎06-15-2020 08:21 AM
without the do loop you can try below code   data want; set have; sum+value; run; proc sort data=want; by descending sum value; run; ... View more

Re: Count all created/referenced tables in a SAS Program

by Amethyst | Level 16 in New SAS User
‎06-15-2020 08:18 AM
‎06-15-2020 08:18 AM
You can try to find the number of datasets being called, by searching the text starting with 'data' or 'set' and if proc sql is also used then try to search for text 'table as ' or 'from' because anything after these text will be a dataset name. Also, there is nothing like historical tables or simple tables in SAS, it depended on the data what you are analyzing, if your company data is old and that you are working on then it is called as historical tables ... View more

Re: Conditional sum

by Amethyst | Level 16 in SAS Programming
‎06-15-2020 08:06 AM
1 Like
‎06-15-2020 08:06 AM
1 Like
Alternatively try below code   data have; input VALUE; cards; 20 20 20 20 20 ; data want; do until(end); set have end=end; retain sum; sum+value; output; end; run; proc sort data=want; by descending sum value; run; ... View more

Re: How to pass a list of parameters recallig a %macro

by Amethyst | Level 16 in SAS Programming
‎06-15-2020 07:56 AM
‎06-15-2020 07:56 AM
you can try something as below   %macro newDates; data _null_; set have nobs=eob; call symputx("obs", eob); call symputx("ddata"||compress(put(_n_,best.)), "'"!!compress(put(VarDate,yymmdd10.),'-')!!"'"); call symputx("ddata_"||compress(put(_n_,best.)), "'"!!put(VarDate,yymmdd10.)!!"'"); call symputx("varnam"||compress(put(_n_,best.)), strip(VarName)); run; %do i= 1 %to &obs; %put ******* &&varnam&i.._TXT : &&ddata&i. ; %put ******* &&varnam&i.._DASH : &&ddata_&i.; %end; %mend; %newDates log     ... View more

Re: Calculations with lagged values in proc sql

by Amethyst | Level 16 in New SAS User
‎06-15-2020 07:05 AM
1 Like
‎06-15-2020 07:05 AM
1 Like
Please try below code   data T; input ID $ L M D ; Datalines; B 1 10 100 B 1 20 100 C 1 30 200 C 2 40 200 D 1 50 300 D 2 60 300 D 3 70 300 ; data want; set t; by id; la=lag(m); if first.id then la=.; if l=1 then want=d-m; else if l=2 then want=d-la; else want=m-d; run; ... View more

Re: Keep à column

by Amethyst | Level 16 in SAS Programming
‎06-15-2020 06:57 AM
‎06-15-2020 06:57 AM
Alternatively by proc contents as well you will know the column position and variable name as below   proc contents data=sashelp.class; run; ... View more

Re: Keep à column

by Amethyst | Level 16 in SAS Programming
‎06-15-2020 06:55 AM
‎06-15-2020 06:55 AM
Lets try to identify the columns name based on the column position, in your example we need to identify the first column so we need to use dictionary.columns as below so based on where varnum variable you will know the column orders and the first column will have varnum=1 and from the name column you will know the variable name to use further. Try this on you dataset   proc sql; create table want as select * from dictionary.columns where libname='SASHELP' and memname='CLASS'; run; ... View more

Re: Convert character as to date

by Amethyst | Level 16 in SAS Programming
‎06-15-2020 06:49 AM
‎06-15-2020 06:49 AM
Alternatively   data test; date="Mon, 15 Jun 2020"; date1=input(scan(date,2,','),anydtdte20.); format date1 date9.; run; ... View more

Re: How do i pick previous date value by ID

by Amethyst | Level 16 in SAS Programming
‎06-15-2020 06:43 AM
‎06-15-2020 06:43 AM
Please use the code as suggested by @Kurt_Bremser , but make an updated as suggested below   data want; set have; by id1; start_date = ifn(flag2=1 and start_date=.,lag(end_date),start_date); run; ... View more

Re: How do i pick previous date value by ID

by Amethyst | Level 16 in SAS Programming
‎06-15-2020 04:57 AM
‎06-15-2020 04:57 AM
Please try the below code   data want; set have; by id1 ; if not first.id1 then do; if start_date eq . and end_date eq . then start_date=lag(end_date); end; run; ... View more
Contact Me
Likes given to
Quick links