Author |
Message |
Topic: Browse SAS Dataset |
advoss
Replies: 3
Views: 2592
|
Forum: Application Programming Posted: Wed Dec 09, 2009 9:56 am Subject: Browse SAS Dataset |
If you have SAS/FSP licensed on the mainframe, you can start an interactive SAS session and use commands FSBROWSE or FSVIEW to look at the rows in the SAS library either one at a time (FSBROWSE) or se ... |
Topic: average length of variable records ? |
advoss
Replies: 5
Views: 3806
|
Forum: Utilities Posted: Wed Nov 18, 2009 12:22 pm Subject: average length of variable records ? |
Thank you. |
Topic: average length of variable records ? |
advoss
Replies: 5
Views: 3806
|
Forum: Utilities Posted: Wed Nov 18, 2009 9:48 am Subject: average length of variable records ? |
Frank, I like the simplicity of your solution, but, since it calculates an integer average, it truncates the answer. Is it possible to display the answer as a decimal answer, like 119.3? |
Topic: Query to pull data between two fiscal periods |
advoss
Replies: 4
Views: 1939
|
Forum: Database Posted: Tue Dec 04, 2007 10:23 am Subject: Query to pull data between two fiscal periods |
Are fiscal year and fiscal month numeric or character? I like Kolusu's idea, but I think if they are character, you would need a leading zero on the fiscal months that are less than 10, and then you ... |
Topic: SAS : How to compare value from 1 file & insert it in ot |
advoss
Replies: 2
Views: 1699
|
Forum: Application Programming Posted: Mon Nov 26, 2007 8:51 am Subject: SAS : How to compare value from 1 file & insert it in ot |
Here is another approach.
/* CODE TO GET THE LOATYPE AND LOA INDICATOR FROM ADF FILE */
/* CODE TO GET THE LOATYPEs WHERE LOA INDICATOR IS E */
/* (HERE LOAFILE WILL HAVE 2 VALUES OF 5A & ... |
Topic: SAS on mainframe |
advoss
Replies: 5
Views: 3285
|
Forum: Application Programming Posted: Wed Sep 12, 2007 11:31 am Subject: SAS on mainframe |
Vivek's answer is correct, but your solution is probably more obvious from a maintenance standpoint. If you had the misfortune of learning SAS prior to about version 8, Vivek's approach was the way t ... |
Topic: SAS on mainframe |
advoss
Replies: 5
Views: 3285
|
Forum: Application Programming Posted: Wed Sep 12, 2007 7:54 am Subject: SAS on mainframe |
Why not just do:
date _null_;
begn_date = intnx("MONTH",today(),0,"B"); /* get first day of current month */
FILE OUTFILE1 NOTITLES;
PUT @001 BEGN_DATE y ... |
Topic: Query for formatting the column |
advoss
Replies: 9
Views: 3722
|
Forum: Database Posted: Fri Aug 31, 2007 12:02 pm Subject: Query for formatting the column |
how about
select left(name,length(name)-1) as name,salary
from table;
or
select substr(name,1,length(name)-1) as name,salary
from table; |
Topic: FTP Issues with end of line |
advoss
Replies: 16
Views: 11617
|
Forum: Utilities Posted: Mon Feb 19, 2007 11:47 am Subject: FTP Issues with end of line |
I thought it was supposed to be \13\10 |
Topic: Concatenate strings and variables in CLIST |
advoss
Replies: 11
Views: 10467
|
Forum: TSO and ISPF Posted: Fri Feb 02, 2007 11:50 am Subject: Concatenate strings and variables in CLIST |
This works for me
SET STRING1 = ABC.SOURCE
SET RP = )
SET LP = &STR((
SET VARIABLE = MEMBER ... |
Topic: Sort/Utility Questions |
advoss
Replies: 13
Views: 21882
|
Forum: Mainframe Challenge Posted: Wed Aug 30, 2006 9:16 am Subject: Sort/Utility Questions |
Oops! I apologize; I did not read the challenge carefully enough.
Thank you. |
Topic: Sort/Utility Questions |
advoss
Replies: 13
Views: 21882
|
Forum: Mainframe Challenge Posted: Wed Aug 30, 2006 8:57 am Subject: Sort/Utility Questions |
Kolusu, it appears that your solution to number 4 prints all lines of each member of PDS starting at the third line. Don't you need a STOPAFT=? if you only want the third line? |
Topic: Replace EDIT command |
advoss
Replies: 6
Views: 2359
|
Forum: TSO and ISPF Posted: Mon Aug 14, 2006 10:48 am Subject: Replace EDIT command |
On the primary edit panel there is an option "Confirm Cancel/Move/Replace". Just deselect that option. |
Topic: File Match/Merge in SAS |
advoss
Replies: 4
Views: 2509
|
Forum: Application Programming Posted: Wed Jul 19, 2006 11:27 am Subject: File Match/Merge in SAS |
Why not use a merge? What are you looking for that it will not provide?
DATA COMBINE;
merge filein1(rename=(ID1=ID) in=in1)
filein2(rename=(ID2=ID) in=i ... |
Topic: How to get PDS member's User ID? |
advoss
Replies: 4
Views: 3099
|
Forum: TSO and ISPF Posted: Tue Jun 13, 2006 11:14 am Subject: How to get PDS member's User ID? |
Try using LMMLIST with the STATS option. |
|