MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 26 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Browse SAS Dataset
advoss

Replies: 3
Views: 2592

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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.
 
Page 1 of 2 Goto page 1, 2  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group