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: 
mnjtrana
‎02-02-2023
  • 87 Posts
  • 117 Likes Given
  • 4 Solutions
  • 13 Likes Received

Re: Insufficient memory log error - identify what causes it

by Pyrite | Level 9 in SAS Programming
‎01-12-2017 04:15 AM
‎01-12-2017 04:15 AM
What proc are you running or is it datastep? Please provide the logic where you encountered the issue.   You can also try checking what's your memsize setting at your end. You can try increasing the memsize and see if that works for you.   options memsize=max;   Cheers from India ! Manjeet   ... View more

Re: How to append the data from two datasets vertically in SAS?

by Pyrite | Level 9 in SAS Programming
‎01-12-2017 01:52 AM
‎01-12-2017 01:52 AM
  Just merge them, without any by statement.   data want; merge data1 data2; run;   ... View more

Re: Help in complete steps to schedule a sas program in unix ?

by Pyrite | Level 9 in Administration and Deployment
‎01-12-2017 01:40 AM
1 Like
‎01-12-2017 01:40 AM
1 Like
Crontab can be used to schedule jobs in Unix via Unix SAS. you can schedule in crontab without creating the executable as well. you can mention the physical path of your program to be run.   To access crontab login to Unix and type crontab -e (Edit mode). This is a VI Editor. Press Esc Key and I for insert. Press Esc Key and x to delete.   Syntax for crontab is *    *    *    *    *  command to be executed ┬    ┬    ┬    ┬    ┬ │    │    │    │    │ │    │    │    │    │ │    │    │    │    └───── day of week (0 - 6) (Sunday=0 ) │    │    │    └────────── month (1 - 12) │    │    └─────────────── day of month (1 - 31) │    └──────────────────── hour (0 - 23) └───────────────────────── min (0 - 59)     for example: 05 * * * 0-6 nohup  /SAS Installation Path/ /my progam/ss.sas   This would run the program every week day at after 5 mins .     ... View more

Re: creating view in proc sql without the creation in work of the corr...

by Pyrite | Level 9 in SAS Procedures
‎01-12-2017 01:25 AM
‎01-12-2017 01:25 AM
You can write the sas view definitions to physical text files and then include the same in your code when required.   Below is one such example, you need to trim it as per your scenario.   filename sasview "c:\users\cxx\desktop\views.txt"; DATA _NULL_; set viewdef end=last; i=1; do while(i=100); i+1; file sasview mod; put 'proc sql;'; put 'create view ' viewname&nb 'as select'; put 'from ' col_name; put ' group by' grp_naame ';'; put 'order by' orderby_stat; put ';'; put 'quit;'; end; run; %inc sasview; ... View more

Re: FILENAME PIPE & X commands

by Pyrite | Level 9 in SAS Programming
‎01-10-2017 11:54 PM
‎01-10-2017 11:54 PM
I didn't actually got what you mant by the context.   I ran the code and i am seeing the file in log as:   09/06/2011  16:21            77,974 Garant - tilv‘kst - 2011.egp   Howver the actual file name was: Gamt - trivækst - 2011.egp Its different, Please suggest what to do.  ... View more

FILENAME PIPE & X commands

by Pyrite | Level 9 in SAS Programming
‎01-10-2017 06:33 AM
‎01-10-2017 06:33 AM
Hi ALL,   I am trying to rename one filr in my sas program using the X command. The file name contains some speical character and spaces? However the file is not getting renamed. I am using SAs 9;.4   options noxwait; X "RENAME e:\data\Playground\Manjeet\SAS_EG\Bank42\Gamt - trivækst - 2011.egp F345.egp"; I also tried, but no luck. Can any one suggest any other idea to rename the file.   X 'RENAME "e:\data\Playground\Manjeet\SAS_EG\Bank42\Gamt - trivækst - 2011.egp" "F345.egp"';   Thanks in advance!   Manjeet ... View more

Re: Doubt in Trim portion in the below code

