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: 
ZosTa
‎06-05-2019
  • 9 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Looking for a string

by Calcite | Level 5 in SAS Programming
‎10-17-2018 04:14 AM
‎10-17-2018 04:14 AM
Thank you everyone for your assistance, I used the index statement from RW9 and it works perfectly. ... View more

Re: Looking for a string

by Calcite | Level 5 in SAS Programming
‎10-17-2018 04:13 AM
‎10-17-2018 04:13 AM
The index worked perfectly, Thank you RW9 ... View more

Re: Looking for a string

by Calcite | Level 5 in SAS Programming
‎10-16-2018 08:13 AM
‎10-16-2018 08:13 AM
data NPOz; *[1]* input ID name source_url status category fax postal_address physical_address phone $reg_no $reg_date email_address category1 category2 category3 ; datalines; 143.655 Umusa_Wenkosi_Gospel_Ministries www.npo.gov.za Registered Development_and_Housing 113354483 P\B_X28_Johannesburg_2006 "33Church_Street""Alberton""Johannesburg""2006" .............. 156.666 Mcmillan_House_of_Care www.npo.gov.za Application_Declined Health_Care 124568895 ........................... ; run; I tried my best to recreate the data in the data step but the actual data set is imported from an excel spreadsheet. ... View more

Looking for a string

by Calcite | Level 5 in SAS Programming
‎10-16-2018 07:31 AM
‎10-16-2018 07:31 AM
Please help: Using version 9.3 I have a dataset which is a list of NPO's around South Africa and is named NPOz. From the 26 variables one is named Address and as the name suggests it contains the physical addresses for all the observed NPO's. From the address variable, I want to extract the name of the city so as to keep those that are from Johannesburg and Pretoria and delete the rest. Please help me with the right code for this job. ... View more

Re: Reading Data

by Calcite | Level 5 in SAS Programming
‎09-25-2018 10:16 AM
‎09-25-2018 10:16 AM
Thank you   ... View more

Re: Reading Data

by Calcite | Level 5 in SAS Programming
‎09-25-2018 09:42 AM
‎09-25-2018 09:42 AM
This works in a way, it only displays the names of the files. I believe the next move is to write a code that imports the files and create datasets, am I correct?  Please explain the "tmp" in the code. Thank you for the response. ... View more

Re: Reading Data

by Calcite | Level 5 in SAS Programming
‎09-25-2018 09:31 AM
‎09-25-2018 09:31 AM
Thank you for the assistance ... View more

Reading Data

by Calcite | Level 5 in SAS Programming
‎09-25-2018 08:50 AM
‎09-25-2018 08:50 AM
Dear SAS Users I'm asked to research on "how to read a text file in SAS when a folder name is known but the file name is unknown". I checked all my notes but nothing is coming from there. ... View more

Create a date

by Calcite | Level 5 in SAS Data Management
‎05-17-2018 08:27 AM
‎05-17-2018 08:27 AM
Hello SAS users I have the attached kind of data:   I want to create a new variable, "date" which is a combination of the year and the number corresponding to the month (like this, 200810 to represent  Oct 2010) please assist me. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-05-2019 06:05 AM
Quick links