07-02-2019
Vince28_Statcan
Quartz | Level 8
Member since
07-11-2013
- 338 Posts
- 11 Likes Given
- 1 Solutions
- 199 Likes Received
-
Latest posts by Vince28_Statcan
Subject Views Posted 4713 08-22-2014 01:20 PM 4823 05-06-2014 09:00 AM 1081 04-11-2014 09:48 AM 5922 03-26-2014 01:26 PM 5922 03-26-2014 01:23 PM 1923 03-24-2014 12:55 PM 10054 02-28-2014 03:50 PM 2778 02-28-2014 03:35 PM 2003 01-24-2014 01:26 PM 1753 01-24-2014 12:50 PM -
Activity Feed for Vince28_Statcan
- Got a Like for Re: Make first letter capital only. 09-19-2022 05:19 AM
- Got a Like for Re: Attempt to %GLOBAL a name (NAME) which exists in a local environment.. 06-12-2022 10:01 AM
- Got a Like for Re: Make first letter capital only. 06-25-2020 07:11 PM
- Got a Like for Re: Unable to export data to local folders (PROC EXPORT in SAS EG). 01-20-2020 06:55 AM
- Got a Like for Re: Make first letter capital only. 10-17-2017 03:30 AM
- Got a Like for Re: Removing duplicate pairs i.e keeping only unique values that weren't part of a pair. 12-29-2016 03:33 PM
- Got a Like for Re: Converting date from " DATETIME20." format to SAS date format. 09-01-2015 04:24 AM
- Got a Like for Re: finding the nearest value to zero. 09-01-2015 04:24 AM
- Got a Like for Re: Proc Lifetest Output : is there a ODS Table for Deciles (10%, 20%, etc.) like there is for Quartiles ?. 09-01-2015 04:24 AM
- Got a Like for Re: Extracting Data From Webpages. 09-01-2015 04:24 AM
- Got a Like for Re: Modify string in HTML file. 09-01-2015 04:24 AM
- Got a Like for Re: Invalid argument to function MONTH ?. 09-01-2015 04:24 AM
- Got a Like for Re: how to read numbers of the form '00000-34.56' ?. 09-01-2015 04:24 AM
- Got a Like for Re: how long to be a certified beginner in SAS ?. 09-01-2015 04:24 AM
- Got a Like for Re: How to complete missing values with a specific condition. 09-01-2015 04:24 AM
- Got a Like for Re: Data transformation. 09-01-2015 04:24 AM
- Got a Like for Re: Data transform. 09-01-2015 04:24 AM
- Got a Like for Re: why " if _n_ =1 or _n_=last;" works but " if _n_ in (1, last);" doesn't?. 09-01-2015 04:24 AM
- Got a Like for Re: loop on multiple tables. 09-01-2015 04:24 AM
- Got a Like for Re: Macro for converting char variables to numeric with their labels. 09-01-2015 04:24 AM
-
Posts I Liked
Subject Likes Author Latest Post 3 3 1 1 5 -
My Liked Posts
Subject Likes Posted 1 07-31-2013 09:51 AM 1 11-28-2013 09:08 AM 3 08-01-2013 04:01 PM 1 11-15-2013 01:26 PM 3 07-12-2013 12:46 PM
07-26-2021
04:24 PM
There are several SAS Global Forum papers on dosubl:
https://www.lexjansen.com/search/search_sgf.php?q=dosubl
Start with papers by Rick Langston and Mike Rhoads, in addition to the paper by Jason Secosky that has already been mentioned.
https://support.sas.com/resources/papers/proceedings13/032-2013.pdf
https://support.sas.com/resources/papers/proceedings12/004-2012.pdf
... View more
08-27-2020
03:13 PM
Hi Vince, I found your post from 7years ago. Your method to convert week number to start date seems very cool, but I tried and SAS gave me error message...do you have any tips to fix the error? it is at the part of the second bracket after z2. Thank YOU! weekstartdate=input(put(yearnum, 4.)||"W"||put(weeknum,z2.))||"01", weekv9.);
... View more
09-04-2018
05:49 AM
1 Like
try this - data test;
fname="james";
lname="Bond";
name=propcase(catx('',fname,lname),'-');
run;
... View more
07-11-2018
10:33 AM
%macro fun;
%do i=1 %to 2;
data _null_;
set lib.EMPLOYEE (firstobs=&i obs=&i);
putlog " I want to print EMP_ID and EMP_NAME value for observation 1 and 2";
run;
%end;
%mend fun;
%fun; This is good example ....But how do I print that observation ? For eg. if dataset EMPLOYEE have EMP_ID and EMP_NAME columns then for that observation I want to print EMP_ID and EMP_NAME
... View more
08-29-2017
07:24 PM
Hi, Patrice In my experience, the easiest thing to do is work with Beyond 20/20 to get the .csv containing the data. To do that, I had to use another computer because it did not work on my Mac. You can also try to contact Statistics Canada directly and ask for the information. As long as it is something they already have, they are very quick to answer. I solved my problem with the data they sent, and then I figured out how to export from Beyond 20/20. So, I can tell you that both paths can work. Good luck! Ivan
... View more
12-12-2016
10:11 AM
This helped me. Thank you.
... View more
05-03-2016
06:58 PM
thanks for the post!
I like this as a basic template:
proc print data=SASHELP.VCOLUMN NOOBS;
VAR libname memname memtype name type length label format informat;
where label like "myField" AND LIBNAME='MyLibName_or_WORK' AND memname LIKE "%MyDataSetPattern%";
run;
... View more
07-21-2015
01:22 PM
It makes sense is a tried to explain the network visibility and permissions are not functioning because, root cause: your are running the spawners by the local-system account. LocalSystem Account (Windows) (microsof descrtption) It has for normal usage far too high credentials. And another The LocalSystem Account (Windows) - About the Local System Account/Computer$ in Configuration Manager "The Local System account does not have any rights to access the network. When network access is necessary, Local System uses the account Domain\computername$." Now see the iwa and requirement with trusts for networkresources SAS(R) 9.4 Intelligence Platform: Security Administration Guide, Second Edition
... View more
05-15-2014
09:05 AM
Jaap, Thanks for your thoughts. I tried some of your suggestions, -Bill
... View more
03-26-2014
08:35 PM
Should mention that the single quote does not work for Apple OSX version of MS Excel 2008. Richard
... View more
01-18-2014
01:56 PM
What do you want it to do? Your choice of variable names makes it look like you want to create FORMAT and apply it to your data. data dataset1; input value @@; cards; 1 23 3 5 15 run; data dataset2 ; input label $ start end ; cards; LOW 0 10 HIGH 10 100 run; data fmt ; retain fmtname 'DECODE' fmttype 'N'; set dataset2 ; run; proc format cntlin=fmt; run; data want; set dataset1; label = put(value,decode.); run; proc print; run; Obs value label 1 1 LOW 2 23 HIGH 3 3 LOW 4 5 LOW 5 15 HIGH
... View more
01-06-2014
12:32 PM
1 Like
As PG has examplified by-group processing, I will only answer the hash portion. The SAS Hash Object is a fairly recent feature. It is essentially a "lookup table" that is usable through the data step. The strength of Hashing for the specific question you've asked is that if your data wasn't already sorted according to your by-group, then a hash solution alleviates the need to pre-sort (which often is the lenghtiest part of a simple by-group process). However, the hash object is fully held in memory throughout the data step so if you have a very, very large volume of data, it is possible to face an "out of memory" error with hash solutions. Syntaxically, it also looks confusing at first glance but one gets familiar with the programing syntax quite fast. Since you mentioned you were fairly new to SAS, it is probably best to get accustomed at least to by-group processing before looking at hashing. Hashing can achieve far more than just this but since it is memory-limited, it is wiser to learn the processing tools that should work "all around". So I will refrain from providing a hash solution. There are plenty of similar examples around these forums anyway and in various SGF papers. As to add one element to Keith's description above, procedures have various built-in output. Unless tasked otherwise, the output statement in proc summary outputs outputs many more statistics than just maximum. Using output statement options allows you to control that default behaviour. See proc summary -> output statement documentation (it will actually point you towards proc means' output statement as they have the same options). You will find the specific explanation for the MAXID option there and how it applies the max on X, by class HH_NO but will actually output PI_No and X as the identifier for that maximum point found. Vincent
... View more
01-03-2014
09:06 AM
building upon appropriate input is typically better than the first solution as multiplying char by numeric issues a warning in the log and those should be avoided for any large process. could you provide a datalines example with data that does not get input properly by solution #2? Odds are you can apply some simple string function to WERT inside the input function to make it inputable appropriately. Likely strip to remove blanks or possibly the same solution you've mentionned using an alternative input format after removal of periods.
... View more
01-03-2014
04:00 PM
Hi Vince, Actually when I read documentations about proc template I also had similar feeling about it, but I've just spent hour on briefly overview proc template possibilities so I couldn't be sure that it can't easily handle my task, that's why I actually asked for help here. So, if not only me considered that for this task data step is probably ok solution for SAS 9.1.3 - I'll choose this variant:) Thanks one more time for quick and clever feedback's!
... View more