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: 
Srigyan
‎02-08-2022
  • 130 Posts
  • 19 Likes Given
  • 2 Solutions
  • 0 Likes Received

Re: slow proc sort and code

by Quartz | Level 8 in SAS Programming
‎08-27-2019 11:53 AM
‎08-27-2019 11:53 AM
Thanks for putting your effort. I could have chose only one code as solution.  ... View more

Re: Default noprint for all possible places

by Quartz | Level 8 in SAS Programming
‎08-23-2019 07:01 AM
‎08-23-2019 07:01 AM
I put this in the begning of my project and I got an error saying   ods close all; ERROR 180-322: Statement is not valid or it is used out of proper order. ... View more

Default noprint for all possible places

by Quartz | Level 8 in SAS Programming
‎08-23-2019 06:36 AM
‎08-23-2019 06:36 AM
I am trying to set a noprint as default value in my entire project. Is there any option from where I can set the noprint option as default for all possible place. like proc content, proc means, proc sql etc. ... View more

save sas log externally and see it in log window

by Quartz | Level 8 in SAS Programming
‎08-21-2019 08:00 AM
‎08-21-2019 08:00 AM
I am using following code to save log proc printto log="C:/log_test.lst"; run; data dsn; input patid implants; datalines; 1 3 1 1 1 2 ;run; proc printto log=log;run; Though I get a log in c drive but log now get desappeared from log window. Is there any way I can see the log in log window also and get one extracted as well. ... View more

slow proc sort and code

by Quartz | Level 8 in SAS Programming
‎08-16-2019 06:05 AM
‎08-16-2019 06:05 AM
I have following timeseries data     Product DATE price A 01-Jan-18 10 A 02-Jan-18 10 A 03-Jan-18 10 A 04-Jan-18 10 A 05-Jan-18 10 A 06-Jan-18 10 A 07-Jan-18 3 A 08-Jan-18 11 A 10-Jan-18 11 B 15-Jan-18 15 B 16-Jan-17 15 B 17-Jan-17 15 B 20-Jan-17 15 B 21-Jan-17 19 B 22-Jan-17 19 B 23-Jan-17 19 B 24-Jan-17 18      Code   data Table1; input product $ date date9. price; format date date9.; datalines; A 01-Jan-18 10 A 02-Jan-18 10 A 03-Jan-18 10 A 04-Jan-18 10 A 05-Jan-18 10 A 06-Jan-18 10 A 07-Jan-18 3 A 08-Jan-18 11 A 10-Jan-18 11 B 15-Jan-18 15 B 16-Jan-17 15 B 17-Jan-17 15 B 20-Jan-17 15 B 21-Jan-17 19 B 22-Jan-17 19 B 23-Jan-17 19 B 24-Jan-17 18 ; run; I wanted an ouput like this       Product Start_date End_date Price A 01-Jan-18 06-Jan-18 10 A 07-Jan-18 07-Jan-18 3 A 08-Jan-18 08-Jan-18 11 A 10-Jan-18 10-Jan-18 11 B 15-Jan-18 17-Jan-17 15 B 20-Jan-17 20-Jan-17 15 B 21-Jan-17 23-Jan-17 19 B 24-Jan-17 24-Jan-17 18 I am running following code     data temp; set table1; by product price notsorted; retain grp; k=dif(date); if first.product then grp=1; else if k ne 1 or first.price then grp+1; drop k; run; proc sql; create table want as select distinct product,min(date) as Start_date format=date9.,max(date) as End_date format=date9., price from temp group by product, grp order by product, start_date; quit; My table1 had more than 80m data, my code run fine and give the output I am looking for but it is taking enormous amount of time. more than 7 & 8 hours.   Is there any way I can optimise it.     ... View more

Re: SAS 9.4 schedule

by Quartz | Level 8 in SAS Programming
‎08-14-2019 05:52 AM
‎08-14-2019 05:52 AM
above description expect that user can save login/Password for SAS. Unfortunetly SAS 9.4 install on server side and the Admin don't allow us to save SAS login password. Challenge is how can I save/enter the password when SAS get started.   I think there should be some way to do through VB Script or Java script which we can use to enter login password while running. ... View more

Re: SAS 9.4 schedule

by Quartz | Level 8 in SAS Programming
‎08-09-2019 10:52 AM
‎08-09-2019 10:52 AM
can you share any programming which can actually help. Just to confirm this is asking for SAS login password not window login password. ... View more

SAS 9.4 schedule

by Quartz | Level 8 in SAS Programming
‎08-09-2019 10:34 AM
‎08-09-2019 10:34 AM
I need to schedule a SAS 9.4 code through window scheduler. When I put sas code in window scheduler then it open the sas but it ask for login and password for SAS 9.4 and some one have to enter this manually. Can some one help if there is any way that this login & password go by itself in it and it run all the code in sas 9.4 project. ... View more

Re: vba go to in sas