by Pyrite | Level 9 in SAS Programming
‎01-09-2017 03:16 AM
‎01-09-2017 03:16 AM
do you have doubt in below statement: SUBSTR(TRIM,1,2) = SUBSTR(SCD(IS),2,2);   If yes, here, TRIM is a variable and you are replacing its first 2 bytes from he SCD array ... View more

Re: Transpose

by Pyrite | Level 9 in SAS Programming
‎01-09-2017 01:35 AM
‎01-09-2017 01:35 AM
Don't you think, this is very same as your other post, - Summary function https://communities.sas.com/t5/Base-SAS-Programming/Summary-function/m-p/323259#M71628   Can you please delete one of them, they are duplicate.   Thanks, Manjeet ... View more

Re: Assigning values to a variables based on recent visitnumber

by Pyrite | Level 9 in SAS Programming
‎01-09-2017 01:10 AM
1 Like
‎01-09-2017 01:10 AM
1 Like
  Hey,   you can use the below code to populate the recent visit on the unscheduled visits.   data have; length date 8 visit $12; informat date yymmdd10.; input id $ period $ date $ visit $ visitnum ; datalines; 1 period1 2015-06-02 scheduled1 1 1 period1 2015-06-07 scheduled2 2 1 period1 2015-06-23 scheduled3 3 1 period1 2015-06-17 unscheduled 99 run; proc sort data = have; by id period date visitnum; run; data need(drop=a); set have; format date ddmmyyd10.; retain avisitnum; by id period date visitnum; a = avisitnum; if first.period then avisitnum=1; else avisitnum+1; if visitnum=99 then avisitnum=a; run;   hope this helps! Manjeet ... View more

Re: concatenate two variables

by Pyrite | Level 9 in SAS Programming
‎01-08-2017 11:40 PM
‎01-08-2017 11:40 PM
Same solution as @LaurieF ... View more

Re: Impact of sas configration on some sas program

by Pyrite | Level 9 in SAS Programming
‎01-08-2017 11:37 PM
‎01-08-2017 11:37 PM
Hi,   Creating a sas program with name- autoexec.sas should not be a problem. the file -autoexec.sas that sas runs automatically is defined by the administrator and it's reference is there in sas, however the file you will create won't be run automatically, unless you want it to.   We are also using one such autoexec.sas which we have created for one specific project and run it manually, before you we want to get it to that project.   Hope that helps!   Thanks, Manjeet ... View more

Re: Text File Creation in DI

by Pyrite | Level 9 in SAS Programming
‎01-08-2017 11:31 PM
‎01-08-2017 11:31 PM
Thanks, you are right. ... View more

Re: Text File Creation in DI

by Pyrite | Level 9 in SAS Programming
‎01-06-2017 07:28 AM
1 Like
‎01-06-2017 07:28 AM
1 Like
Hey,   If i understood correctly, you want to ass header and footer to your file.   You can use the FILE and put statement to write the header in the file and you can use the below code to write to the file. But you need to remove the REPLACE option, as that would delete your file(and the header too).   Once the file is exported through proc export, you can open the file again and using option- MOD( its opens the file and append contents to the end of the file), See an example below:   DATA _null_; file out mod; put "------your footer here ----"; run;     ... View more

Re: SAS LOG

by Pyrite | Level 9 in SAS Programming
‎01-06-2017 04:48 AM
‎01-06-2017 04:48 AM
The SAS log is a record of everything you do in your SAS session or with your SAS program. the SAS log messages may begin with the words NOTE, INFO, WARNING, ERROR, or an error number, and they may refer to a SAS statement by its line number in the log.   For more info on SAS log and ways to supress some of the notes/log statements, you can refer-  https://v8doc.sas.com/sashtml/lrcon/z0998454.htm ... View more

Re: Timestamp Manipulation

by Pyrite | Level 9 in SAS Programming
‎01-05-2017 02:16 AM
‎01-05-2017 02:16 AM
@ankit___gupta   You again missed the call symput. try this:   %Let date1= "05JAN2017:09:58:57.822"dt; %Let date2=; data _null_; date2 = &date1 -10; call symput ('date2',date2); run; %put &date2; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-02-2023 04:47 AM
Likes given to
Quick links