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: 
mjack
‎11-30-2016
  • 42 Posts
  • 2 Likes Given
  • 0 Solutions
  • 1 Likes Received

SAS Table logging

by Calcite | Level 5 in SAS Programming
‎07-06-2015 08:01 AM
‎07-06-2015 08:01 AM
Hi, I have a SAS dataset in Mainframe. I want to track who all are accessing this dataset. Is there a simple way to achieve his? ... View more

sas mainframe

by Calcite | Level 5 in SAS Programming
‎06-23-2015 05:40 AM
‎06-23-2015 05:40 AM
Hi, How can one read data from SAS table present in Mainframe from Enterprise Guide? Thanks! ... View more

Re: sas 9.1 to 9.4

by Calcite | Level 5 in Administration and Deployment
‎09-05-2014 04:37 AM
‎09-05-2014 04:37 AM
Thanks Jaap, for your reply. There is a confusion. You mentioned about 'the code should move unchanged' and also you have mentioned about need for 'release management'. There are ETL jobs and then there are executables derived from them. From 'the code should move unchanged' what I understand is that the jobs will not require reruning to generate executables and so both jobs and their executables will move as they are(unchanged)? From 'need for release management' the understanding is that all the jobs will have to be rerun(just rerun and no addition/modification/removal anywhere) and their executables tested(in new version) and then migrated to production(new version)? Also there will be huge data in SPD clusters. Do you think that data structures for all clusters/tables require recreation and reloading or they are just moved to new environment? Thks ... View more

sas 9.1 to 9.4

by Calcite | Level 5 in Administration and Deployment
‎09-04-2014 05:48 AM
‎09-04-2014 05:48 AM
Hi Experts, While version upgrade of SAS9.1 to SAS9.4 , I guess for programs/metadata/applications/jobs 1) all the ETL jobs will have to be compiled again and tested in TEST environment and then moved to production. 2) all Info maps can be directly migrated (or do they need to be created again?) 3) all SAS Web report Studio reports can also be migrated directly (or do they need to be created again?) 4) the table data can also be migrated directly? Can some expert give some suggestions on the approach to be taken with programs/metadata/applications/jobs/data  during a version upgrade? Thks ... View more

Re: comma

by Calcite | Level 5 in SAS Programming
‎07-31-2014 05:41 AM
‎07-31-2014 05:41 AM
yes , numx10.2 works thanks... ... View more

Re: comma

by Calcite | Level 5 in SAS Programming
‎07-31-2014 05:12 AM
‎07-31-2014 05:12 AM
Hi , My requirement is to have decimal replaced with comma. COMMA10,  will give comma after every 3 digits but my requirement is only one comma per number..  that is.., 33428778  shd be   33428778,00     and not   33,428,778 similarly 145.7   shd be     145,70 ... View more

comma

by Calcite | Level 5 in SAS Programming
‎07-31-2014 04:48 AM
‎07-31-2014 04:48 AM
Hi, need help. I need decimals to be replaced by comma in numbers. for e,g,   145.3   as  145,30      33428778  as    33428778,00 how to code this? ... View more

MDDS

by Calcite | Level 5 in SAS Programming
‎12-31-2013 02:20 AM
‎12-31-2013 02:20 AM
In all databases (RDBMS, MDDS(multidimensional database)), there are tables with rows and columns... Then how data is stored in Cubes for MDDS(multidimensional database)..   This I am very confused? I can run a query against a table... but how can I run query against a cube? Can any expert help explain this...with some simple examples... ... View more

Re: SAS SPD Cluster table

by Calcite | Level 5 in SAS Programming
‎08-25-2013 03:47 PM
‎08-25-2013 03:47 PM
does anybody know where should I post this question to get the answer ? ... View more

SAS SPD Cluster table

by Calcite | Level 5 in SAS Programming
‎08-21-2013 06:13 AM
‎08-21-2013 06:13 AM
Hi Experts, IF a cluster member has been mistakenly deleted and is unrecoverable. Now when I try to run 'UNDO CLUSTER' command....  it gives error 'ERROR: Unable to complete CLUSTER UNDO on table ..tablename..' PROC SPDO LIBRARY = libname ; SET ACLUSER adminsp; CLUSTER UNDO tablename; quit; Is there any way that I can run successfully undo cluster.....   ? what should I do now?   Please help ... View more

Re: Tricky query

by Calcite | Level 5 in SAS Programming
‎07-23-2013 04:59 AM
‎07-23-2013 04:59 AM
Ksharp, u r great! it works ! Thanks! ... View more

Tricky query

by Calcite | Level 5 in SAS Programming
‎07-23-2013 04:01 AM
‎07-23-2013 04:01 AM
Hi Experts, There is a challenging query for me though may not be for SAS experts... proc sql; create table tab1 as select objects, count(*) as xxxxxxxxxxx  from tab2 WHERE      DATESAS >= intnx('month',today(),-1,'begin') and      DATESAS <= intnx('month',today(),-1,'end') group by objects; quit; In place of xxxxxxxxx I need  to display it as Jun_Count ( when I execute this query in July...) and when I execute this query in August, it should display  Jul_Count  and so on... Experts , pls help! ... View more

Re: proc export

by Calcite | Level 5 in SAS Programming
‎06-25-2013 03:14 AM
‎06-25-2013 03:14 AM
Thanks Ksharp ... View more

proc export

by Calcite | Level 5 in SAS Programming
‎06-24-2013 12:54 AM
‎06-24-2013 12:54 AM
Hi Experts, The csv file created using below proc export shows only 65356 rows.. when opened in excel... proc export data=data1  outfile='/filepath/filename.csv'; Is there a way to show more than 65356 rows? ... View more

Proc freq

by Calcite | Level 5 in SAS Programming
‎05-24-2013 10:26 AM
‎05-24-2013 10:26 AM
Hi Experts, Using proc freq,   how can I achieve the results achieved by the following queries : proc sql;      select count(distinct(columnname))  from datasetname where columnname > 6   and columnname < 100; quit; proc sql;      select columnname, count(*) from datasetname where columnname > 6   and columnname < 100; quit; Because when I run above sqls I get   'ERROR: SPDS Sql Passthru Error.' Pls help... ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-30-2016 01:39 AM
Likes given to
View All
Likes from
View All
Quick links