by Quartz | Level 8 in SAS Programming
‎07-30-2019 09:21 AM
‎07-30-2019 09:21 AM
My Current version: 9.04.01M3P062415. Will it work here or do we have any other alternative ... View more

vba go to in sas

by Quartz | Level 8 in SAS Programming
‎07-30-2019 08:35 AM
‎07-30-2019 08:35 AM
I am writing an automated SAS process where  It checks teradata first and if the data is available in the table then only run the code in program otherwise it jump on a given location like in VBA. if <condition>=true then do: process: else goto gg: statement,,, statement,,, statement,,, statement,,,statement,,, gg: code resume from here do we have same thing in SAS... ... View more

find more than one value

by Quartz | Level 8 in SAS Programming
‎07-24-2019 12:00 PM
‎07-24-2019 12:00 PM
I am trying to find following value in  ('BLACK','BF','CYBER','PRE WEEK') in event_name and wrote the code if find(upcase(event_name),('BLACK','BF','CYBER','PRE WEEK')) AND find(upcase(season ),'AW') then EVENT_FLAG='CLEARANCE'; its showing following error   32 if find(upcase(event_name),('BLACK','BF','CYBER','PRE WEEK')) AND find(upcase(season ),'AW') then EVENT_FLAG='CLEARANCE'; _ _ 79 22 200 ____ 72 ERROR 79-322: Expecting a ). ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, ;, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOT, NOTIN, OR, THEN, ^, ^=, |, ||, ~, ~=. ERROR 200-322: The symbol is not recognized and will be ignored. ERROR 72-185: The FIND function call has too many arguments. Can some one help so I can search all these string. ... View more

Mosaic plot with data label

by Quartz | Level 8 in SAS Programming
‎07-03-2019 07:21 AM
‎07-03-2019 07:21 AM
I am running following code.   ods graphics on; proc freq data=sashelp.heart order=freq ; tables smoking_status*weight_status / plots=mosaic(square ) ; run; ods graphics off; I am getting mosaic plot but i dont get a data label i.e.what % heavy has and what % is non-smoker has, is there any option i can add data label.     ... View more

rank for group

by Quartz | Level 8 in SAS Programming
‎07-02-2019 05:14 AM
‎07-02-2019 05:14 AM
I have following tables.   data Table1; input product $ start_date :date7. end_date:date7. Price; format start_date end_date date9.; datalines; p1 01Jan17 18Jan18 15 p1 19Jan18 15Jul18 30 p1 16Jul18 31Mar19 24 p2 08Jan17 31Dec17 17 p2 01Jan18 15Mar18 19 p2 26Jul18 31Mar19 18 ; Product sd ed price p1 01-Jan-17 18-Jan-18 15 p1 19-Jan-18 15-Jul-18 30 p1 16-Jul-18 31-Mar-19 24 p2 08-Jan-17 31-Dec-17 17 p2 01-Jan-18 15-Mar-18 19 p2 26-Jul-18 31-Mar-19 18   I wanted to rank product, means p1 is rank 1 and p2 is rank 2.   Product sd ed price Rank p1 01-Jan-17 18-Jan-18 15 1 p1 19-Jan-18 15-Jul-18 30 1 p1 16-Jul-18 31-Mar-19 24 1 p2 08-Jan-17 31-Dec-17 17 2 p2 01-Jan-18 15-Mar-18 19 2 p2 26-Jul-18 31-Mar-19 18 2 ... View more

max min & median for date

by Quartz | Level 8 in SAS Programming
‎07-01-2019 07:34 AM
‎07-01-2019 07:34 AM
I have following table;   data Table1; input product $ start_date :date7. end_date:date7. Price; format start_date end_date date9.; datalines; p1 01Jan17 18Jan18 15 p1 19Jan18 15Jul18 30 p1 16Jul18 31Mar19 24 p2 08Jan17 31Dec17 17 p2 01Jan18 15Mar18 19 p2 26Jul18 31Mar19 18 ; i want to run following codes on this tables:   proc tabulate data=Table1; var start_date end_date; table start_date end_date, n nmiss (min max median)*f=mmddyy10. range; run; in var and table option I am choosing variable manual, I want this code to choose all date variable itself. i.e. I don't need to mentioned date variable myself, program should choose all the variable in date format and run this code on date variable only. ... View more

macro with % and Macro without % different

by Quartz | Level 8 in SAS Programming
‎06-21-2019 09:18 AM
‎06-21-2019 09:18 AM
I have two codes   Code-1   %macro Zero (Input=, Output=); data &Output.; set &Input.; array change _numeric_; do over change; if change=. then change=0; end; run ; %mend; Code-2   %macro Zero (Input=, Output=); data &Output.; set &Input.; array change _numeric_; %do %over change; %if change=. %then change=0; %end; run ; %mend;  the only difference is % sign with loop in code-2. I get the same output. Question is: 1) Why and where % sign is require for macro. 2) if the output is same in both the query why do we need % sign for loop here ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-08-2022 02:23 PM
Likes given to
Quick links